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
@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)
)
```
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
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.
@JohnEstropia commented on GitHub (Jul 28, 2019):
If I understood you correctly, I think it's something like this: