The current Search & Filter option is intuitive and great for quick and simple searches. However, it is lacking the flexibility to create more complex filters.
Example that is currently not possible:
- show me all transactions where the accounting code is 1000 and the amount is greater than $500
- show me all transactions where the accounting code is 1000 OR 1001 OR 1002 and the spend program is ABC
- show me all transactions where the employee is John OR Robert and the spend program is ABC OR CDE
- show me all transactions where the spend program is ABC but there is no receipt uploaded.
- show me all transactions where the accounting category is 1000 and the Employee is NOT John
A more database like query builder would be nice for such more complex queries. To make the above examples possible the query builder should have:
- operators like equal, does not equal, IN, greater than, smaller than, older than, newer than, last X days, etc.
- ability to group fields into conditions either with AND or with OR logic
Something like this would be nice: