Hello,
I have a table Table1 with fields Field1 and Field2 where I need to add complex ranges to a query.
Technically the following select statement needs to be replicated in a query object of the Table1 datasource:
select * from Table1
where (Table1.Field1==XXXStatus::Available || (Table1.Field1==XXXStatus::Unavailable && Table1.Field2 != 'A' && Table1.Field2 != 'B' && Table1.Field2 != 'C'))
Can anyone help me out how to implement this in a query range please?
