Offer Advanced Find / Query Builder to search / query transactions and reimbursements in one list

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:

1 Like