Suggested by Owen Spottiswoode – New
Currently it is not possible to set up queries through advanced find that use the AND/OR operators - you simply cannot select them as part of a group. For example, the following query would not be possible through Advanced Find: select all records from the 'bookings' entity where the 'orders' related record does not contain data OR where the 'invoices' related record does not contain data. This severely limits how useful this tool is and means we have data spread across several views that should really be contained in one.
For bonus marks, it would be great if we could use IF statements in Advanced Find. for example: find all records in the 'orders' entity where 'status' is 'uninvoiced' and IF 'booking type' == 'event' filter records where 'booking' related record status is 'active'.