how to specify a memo type field in xtkquerydef

[priyankav251023]

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.

[Jean-Serge_Biro · Accepted solution]

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