Hi Guys, does anybody know how to make a filter on...
# prisma-whats-newd
dohomi
05/19/2017, 7:26 PMHi Guys, does anybody know how to make a filter on a joined relation? I’d like to filter a list where the actual filter lookup is in a nested relation, similar to query WHERE statement of MySQL on a joined table? Is this somehow possible at the moment? Thanks!
y
yergi
05/19/2017, 7:30 PM@dohomi Yes, you just need make your filter a nested object as well. such as:
Copy code
allItems(filter: {otherThing: {name: "thing I want"}}) {
data
}d
dohomi
05/19/2017, 7:45 PM@yergi thanks for your answer.. I tried inside of the playground without success,I would need to nest 2 levels deep:
Copy code
toUsers_every:{client:{agentGroup:{id:"someID"}}}}dohomi
05/19/2017, 7:45 PMbut the result is every item..
y
yergi
05/19/2017, 7:47 PMDid you wrap it in the
(filter: )yergi
05/19/2017, 7:48 PM Copy code
toUsers_every(filter: {client: {agentGroup: {id: "someId"}}}) {
dataYouWantBack
}d
dohomi
05/19/2017, 7:51 PMit seems to work like this:
Copy code
allItems(filter:{toUsers_some:{client:{agentGroup:{id:"someId"}}}}){dohomi
05/19/2017, 7:51 PMI did not repeat the filter: keyword but changed _every => _some.. not sure why though
y
yergi
05/19/2017, 7:57 PMThere are special meta variables available when performing the filter function.
yergi
05/19/2017, 7:57 PMWhen referring to a reference, you can append
_some_none_everyyergi
05/19/2017, 7:58 PMWhen referencing a value inside a node, you can use
_lte_not_containsyergi
05/19/2017, 7:58 PMTo tell GraphQL the logic you want to use on that reference / value when filtering.
yergi
05/19/2017, 7:59 PM@nilan or someone else will need to explain the difference between
_some_everyn
nilan
05/19/2017, 7:59 PMHey @dohomi and @yergi 🙂
nilan
05/19/2017, 8:00 PMallItems(filer: {toUsers_some: { name: "Nilan"} })nilan
05/19/2017, 8:00 PMallItems(filer: {toUsers_every: { name: "Nilan"} })nilan
05/19/2017, 8:00 PMallItems(filer: {toUsers_none: { name: "Nilan"} })d
dohomi
05/19/2017, 8:01 PM@yergi @nilan so this is my query:
Copy code
filter:{OR:[
{toUsers_some:{client:{agentGroup:{id:"someId"}}}},
{fromUsers_some:{client:{agentGroup:{id:"someId"}}}}]})
==> WORKS :-)n
nilan
05/19/2017, 8:01 PM👍
d
dohomi
05/19/2017, 8:01 PMthanks for the heads up you both! cheers