Categories
Dataset wildcard filtering
Description
It would be nice to have the ability to filter datasets based on a filter containing a wildcard rather than having to explicitly choose values to include or exclude. I realize this can be done with an SQL statement, but adding the ability to use a "Like" for instance with a value of '<character>%' would be an enhancement.
Use Case and Business Need
If new values meeting the criteria are added in the datasource, the dataset would capture those values upon a dataset reload or a live connection. Currently, the dataset must be defined with explicit values for filtering.
Original Idea Number: 39050b93e9
Comments
-
Agreed. If we have to write anything in SQL, then what' the purpose of the tool. 99% of my users do not know the SQL workarounds. This is supposed to be a tool for end users.
0 -
We have the ability to create expression filters in dataset. Click + sign on filter bar and select expression filter
0 -
This feature is available in OAC August 2021 (6.2) update.
0
