does anyone know if I can use brackets in user queries?
AND (C_Country_ID = 107 or C_Country_ID = 231)
OR C_Country_ID IN (107, 231)
No, is not possible. We can not identify the search field like this.Neither can you write C_Country_ID IN (107, 231) .
C_Country_ID IN (107, 231)
You can write only sql that can be also generated using advanced search in swing.