It would be great to have advanced query options such as combine different ANDs or ORs in different combinations.
Example 1 (currently possible):
field1 = 'value1' AND field2 = 1 AND field3 = 'value3'
Example 2 (currently possible):
field1 = 'value1' OR field2 = 1 OR field3 = 'value3'
Example 3 (currently not possible):
field1 = 'value1' AND field2 = 1 OR field3 = 'value3'
Example 4 (currently not possible):
field1 = 'value1' AND (field2 = 1 OR field3 = 'value3')
So maybe an option to switch to an advanced mode where the user can edit the sql statement with brackets and so on would be nice. Another ideas or solutions are very welcome.
It would be great to have advanced query options such as combine different ANDs or ORs in different combinations.
Example 1 (currently possible): field1 = 'value1' AND field2 = 1 AND field3 = 'value3'
Example 2 (currently possible): field1 = 'value1' OR field2 = 1 OR field3 = 'value3'
Example 3 (currently not possible): field1 = 'value1' AND field2 = 1 OR field3 = 'value3'
Example 4 (currently not possible): field1 = 'value1' AND (field2 = 1 OR field3 = 'value3')
So maybe an option to switch to an advanced mode where the user can edit the sql statement with brackets and so on would be nice. Another ideas or solutions are very welcome.