Query Database

Question

I am trying to query the database through a script in a web app, but when providing the country location in the database, it is throwing an error. The folder is gmlocation/country under recipients. This is the error below.

Attribute 'country' unknown (see definition of schema 'Recipients (nms:recipient)'). XTK-170036 Unable to parse expression '@country='CAN''. SOP-330011 Error while executing the method 'ExecuteQuery' of service 'xtk:queryDef'.

Here is an sample of the script I am trying to query.

var query = xtk.queryDef.create(
  
  <queryDef schema="nms:recipient" operation="getIfExists">
    
    <select>
   
      <node expr="@email"/>
      
      <node expr="@id"/>
    
    </select>
   
    <where>
    
    <condition expr={"@email='"+ctx.recipient.@email+"'"}/>
    <condition expr={"@sourceType='Media'"}/>
    <condition expr={"@country='CAN'"}/>
     
    </where>
    </queryDef>

Marcel_Szimonisz · Answer

Hello @justinbr17,country is to found under [location/@countryCode] and it is ISO A2 not A3 so you condition should be   <condition expr={"[location/@countryCode]='CA'"}/>    Marcel SzimoniszMarTech Consultantfor more tips visit my bloghttps://www.martechnotes.com/

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded