LiveReport with Link/Details that will open a workflow

I want a LiveReport to query status of workflows. First report would give type of workflow (selectable), date range, and status, I then want to drill into specific workflows.Is this possible?I've looked at the KC and found something saying wf status by ID, but it's a single layer report.

Find more posts tagged with

Comments

Jeff_Brown_(G*_ECM_Champ)

Message from Brown, Jeff via eLinkYou might want to play around with the standard LiveReports, there aresome workflow reports that could be used as a start. Yes this ispossible.Jeff -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Monday, July 21, 2008 7:30 PMTo: eLink RecipientSubject: LiveReport with Link/Details that will open a workflowLiveReport with Link/Details that will open a workflowPosted by Vital, Christine on 07/21/2008 07:26 PMI want a LiveReport to query status of workflows. First report wouldgive type of workflow (selectable), date range, and status, I then wantto drill into specific workflows.Is this possible?I've looked at the KC and found something saying wf status by ID, butit's a single layer report.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.*****************************NOTICE - This message is intended only for the use of the individual or entity to which it is addressed and may contain information which is privileged, confidential or proprietary. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, arrive late or contain viruses. By communicating with us via e-mail, you accept such risks. When addressed to our clients, any information, drawings, opinions or advice (collectively, "information") contained in this e-mail is subject to the terms and conditions expressed in the governing agreements. Where no such agreement exists, the recipient shall neither rely upon nor disclose to others, such information without our written consent. Unless otherwise agreed, we do not assume any liability with respect to the accuracy or completeness of the information set out in this e-mail. If you have received this message in error, please notify us immediately by return e-mail and destroy and delete the message from your computer.

Tim_Hunter

I don't have a report offhand which will give you your first report, but the second would be based off something like this.SELECT sw.subwork_title, w.work_dateinitiated, u.nameFROM wwork w, wsubwork sw, kuaf uWHERE w.work_workid = sw.subwork_workid(+) AND w.work_ownerid = u.id(+)

Christine_Vital

Thank you Tim, I've sent this on to our SQL guy... I'm crossing my fingers!!! I think he has a solution to the first report.