Corestore fetch over one to many with where clause #282

New Issue

Open

opened 2025-12-29 15:28:09 +01:00 by adam · 1 comment

adam commented 2025-12-29 15:28:09 +01:00

Owner

Copy Link

Originally created by @Pratik-Sodha on GitHub (Jul 19, 2019).

I have above structure.

Description : Server entity have three attributes.
Name - Type
localId - UUID
serverId - UUID
SyncFlag - Int16.

SyncFlag have three possible values. [1,2,3]. 1 for insert, 2 for update and 3 for delete.

Now, requirement is that, Want to fetch one employee with related projects using employee serverId. But not want that projects which project status is deleted.

Any help appreciated :)

Thank you.

Originally created by @Pratik-Sodha on GitHub (Jul 19, 2019).  I have above structure. Description : **Server** entity have three attributes. **Name** - **Type** _localId_ - UUID _serverId_ - UUID _SyncFlag_ - Int16. SyncFlag have three possible values. [1,2,3]. 1 for insert, 2 for update and 3 for delete. Now, requirement is that, Want to fetch one employee with related projects using employee serverId. But not want that projects which project status is deleted. Any help appreciated :) Thank you.

adam added the question label 2025-12-29 15:28:09 +01:00

adam commented 2025-12-29 15:28:10 +01:00

Author

Owner

Copy Link

@JohnEstropia commented on GitHub (Jul 28, 2019):

If I understood you correctly, I think it's something like this:

let serverId = // ...
let employee = dataStack.fetchAll(
    From<Employee>()
        .where((\.sync ~ \.serverId).any() == serverId)
)

@JohnEstropia commented on GitHub (Jul 28, 2019): If I understood you correctly, I think it's something like this: ```swift let serverId = // ... let employee = dataStack.fetchAll( From<Employee>() .where((\.sync ~ \.serverId).any() == serverId) ) ```

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

develop

master

prototype/concurrency

minIOS13

prototype/containers

transactionSourceTracking

prototype/swiftui

minIOS11

swift5_3

prototype/propertyWrapperFields

prototype/propertyWrappers

prototype/propertyWrapper

Swift5

throwables

prototype/Swift_4_1

prototype/Swift_4_0

prototype/Swift_3_2

prototype/queryBuilders

temp/develop

corestore4_develop

prototype/mainContextToPSC

master_ios_7_to_9

swift_2_3

gh-pages

_corespotlight-test

9.3.0

9.2.0

9.1.0

9.0.0

8.1.0

8.0.1

8.0.0

7.3.1

7.3.0

7.2.0

7.1.0

7.0.4

7.0.3

7.0.2

7.0.1

7.0.0

6.3.2

6.3.1

6.3.0

6.2.1

6.2.0

6.1.0

6.0.0

5.3.1

5.3.0

5.2.0

5.1.1

5.1.0

5.0.0

4.2.4

4.2.3

4.2.2

4.2.1

4.2.0

4.1.4

4.1.3

4.1.1

4.1.0

4.0.5

4.0.4

4.0.3

4.0.2

4.0.1

4.0.0

4.0.0-beta3

4.0.0-beta2

4.0.0-beta

3.1.1

3.1.0

3.0.3

3.0.2

3.0.1

3.0.0

2.1.3

2.1.2

2.1.1

2.1.0

2.0.6

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

1.6.10

1.6.9

1.6.8

1.6.7

1.6.6

1.6.5

1.6.4

1.6.3

1.6.2

1.6.1

1.6.0

1.5.4

1.5.3

1.5.2

1.5.1

1.5.0

1.4.4

1.4.3

1.4.2

1.4.1

1.4.0

1.3.6

1.3.5

1.3.4

1.3.3

1.3.2

1.3.1

1.3.0

1.2.1

1.2.0

1.0.2

1.0.1

1.0.0

0.2.1

0.2.0

0.1.2

0.1.1

0.1.0

Labels

Clear labels

abandoned

corestore bug

discussion

duplicate

enhancement

fixed

fixed

help wanted

in progress

investigating

ios/compiler bug

irreproducible

looking for workarounds

not a bug

pending

pending docs update

pull-request

Mirrored from GitHub Pull Request

question

regression

user bug

wontfix

No Label question

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

adam

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/CoreStore#282