Expand my Community achievements bar.

SOLVED

Extract error log from workflow log table using querydef

Avatar

Level 2

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

1422371_pastedImage_0.png

error:

1422373_pastedImage_2.png

1422376_pastedImage_5.png

Please suggest some solution

Thanks in advance!!

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

3 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 2

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.

Avatar

Level 10

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