Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Converting Oracle SQL query to queryDef Syntax

Avatar

Avatar
Validate 1
Level 2
christopherp612
Level 2

Likes

4 likes

Total Posts

4 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
christopherp612
Level 2

Likes

4 likes

Total Posts

4 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
christopherp612
Level 2

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

04-01-2019

Hi,

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

Adding additional SQL functions

Thanks,

-Jon

Answers (0)