Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Query Subject Line using querydef

Avatar

Level 1

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!

6 Replies

Avatar

Community Advisor

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

Avatar

Level 1

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

Avatar

Community Advisor

Hi ,

 

var queryDemo = xtk.queryDef.create(

<queryDef operation="select" schema="nms:broadLogRcp" xtkschema="xtk:queryDef">

<select> <node expr="[delivery/mailParameters/subject]" label="Subject (Delivery/Email header parameters)" alias="@subject"/>

</select>

<sysFilter>

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

</queryDef>

);

 

To see the result after above code add below code

var output = queryDemo.ExecuteQuery();

for each(var rec in output)

{

logInfo(" Subject line "+ rec.@subject)

}

 

Thanks

Avatar

Level 5

Hi Kapil, I have tried doing the same like below:-

 

var query = xtk.queryDef.create(
<queryDef schema="temp:enrich" operation="select">
<select>
<node expr="@deliveryID"/>
</select>
</queryDef>)

var res = query.ExecuteQuery();
for each(var element in res){

delivery = NLWS.nmsDelivery.load(element.@deliveryID)

subject = delivery.mailParameters.subject;

logInfo("delivery =" + element.@deliveryID + "Subject= " + subject);

sqlExec("update "+vars.tableName +" set ssubjectLine='"+subject+"'");

 

I can get the log Info of the deliveries of the subject line. But I am not able to load the data to the variable that I have created in the previous enrichment activity, which is the sqlExec code just after the logInfo in the above script. 

 

Requesting for an help. 

 

Thanks,

Adithya

 

Avatar

Employee

Hello ,

Can you please take a look at 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic/export-subject-or-in-general...

 

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