You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using EL Expressions to Filter an OTBI Report which is embedded in the application

edited Mar 4, 2021 4:09AM in Reporting and Analytics for HCM 1 comment

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:

  1. Using the El expression directly in the OTBI filter criteria
  2. 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>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!