I have a list of file groups with tags. Assume th...
# prisma-whats-newl
lawjolla
03/12/2018, 5:29 PMI have a list of file groups with tags. Assume that this is my data (only one file group):
https://cl.ly/1u3h1k0o3j0y
I want to return that same data by selecting the tag enums "ImageHero" and "ImageVehicle", however the following query returns empty. Any ideas on my error?
https://cl.ly/453H1g0C3F1w
j
johannpinson
03/12/2018, 5:59 PMAnd if you change the
ANDORl
lawjolla
03/12/2018, 6:01 PMThen all file groups with ImageHero or ImageVehicle come back. In other words, file groups without
ImageHeroj
johannpinson
03/12/2018, 6:07 PMAnd if you add the last tag
ImageScalel
lawjolla
03/12/2018, 6:14 PMThe last tag isn't relevant to the query.
I need
Copy code
SELECT * from fileGroups
JOIN tags_fileGroups as jointable
ON fileGroups.ID = jointable.fileGroupId
JOIN tags
ON tags.id = jointable.tagsId
WHERE tags = 'ImageHero' and tags = 'ImageVehicle'j
johannpinson
03/12/2018, 6:16 PMhum... the query seems good
l
lawjolla
03/12/2018, 6:17 PMThat's what I'm saying 🤣😢
j
johannpinson
03/12/2018, 6:17 PM^^
johannpinson
03/12/2018, 6:18 PMand what about make directly a array of the enum instead a array of the type “tag”?
johannpinson
03/12/2018, 6:18 PMjohannpinson
03/12/2018, 6:20 PMis it work is you just add one tag?
l
lawjolla
03/12/2018, 6:21 PMyes...
AND: [{ tag: ImageHero }]lawjolla
03/12/2018, 6:23 PMI have a feeling I'm misusing
ANDj
johannpinson
03/12/2018, 6:24 PMmaybe, without the playground i can test some queries
johannpinson
03/12/2018, 6:24 PMbut @nilan may have the solution?
n
nilan
03/12/2018, 6:27 PMtags = 'ImageHero' and tags = 'ImageVehicle'
nilan
03/12/2018, 6:27 PMthis is never true.
nilan
03/12/2018, 6:27 PMI don't understand your requirement. A string can only be one value at a time.
nilan
03/12/2018, 6:28 PMoh
l
lawjolla
03/12/2018, 6:28 PMMaybe I'm SQL rusty. I want to return nodes where both tags are present
n
nilan
03/12/2018, 6:28 PMmaybe this is what you want
nilan
03/12/2018, 6:29 PM Copy code
where: { AND: [{tags_some: {tag: "a" }}, {tags_some: {tag: "b" }}] }nilan
03/12/2018, 6:29 PMwill select file groups that have at least one related tag
abl
lawjolla
03/12/2018, 6:30 PMNilan wins!
😎 2
👏 1
n
nilan
03/12/2018, 6:30 PMyour original query said "all file groups that have at least one related tag, and that tag is
al
lawjolla
03/12/2018, 6:31 PMInteresting. I'm going to need to process that one in my head. Thanks for the explanation!
👍 1
2 Views