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