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
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Filter query using NVL not working

    edited Apr 12, 2021 12:49PM in Reporting and Analytics for HCM 10 comments

    Summary

    Unable to save query when trying to use the NVL command with a logical sql

    Content

    Hi All,

    I hope someone is able to help me with an issue that I am having.

    I have a query that I am trying to allow the users to select a specific employee OR select all employees if the parameter is left blank

    I tried to add the following condition to my query and "Worker"."Person Number" = nvl(:person_number, "Worker"."Person Number") but my query fails to load SQL so I can't save the condition.

    Then I tried and ("Worker"."Person Number" is not null OR "Worker"."Person Number" = :Person_number) but this didn't appear to work either

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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