Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
