Offer Eligibility dynamic query retrieval | Community
Skip to main content
adithyacs86
adithyacs86
Level 5
January 21, 2021
Question

Offer Eligibility dynamic query retrieval

  • January 21, 2021
  • 1 reply
  • 1126 views

Hi, 

 

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

 

we can get this in the offer table. 

 

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Milan_Vucetic
Milan_Vucetic
Level 9
January 25, 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

adithyacs86
adithyacs86Author
Level 5
January 27, 2021
Hi Milan, I get that point, I have checked that part, but want to make this filter query (which is a human condition) work in the normal query activity in an automated way. Like suppose " I create a new offer with some eligibility rules and then on the other side, I have to get eligible recipients from the query activity in a different workflow through an automated way" . Thanks,
Terms & ConditionsAccessibility statement

Loading footer...