Extract error log from workflow log table using querydef | Community
Skip to main content
H
hemantsharma
Level 2
February 19, 2018
Solved

Extract error log from workflow log table using querydef

  • February 19, 2018
  • 3 replies
  • 1908 views

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!!

    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 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 replies

    Jean-Serge_Biro
    Jean-Serge_BiroAccepted solution
    Level 10
    February 19, 2018

    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

    H
    hemantsharmaAuthor
    Level 2
    February 20, 2018

    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.

    Jean-Serge_Biro
    Jean-Serge_Biro
    Level 10
    February 20, 2018

    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

      Terms & ConditionsAccessibility statement

      Loading footer...