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

User should allow to switch/Select Bind parameters in Filters.

Rajakumar Burra

We have list of bugs with different conditions. I have created three different Parameter with logical SQL and with multiple selection and type as Integer/Double. This parameter bind to bugs ID column. It is working well for binding one parameter to filter.

But user want to switch bind parameter to see other bugs list with different conditions.

I know using Calculation, we can define column selector. Since parameter initial value using logical SQL parameter, it is not allowing to use logical SQL in parameter in Calculation.

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Gabby Rubin-Oracle

I don't understand what you are trying to do and why you went down this path. At the basic level, it seems that you want to drive the selections based on a different selection, but if that is the case, why not use the parameter to filter the list instead of binding parameters with different lists? (putting a side the fact that bonded parameters will not impact a column's possible selections).

Rajakumar Burra

@Gabby Rubin-Oracle

Here is my use case.

I have bugs depends on multiple conditions. For example, I want to get list of Bugs related to fix in one release which are filtered based on multiple conditions. Conditions and filter criteria is complex. Similarly list of bugs for other release as well.

My query/filter is dependent on list of other selection queries with AND/OR.

I am able to get that list of bug ids with logical SQL query in Parameters. Unfortunately, same logical query is not working in expression filters. Or may be I am not aware of it.

Also, I am unable to find way to use Parameter with Logical query result output is Integer/Double with 100s of list items in expression filters/Calcuations. My Parameter initial value is also Logical query.

If we allowed to switch Parameter in binding for users, it will help.

Gabby Rubin-Oracle

It will be helpful to see your expression to understand why it does not work in an expression filter. If you cannot share publicly, please open an SR on this issue.

Rajakumar Burra

Thanks @Gabby Rubin-Oracle .Below is the typical simplified query.

SELECT

"XYZ-Reporting"."Bug"."Bug ID" s_1

FROM "XYZ-Reporting"

WHERE

(("Bug Task"."Release Stream" = 'RS 6.1') AND ("Bug Task"."Bug Task State" NOT IN ('Cancelled', 'Done')) AND ("Bug Task"."Bug Task Category" = 'Dev') AND (("Bug"."Bug ID" IN (SELECT "Bug"."Bug ID" saw_0 FROM "XYZ-Reporting" WHERE ("Bug Task"."Bug Task Resolved As" = 'Fixe') AND ("Bug Task"."Expected Release Stream" IN ('RS 4.0','RS 4.1','RS 5.0','RS 5.1'))))))

ORDER BY 1 ASC NULLS LAST

FETCH FIRST 1000001 ROWS ONLY

Gabby Rubin-Oracle

We are working on a different feature that will allow these query scenarios, the direction is to enable a filter to be defined on an outcome of a viz. However, trying to understand the user access to such features, currently, these are still author use cases with the possibility that a consumer might be able to use pre-defined selections, but creating new ones might be more complex.

Rajakumar Burra

@Gabby Rubin-Oracle Creating new parameters from user is not recommending. But user should allow to use apply existing parameters in filters.