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.
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.