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

The 4th edition of the Campaign Community Lens newsletter is out now!
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
Community Advisor

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
Community Advisor

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