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

Offer Eligibility dynamic query retrieval

Avatar

Avatar
Affirm 5
Level 3
adithyacs86
Level 3

Likes

22 likes

Total Posts

107 posts

Correct Reply

5 solutions
Top badges earned
Affirm 5
Validate 10
Validate 1
Give Back 5
Give Back 3
View profile

Avatar
Affirm 5
Level 3
adithyacs86
Level 3

Likes

22 likes

Total Posts

107 posts

Correct Reply

5 solutions
Top badges earned
Affirm 5
Validate 10
Validate 1
Give Back 5
Give Back 3
View profile
adithyacs86
Level 3

20-01-2021

Hi, 

 

I have a requirement to extract the dynamic query condition that is a part of the offer eligibility criteria

adithyacs86_0-1611211020292.png

 

we can get this in the offer table. 

adithyacs86_2-1611211200178.png

 

But want to retrieve the humanCond and then query the same in the query activity. 

 

Requesting for any suggestions on how to read the dynamic entries and query the same in the query activity. 

 

Thanks,
Adithya

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

164 likes

Total Posts

382 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

164 likes

Total Posts

382 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

25-01-2021

Hi @adithyacs86,

these conditions are not stored as a independent column in database. They are just a part of offer XML code stored in MDATA column (memo).

In order to see them in AC, use Query Editor, pick nms:offer table and click on the preview tab, rigth click / Configure List and add field filter/humanCond - this will list conditions in the offers to be viewed or copied. You may export one offer as a package and check definition and condition structure.

Regards,

Milan