Converting Oracle SQL query to queryDef Syntax | Community
Skip to main content
christopherp612
christopherp612
Level 2
November 27, 2018
Solved

Converting Oracle SQL query to queryDef Syntax

  • November 27, 2018
  • 1 reply
  • 1895 views

Hello,

I am trying to convert a query that was originally written in Oracle SQL into JS QueryDef api syntax.  I am following the document link below which is straight forward for the most part, but I am trying to understand if the QueryDef api has two functions (listed below) that Oracle SQL uses.  I have not been able to find it in this adobe document or the chm file, hence I am creating this question in the forum.

Link to queryDef API Adobe document:

Data oriented APIs

1)  DENSE_RANK:  DENSE_RANK

Are there any special functions in the queryDef API similar to dense rank?

2)  CASE:  CASE Expressions

How do we go about using case expressions in the queryDef API?  Do we specify the if condition directly in the <select> tag?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    Hi,

    You can expose the functions you need by following this guide:

    Adding additional SQL functions

    Thanks,

    -Jon

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    January 4, 2019

    Hi,

    You can expose the functions you need by following this guide:

    Adding additional SQL functions

    Thanks,

    -Jon

      Terms & ConditionsAccessibility statement

      Loading footer...