Querying the Status of Livelink Tasks

We have a Livereport created in LL 9.2 that compares 2 tasks and provide a report on status for each tasks.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~select DTree.*, (LastName || ', ' || FirstName) as performername, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'OnHold') as mystatus from DTree, KUAF where KUAF.ID=DTree.Assignedto and DTree.Status IN('0', '1', '2', '3') and DTree.OwnerID IN('12006959', '13593480') and %1 order by DTree.DateDue~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~After our upgrade to LL 9.7.1, the Livereport is no longer working. The tables that this Livereport is calling are still present in the in the 9.7.1 schema so I don't understand or know how to troubleshoot.Has anyone ran into this problem?

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

There is a new table called Assignees. For details, see:

https://knowledge.opentext.com/knowledge/llisapi.dll/open/7647180

Let me know if that helps...

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, August 31, 2009 9:02 AM
To: eLink Recipient
Subject: Querying the Status of Livelink Tasks

Querying the Status of Livelink Tasks

Posted by nsscadmin (Miller, Jonathan) on 2009/08/31 08:58

We have a Livereport created in LL 9.2 that compares 2 tasks and provide a report on status for each tasks.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

select DTree.*, (LastName || ', ' || FirstName) as performername, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'OnHold') as mystatus from DTree, KUAF where KUAF.ID=DTree.Assignedto and DTree.Status IN('0', '1', '2', '3') and DTree.OwnerID IN('12006959', '13593480') and %1 order by DTree.DateDue

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

After our upgrade to LL 9.7.1, the Livereport is no longer working. The tables that this Livereport is calling are still present in the in the 9.7.1 schema so I don't understand or know how to troubleshoot.

Has anyone ran into this problem?

ray_chance

Ok, now I'm getting some results, but it's the wrong information.The same task is listed (same objID) over and over and the Assigned to name is changing as well.This is what I have now for my SQL:select DTree.*, (LastName || ', ' || FirstName) as performername, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'OnHold') as mystatus from DTree, Assignees , KUAF where KUAF.ID=Assignees.Assignedto and DTree.Status IN('0', '1', '2', '3') and DTree.OwnerID IN('12006959','13593480') and %1 order by DTree.DateDue

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I think you will need to include a join on the DataID column of the Assignees table with the DataID column of DTree.

- Bhupinder

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, August 31, 2009 3:15 PM
To: eLink Recipient
Subject: Ok, now I'm getting some results, but it's the wrong information.

Ok, now I'm getting some results, but it's the wrong information.		Posted by nsscadmin (Miller, Jonathan) on 2009/08/31 15:12
In reply to: RE Querying the Status of Livelink Tasks		Posted by bsingh (Singh, Bhupinder) on 2009/08/31 09:18

Ok, now I'm getting some results, but it's the wrong information.

The same task is listed (same objID) over and over and the Assigned to name is changing as well.

This is what I have now for my SQL:

select DTree.*, (LastName || ', ' || FirstName) as performername, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'OnHold') as mystatus from DTree, Assignees , KUAF where KUAF.ID=Assignees.Assignedto and DTree.Status IN('0', '1', '2', '3') and DTree.OwnerID IN('12006959',
'13593480') and %1 order by DTree.DateDue

ray_chance

Hi Bhupinder,How would you do that? Our DBA is on leave, and I am just a poor sys admin stuck with these issue. :)Appreciate any help.

Appu_Nair

Dtree.Dataid=Assignees.Dataid so basically something likeselect DTree.*, (LastName || ', ' || FirstName) as performername, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'OnHold') as mystatus from DTree, Assignees , KUAF where KUAF.ID=Assignees.Assignedto and DTree.Status IN('0', '1', '2', '3') and DTree.OwnerID IN('12006959','13593480') and dtree.DataId=Assignees.dataid %1 order by DTree.DateDue

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Slight correction: put the word "and" before the %1

select DTree.*, (LastName || ', ' || FirstName) as performername, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'OnHold') as mystatus from DTree, Assignees , KUAF where KUAF.ID=Assignees.Assignedto and DTree.Status IN('0', '1', '2', '3') and DTree.OwnerID IN('12006959',
'13593480') and dtree.DataId=Assignees.dataid and %1 order by DTree.DateDue

- Bhupinder

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, September 01, 2009 12:40 PM
To: eLink Recipient
Subject: Did not Test this

Did not Test this		Posted by anair@alitek.com (Nair, Appu) on 2009/09/01 12:39
In reply to: RE Ok, now I'm getting some results, but it's the wrong information.		Posted by bsingh (Singh, Bhupinder) on 2009/08/31 15:24

Dtree.Dataid=Assignees.Dataid so basically something like

select DTree.*, (LastName || ', ' || FirstName) as performername, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'OnHold') as mystatus from DTree, Assignees , KUAF where KUAF.ID=Assignees.Assignedto and DTree.Status IN('0', '1', '2', '3') and DTree.OwnerID IN('12006959',
'13593480') and dtree.DataId=Assignees.dataid %1 order by DTree.DateDue

ray_chance

Bhupinder / Appu,It worked. Really appreciate your help on this.Thanks again!!!