order by value of parameter in select statement in BI Publisher 12c
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.