The GET Custom/{resourceName} allows you to retrieve data from a local table in Tessitura. It allows you to do exact field matching (i.e. ?column1=value1&column2=value2).
It would be very helpful to have additional filtering options.
1. Do a "fuzzy" text search. i.e. only need the search to be be contained in the field, not an exact match.
2. Search by date range. i.e. find all records where a date is field is before/after a date. Right now it does an exact date match.
Without these types of filters we have to fallback to either:
1. Writing a sproc - which defeats the purpose of this endpoint
2. Retrieving all the data and filtering server side - which is inefficient and potentially very slow based on amount of data in the table.
Thanks for considering!