How to: access to the label of a LOV
Hi,
Sorry for the newbie question, but I've been searching on the internet and Oracle sites and didn't found anything to solve my problem.
I'm using BI Publisher 10g R3 to build a report with 2 LOV parameters and I would like to pass the value of the label to my template, so the question is:
- How can I access to the label of de LOV value selected?
I've have been trying to find a workarround.... but this envolve having a hidden parameter with 'default value' point to a value of a query.... is this possible?
exemple:
Q2:
SELECT 'sample' as thisValue from table_sample (--this only return one record)
Sorry for the newbie question, but I've been searching on the internet and Oracle sites and didn't found anything to solve my problem.
I'm using BI Publisher 10g R3 to build a report with 2 LOV parameters and I would like to pass the value of the label to my template, so the question is:
- How can I access to the label of de LOV value selected?
I've have been trying to find a workarround.... but this envolve having a hidden parameter with 'default value' point to a value of a query.... is this possible?
exemple:
Q2:
SELECT 'sample' as thisValue from table_sample (--this only return one record)
0