CA Service Management

Expand all | Collapse all

Query request reopen with workflow inactive

Jump to Best Answer
  • 1.  Query request reopen with workflow inactive

    Posted 01-23-2018 08:38 AM

    Hello Community, 

     

    is it possible to create a query for scoreboard that show me the request (cr) with 'reopen' status with workflow task complete or inactive?

     

    Regards.



  • 2.  Re: Query request reopen with workflow inactive
    Best Answer

    Posted 01-25-2018 05:36 PM

    Hi Joaquin,


    I doubt you can have stored query to return Request for status of workflow task because they are different objects corresponding to different tables.

     

    I checked some out of box Change Order Workflow task like My Pending Tasks. The where clause is:

         assignee = @cnt.id AND status = \'PEND\'

     

    So for workflow task with reopen status. You can have:

    status = \'REOPEN\'

     

    Regards,

    Derek



  • 3.  Re: Query request reopen with workflow inactive

    Posted 01-26-2018 02:48 AM

    Hello Derek, 

     

    Thank for your response. I think that I need it, It is not possible to do it. In query SQL I get it, but in query SD Scoreboard, not.

     

    Regards.



  • 4.  Re: Query request reopen with workflow inactive

    Posted 01-26-2018 04:54 AM

    Hi Joaquin,

     

    At this juncture, I believe it is not possible to create such a Stored Query to use on a Scoreboard. Best would be to you a report or SQL query as you have already discovered.

     

    ===

    Kind Regards,

    Brian

     



  • 5.  Re: Query request reopen with workflow inactive

    Posted 01-26-2018 10:07 AM

    I'm not quite sure, if I understand your question correctly.

    Are you looking for Requests in Status "reopen" which do have all Tasks complete?

    This would not be possible, because we don't have a query syntax available, which is able to do a comparison to a count of related records( check if all related Tasks are inactive/complete).
    Nevertheless, sometimes you could use query parts like an "if exists" condition.

    If my above assumption of what you are looking for is correct, you might try the following scoreboard query:

     

    type=\'R\' and active =1 and status.sym=\'reopen\' and persistent_id.[cr]workflow.status.task_complete=0

     

    This query will return all active requests in status=reopen , which do have at least one related task within a status, which does not flag the task as complete.

    This condition is more or less a synonym to your original question,as far as I understood.

     

    Hope that helps

    ............Michael



  • 6.  Re: Query request reopen with workflow inactive

    Posted 01-29-2018 12:29 PM

    Thanks Michael. The correct query is 

     

    Type=\'R\' and active =1 and status.sym=\'reopen\' and NOT (persistent_id.[cr]workflow.status.task_complete=0)

     

    This works OK!!!

     

    Thanks for your help.

     

    Regards.

     



  • 7.  Re: Query request reopen with workflow inactive

    Posted 01-26-2018 02:45 PM

    Joaquin, you can try

    ype=\'R\' and active =1 and status.sym=\'reopen\' and NOT (persistent_id.[cr]workflow.status.task_complete=0)

    thanks

    Chi



  • 8.  Re: Query request reopen with workflow inactive

    Posted 01-26-2018 02:45 PM

    it should be type=...I missed t in the type.



  • 9.  Re: Query request reopen with workflow inactive

    Posted 01-29-2018 12:28 PM

    Thanks Chi Chen, your query works nice!!!

     

    Best Regards.



  • 10.  Re: Query request reopen with workflow inactive

    Posted 01-30-2018 04:31 AM

    Hi Chi Chen,

     

    I have another question. I have tested that the query works if I have request with reopen status with inactive workflow, but If I reopen a workflow, this query with a workflow reopen continue to show in the node scoreboard. any idea?

     

    Thanks, 

     

    Regards.



  • 11.  Re: Query request reopen with workflow inactive

    Posted 02-07-2018 07:20 AM

    any idea?