Akenefick
4 years agoGenius
Using OR and AND with LiQL constraints.
I am trying to use ORs and ANDs with a LiQL query using parentheses to group my ORs like this:
WHERE kudos.sum(weight) < 2 AND (status.key="new" OR status.key="needs_info")
It is apparently only paying attention to the first constraint inside the parentheses. I have done this successfully before with body and subject keywords like this:
WHERE labels.text = 'headphones' AND (body MATCHES "wireless" OR subject MATCHES "wireless")
Is grouping like that allowed or is the body subject a special case? Can't figure out what I'm doing wrong. Thanks.