Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

how to specify a memo type field in xtkquerydef

Avatar

Level 3

i want to select mdata type of field eg visualState in xtk:workflow, how to specify this attribute in querydef call

eg

var query = xtk.queryDef.create(

<queryDef schema={schemaName} operation="select" lineCount="1">

  <select>

    <node expr="visualState" alias="@visualState"/>

  </select>

  <where>     

    <condition expr={condition} />   

  </where>

</queryDef>

is this correct or is there special syntax to select such elements.

my javascript activity is hanging when i execute this query. it works fine when some simple attribute or element is specified for selection.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Priyanka,

Your syntax is correct, but you were unlucky with your test.
If you replace visualState by the other memo (mdata) field in xtk:workflow, called data, it works fine:

<node expr="data" alias="@data"/>

For me as well the workflow hangs when I use;
<node expr="visualState" alias="@visualState"/>

It seems the binary data (an image) can't be manage by a standard queryDef, probably you must use buffer manipulation to manage image.

Regards.
J-Serge

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Hi Priyanka,

Your syntax is correct, but you were unlucky with your test.
If you replace visualState by the other memo (mdata) field in xtk:workflow, called data, it works fine:

<node expr="data" alias="@data"/>

For me as well the workflow hangs when I use;
<node expr="visualState" alias="@visualState"/>

It seems the binary data (an image) can't be manage by a standard queryDef, probably you must use buffer manipulation to manage image.

Regards.
J-Serge