how to specify a memo type field in xtkquerydef | Community
Skip to main content
P
priyankav251023
Level 2
December 6, 2018
Solved

how to specify a memo type field in xtkquerydef

  • December 6, 2018
  • 1 reply
  • 2333 views

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.

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 Jean-Serge_Biro

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

1 reply

Jean-Serge_Biro
Jean-Serge_BiroAccepted solution
Level 10
December 7, 2018

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

Terms & ConditionsAccessibility statement

Loading footer...