Query Blocking Does Not Work For SQL Based Filters In Oracle Analytics (Doc ID 2785806.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Symptoms

Query blocking has been configured, which includes a validation for filter using following function: !tValidator.filterExists()
This function ensures that a filter is applied on a particular column. Else, a pop up appears asking the user to use a filter. This works as expected when user chooses a value from the filter dropdown.
However, if user edits the filter and opts for SQL expression, then the validator function does not recognize the prompt and it throws the pop up asking user to choose a filter.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.