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

Learn more

View all

Sign in to view all badges

Query Subject Line using querydef

acdbm
Level 1
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
kapilKochar
Community Advisor
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>

acdbm
Level 1
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

kapilKochar
Community Advisor
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

adithyacs86
Level 5
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

 

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