I need to look for a specific text in all the existing delivery templates. However when I tried building a workflow to fetch the HTML content of the templates, the field is missing in nms:delivery schema - snapshot below. I guess there should be a content(source) field under HTML content (html).
I'm on 7.3.3 build 9359. Also, I have got the administrative access.
Is there any other option to achieve this?
Hello @rajeshbhat, the content is not stored in the SQL database, so you can't query it BUT you can use the field data with a regular expression. Take a look:
The "data" field contains all the XML that forms a delivery. The content is between <content> and </content>, so you can make this query:
This is a regular expression that searchs what deliveries have in their html content "Hola!", you can change it with the string you need to query.
(Expression: data, Operator: like, Value: %<content%stringtoquery%</content>%)
Hope this helps, regards.
Heku
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.