Is it possible to filter in WHERE clauses using wildcards?
For example, I would like to search and filter on invoices that have a reference of '%MY_SEARCH_TERM%' as a wildcard filter as invoice references are not standardised in Xero when invoices are being created.
Is this currently possible? Can't seem to locate any documentation around this.
Is it possible to filter in WHERE clauses using wildcards?
For example, I would like to search and filter on invoices that have a reference of '%MY_SEARCH_TERM%' as a wildcard filter as invoice references are not standardised in Xero when invoices are being created.
Is this currently possible? Can't seem to locate any documentation around this.