nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Delivered

Data Modelling and Datasets

Status: Delivered

Comments

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.