Dataset wildcard filtering

Sean McArthur

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

Branden Pavol

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.

Nicolas Barasz-Oracle

We have the ability to create expression filters in dataset. Click + sign on filter bar and select expression filter

Pravin Janardanam-Oracle

This feature is available in OAC August 2021 (6.2) update.