Converting Oracle SQL query to queryDef Syntax

[christopherp612]

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?

[Jonathon_wodnicki · Accepted solution]

Hi,

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

Adding additional SQL functions

Thanks,

-Jon