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

SOLVED

how to specify a memo type field in xtkquerydef

priyankav251023
Level 3
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
Jean-Serge_Biro
Correct answer by
Community Advisor
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
Jean-Serge_Biro
Correct answer by
Community Advisor
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