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


Level 1


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:



6 Replies


Community Advisor

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

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


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


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



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




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)





Level 5

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


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

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. 







Hello ,

Can you please take a look at


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.