BI Publisher (MOSC)

MOSC Banner

order by value of parameter in select statement in BI Publisher 12c

edited Oct 23, 2018 2:46PM in BI Publisher (MOSC) 6 commentsAnswered

Hello everyone,

I'm new to Publisher and just starting the process of converting our company's 300+ reports to BI Publisher 12c. I'm having trouble in a select statement when trying to use a parameter's value to complete the "order by" part of the select statement.

To better explain:

1) I have a parameter that we'll call "v_param1" that is getting the value from a List Of Values (which only has one value). The value from this LOV is a String that is actually the name of a column name in another table that we'll call "table_a".

2) I am attempting to create a Data Set from a SQL statement with its results sorted by the column name matching the value of the parameter listed in #1 above.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center