Brackets in User Queries

english

#1

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


#2

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