Converting Oracle SQL query to queryDef Syntax

christopherp612

27-11-2018

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?

Answers (0)