Using EL Expressions to Filter an OTBI Report which is embedded in the application
Content
Hi,
Is it possible to filter an embedded report based on contextual variables? For example the following EL expression #{bindings.DisplayName.inputValue} returns the name of the employee on the Performance Evaluation Page.
How would I use this expression to return data only for this specific employee?
So far I've tried the following:
- Using the El expression directly in the OTBI filter criteria
- Under the component properties for the report, I've tried adding an XML filter in the 'Promptfilterxml' text field.
Any help is appreciated.
Thanks
Code Snippet
<saw:filter> <sawx:expr xsi:type="sawx:list" op="like"> <sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Employee Display Name"</sawx:expr> <sawx:expr xsi:type="xsd:string">#{bindings.DisplayName.inputValue}</sawx:expr></sawx:expr></saw:filter>
0