Skip to main content
rntrp
Level 3
Jan 6, 2021 3:40 PM UTC
Question

Query Subject Line using querydef

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.

6 replies

kapilKochar
kapilKochar
Level 6
Jan 7, 2021 2:41 AM UTC

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

Translate
rntrpAuthor
Level 3
Jan 7, 2021 12:55 PM UTC

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

Translate
Adhiyan
Adobe Employee
AdhiyanAdobe Employee
Adobe Employee
Jan 27, 2021 2:44 PM UTC

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

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...