is it possible to create a query for scoreboard that show me the request (cr) with 'reopen' status with workflow task complete or inactive?
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\'
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.
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.
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
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.
Joaquin, you can try
ype=\'R\' and active =1 and status.sym=\'reopen\' and NOT (persistent_id.[cr]workflow.status.task_complete=0)
it should be type=...I missed t in the type.
Thanks Chi Chen, your query works nice!!!
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?