xtk.queryDef.create Question | Community
Skip to main content
A
Anonymous
October 11, 2019
Solved

xtk.queryDef.create Question

  • October 11, 2019
  • 3 replies
  • 9917 views

I have a query activity that feeds into a javascript code activity. One of the columns of data that I am feeding from the query uses an aggregate function: count(products_purchased). I am using xtk.queryDef api to write pull the results from the query and need to figure out how to pull this column in the following javascript code: 

var query = xtk.queryDef.create(
     <queryDef schema={vars.targetSchema} operation="select"
          <select>
               <node expr={count(products_purchased)} />
          </select>
     </queryDef>
).ExecuteQuery();
for each( var row in query)
     logInfo("Total products purchased: " + row.count(products_purchased));
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by

    I think I figured it out. In the additional data column of the query where I added the aggregate function, I had an alias name. So when I call that column I need to do
    <node expr="alias-name" />

    ...

    row.alias-name

    3 replies

    A
    Anonymous
    Accepted solution
    October 11, 2019

    I think I figured it out. In the additional data column of the query where I added the aggregate function, I had an alias name. So when I call that column I need to do
    <node expr="alias-name" />

    ...

    row.alias-name

      Raj_Ganta-1
      Raj_Ganta-1
      Level 5
      October 11, 2019

      Hi,

      check this code from the link

      jobCount = NLWS.xtkQueryDef.create(
        <queryDef schema="nms:remaHypothesis" operation="get">
         <select>
         <node expr="Count(@id)" alias="@count"/>
         </select>
         <where>
         <condition expr={"@status="+HYPOTHESIS_STATUS_RUNNING}/>
         </where>
        </queryDef>)

      iJobCount = iJobCount + parseInt(jobCount.ExecuteQuery().@count)

      https://blog.floriancourgey.com/2018/08/use-querydef-the-database-toolkit-in-adobe-campaign

        Jyoti_Yadav
        Jyoti_Yadav
        Level 8
        October 15, 2019

        Hi Derek,

        Please use below script and it will give you output:

        var query = xtk.queryDef.create( 

             <queryDef schema={vars.targetSchema} operation="select">

                  <select> 

                       <node expr="Count(@id)" alias="var1"/> 

                  </select> 

             </queryDef> 

        ).ExecuteQuery(); 

         

         

        for each( var row in query) 

             logInfo("Total products purchased: " + row.var1); 

        Thanks,

        Jyoti

          Terms & ConditionsAccessibility statement

          Loading footer...