lawjolla
03/12/2018, 5:29 PMjohannpinson
03/12/2018, 5:59 PMAND
by a OR
?lawjolla
03/12/2018, 6:01 PMImageHero
will returnjohannpinson
03/12/2018, 6:07 PMImageScale
, you got it?lawjolla
03/12/2018, 6:14 PMSELECT * 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'
johannpinson
03/12/2018, 6:16 PMlawjolla
03/12/2018, 6:17 PMjohannpinson
03/12/2018, 6:17 PMjohannpinson
03/12/2018, 6:18 PMjohannpinson
03/12/2018, 6:18 PMjohannpinson
03/12/2018, 6:20 PMlawjolla
03/12/2018, 6:21 PMAND: [{ tag: ImageHero }]
returns all Image Hero tagged file groupslawjolla
03/12/2018, 6:23 PMAND
somehowjohannpinson
03/12/2018, 6:24 PMjohannpinson
03/12/2018, 6:24 PMnilan
03/12/2018, 6:27 PMtags = 'ImageHero' and tags = 'ImageVehicle'
nilan
03/12/2018, 6:27 PMnilan
03/12/2018, 6:27 PMnilan
03/12/2018, 6:28 PMlawjolla
03/12/2018, 6:28 PMnilan
03/12/2018, 6:28 PMnilan
03/12/2018, 6:29 PMwhere: { AND: [{tags_some: {tag: "a" }}, {tags_some: {tag: "b" }}] }
nilan
03/12/2018, 6:29 PMa
, and at least one related tag b
lawjolla
03/12/2018, 6:30 PMnilan
03/12/2018, 6:30 PMa
and `b`" which is always falselawjolla
03/12/2018, 6:31 PM