hi i show below a Suite QL query that is broken essentially (see exception) because of the word AND in the where clause. If i run it with just the entity=183 filter it is fine. If i run it with just the trandate filter it is fine. If i run it with OR instead of AND it runs fine. If i enclose one or both of the conditions in parentheses it breaks. When i pair the entity or the trandate filter with this clause (instead of what you see) "and 1=1", it runs fine. i dont really want to add the conditions to the on clause of the joins. But they do work when i do that. Id like to focus on what's wrong or different here from what i believe are query language standards internationally. And then perhaps talk about workarounds.