Does any one know how to modify this query to show only workflow with an "active" staus or all non-

Pat_Lipnicky

the query is:

select WSubWork.SubWork_Title, KUAF.Name, WWork.Work_WorkID
 from 
 WWork,  KUAF , WSubWork
 where 
KUAF.ID = WWork.Work_ManagerID
 and 
WWork.Work_WorkID= WSubWork.SubWork_WorkID
order
 by WWork.Work_ManagerID

 

Colin_Schmidt

The supplied/canned WF Status LR is inaccurate.  I wrote a couple of LRs to segregate what was in the Vol.  This 1^st one counts based on the various status’.

select case
when waw.work_status = -2 then 'WF Stopped'
when waw.work_status = -1 then 'WF Completed'
when waw.work_status = 1 and waw.subwork_status = -1 then 'WF Suspended'
when (waw.work_status = 1 and waw.subwork_status = 1) or (waw.work_status = 2) then 'WF Active'
else 'Other ['||to_char(waw.work_status)||'/'||to_char(waw.subwork_status)||']' end ALLSTAT,
count(*)
from webactivework waw
group by
case
when waw.work_status = -2 then 'WF Stopped'
when waw.work_status = -1 then 'WF Completed'
when waw.work_status = 1 and waw.subwork_status = -1 then 'WF Suspended'
when (waw.work_status = 1 and waw.subwork_status = 1) or (waw.work_status = 2) then 'WF Active'
else 'Other ['||to_char(waw.work_status)||'/'||to_char(waw.subwork_status)||']' end
order by count(*) desc

 

This next one counts a little differently:

select case waw.work_status
when -3 then 'WF Archived[-3]'
when -2 then 'WF Stopped[-2]'
when -1 then 'WF Completed[-1]'
when 1 then 'WF Suspended[1]'
when 2 then 'WF Executing[2]' end WFstate,
case waw.subwork_status
when -1 then 'SubWF Done[-1]'
when 1 then 'SubWF Executing[1]' end SUBWFState,
case
when waw.work_status = -2 then 'WF Stopped'
when waw.work_status = -1 and waw.subwork_status in (-1,1) then 'WF Completed'
when waw.work_status = 1 and waw.subwork_status = -1 then 'WF Suspended'
when (waw.work_status = 1 and waw.subwork_status = 1) or (waw.work_status = 2) then 'WF Active'
else 'Other ['||to_char(waw.work_status)||'/'||to_char(waw.subwork_status)||']'end ALLSTAT,
count(*)
from webactivework waw
group by case waw.work_status when -3 then 'WF Archived[-3]' when -2 then 'WF Stopped[-2]' when -1 then 'WF Completed[-1]' when 1 then 'WF Suspended[1]' when 2 then 'WF Executing[2]' end,
case waw.subwork_status when -1 then 'SubWF Done[-1]' when 1 then 'SubWF Executing[1]' end,
case
when waw.work_status = -2 then 'WF Stopped'
when waw.work_status = -1 and waw.subwork_status in (-1,1) then 'WF Completed'
when waw.work_status = 1 and waw.subwork_status = -1 then 'WF Suspended'
when (waw.work_status = 1 and waw.subwork_status = 1) or (waw.work_status = 2) then 'WF Active'
else 'Other ['||to_char(waw.work_status)||'/'||to_char(waw.subwork_status)||']'
end
order by count(*) desc

 

 

 

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, September 23, 2016 10:27 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Does any one know how to modify this query to show only workflow with an "active" staus or all non-archived workflows

 

Does any one know how to modify this query to show only workflow with an "active" staus or all non-archived workflows

Posted by Lipnicky, Pat On 09/23/2016 10:21 AM

 

the query is: select WSubWork.SubWork_Title, KUAF.Name, WWork.Work_WorkID  from   WWork,  KUAF , WSubWork  where  KUAF.ID = WWork.Work_ManagerID  and  WWork.Work_WorkID= WSubWork.SubWork_WorkID order  by WWork.Work_ManagerID

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

 

---

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.