Extract error log from workflow log table using querydef

[#1]

Hi Team

I am trying to extract error code & message  from workflow log table for a particular wf using querydef but getting error.

JS code

error:

Please suggest some solution

Thanks in advance!!

[#2 · Accepted solution]

Hi hemantsharma,

The minus sign, in workflow-id name identifier, generates the error, due to Javascript syntax restriction.

So, you need to use the escaping syntax [@workflow-id] instead.
And please use the {}, it is better.

	<where>
	<node expr={[@workflow-id] = 123456789} />
	</where>

Regards

Jean-Serge

[#3]

Hi hemantsharma,

Please see below the limit parameter, and the order clause.

var param = '[@workflow-id] = 123456789';

var query = xtk.queryDef.create(

  <queryDef schema="xtk:workflowLog" operation="select" limit="30">

    <select>

      <node expr="@error"/>

      <node expr="[@workflow-id]"/>

    </select>

    <where>

      <node expr={param} />

    </where>

    <orderBy>

     <node expr="[@workflow-id]" sortDesc="true"/>

    </orderBy>   

  </queryDef>

);

By the way, might you declare as correct answer the post to complete this ticket (green status)?
Many thanks in advance.

Regards
JS

[#4]

Thanks Jean ,it worked but I am getting all error log ,my requirement is to get only latest error can you suggest some filtering condition

I am trying to use max(logdate) or max(@id) conditions but dont know syntax how to impelement, if there is any other way please suggest.