Query Subject Line using querydef | Community
Skip to main content
Level 3
January 6, 2021
Question

Query Subject Line using querydef

  • January 6, 2021
  • 2 replies
  • 2830 views

Hello,

I am trying to query the BroadLog for a specific subject line using querdef. What should the javascript code/query look like? The field I am trying to query is located here:

nms:broadLogRcp/delivery/mailParameters/subject 

Thanks!

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

2 replies

kapilKochar
Level 6
January 7, 2021

<queryDef operation="select" schema="nms:broadLogRcp"  xtkschema="xtk:queryDef">
<select>
<node expr="[delivery/mailParameters/subject]"
label="Subject (Delivery/Email header parameters)"/>
</select>

<sysFilter>
<condition>fill the condition you want</condition>
</sysFilter>
</queryDef>

rntrpAuthor
Level 3
January 7, 2021

Thanks. And then how do I view the results? Right now, in the journal it says:

Activity 'js': Transition 'done': The target activity is not specified

Adhiyan
Adobe Employee
Adobe Employee
January 27, 2021

Hello ,

Can you please take a look at 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic/export-subject-or-in-general-xml-field-in-export-template/td-p/293911

 

There are certain limitations while working with xml fields in QueryDef and loading the data of the subject into the variable could be a limitation.

 

--
Adhiyan