I can't understand what's wrong with my predication. I have the next database scheme:
DataItem(color_ids) <->> (dataItem)Color
Where Color contains colorID(int).
I tried to get
all DataItems that contain colorID == 5.
I have used the next predicate:
SUBQUERY(color_ids, $sub, $sub.colorID==5).@count > 0
Thanks for your help.
You don't need
SUBQUERY
for this. In fact, you almost never needSUBQUERY
; it is extremely rare to find a situation where it is the correct thing to use.You can do this instead: