Hoping someone might have some ideas on how to get more advanced filtering of a data source.
Scenario we need is as follows:
We have a JSON data source asset that hits an API endpoint and grabs all the data.
Example data set would be:
The user would have the option to search/filter on the following at the same time
- Item-Status - User can select any/all of 3 form check boxes on the front end which would then “Match on any condition” of the 3 possible status’s so will broaden the results the more check boxes that are selected.
- Item-name and Item-content - User enters values into form input fields for name and content on the front end which would “Match on all conditions” and therefore narrow down the results the more information that is entered.
- Item-date - User enters/selects one or both of start-date and end-date on the front end which would match any Item-date that falls between these dates
I can do 1 and 2 in isolation but there doesn’t seem to be a way to do both at the same time with record filters.
And I’m not sure 3 is possible at all.
Any idea if some/all of this is possible a different way or with SSJS possibly?