How to get Delivery Content in JS using queryDef?

Hello Folks,

I tried something like below:

var query = xtk.queryDef.create(

  <queryDef schema="nms:delivery" operation="select">

    <select>

      <node expr="[content/html/source]"/>

      <node expr="@label"/>

    </select>

    <where>

      <condition expr={"@internalName = '"+deliveryInternalName+"'"}/>

    </where>

  </queryDef>),result;

  result = query.ExecuteQuery();

  var statsResults = result.delivery;

for(var eachResp in statsResults)

{

  var deliveryLabel = statsResults[eachResp].@label;

  logInfo(deliveryLabel);

  //var deliveryContent = statsResults[eachResp].[content/html/source];

  var dataStr = sqlGetMemo("SELECT mData from nmsDelivery WHERE sInternalName="+eachResp.@internalName);

  //var dataXml = DOMDocument.fromXMLString(dataStr);

  //var content = dataXml.root.getValue("content/html/source");

}

But Unable to fetch content and getting various errors, since it is an XML Field stored under path: content/html/source, is there any specific way to access this? If so let me know!

Regards,

Sri Bhargav

Hi,

To fetch AEM content for a delivery, use nms.delivery.aemGetContent(delivery).

To select paths in queryDef, use alias="html" in the <node/> element.

Thanks,

-Jon