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?
