One of the customers has reported the following issue:
From mdata field, we want to extract the outputFile name–see attachment(mData_outputFile.png) for location, stored within outputFile=" ". We want to know the best way to transform this XML data type field to be passed as an enriched field within the campaign workflow. So that we can append into our promotion history table to store all the output file names.
Since, we know that mdata is an XML field and not a DB field to query upon it. But is there any method to achieve this scenario?
We can try to resolve this issue in two ways:
mdataof your delivery and then parse the XML. Store data in an instance variable to then load in transition
Customer had a follow up query which was as below:
We are trying to use the method of
mdata, which we were able to write. For the parse method, what is the recommended approach?
Your request will be like:
queryDef operation=“select” schema=“nms:delivery”
node expr=“output/@fileName” label=“Output file”/
condition expr=“@isModel = 0”/
node expr=“@lastModified” sortDesc=“true”/
And it will return: