Table for Status description (Livelink 9.7.0)

Hello, can anybody tell me please, where I can find the table with the descriptions for the status of a task? In dtree there is only the number of the status... Thanks in advance. Best regards, Rubi

Find more posts tagged with

Comments

Appu_Nair

i pulled this from livelink api documentation so hopefully this is rightStatus integer the status of the task, where 1 = In Process 2 = Issue 3 = On Hold -1 = Completed -2 = CancelledPriority integer the priority of the task, where 100 = High 50 = Medium 0 = LowYou probably could find this in the schema document(provided you have executed an NDA,it is free to customers)

Rouven_Bilgeri

Thank you very much. This is what I found in the documentation too. But I would need to read those "strings" from a table for creating a live report. I want the status "string" instead of the number for the output for users.

Martin_Gäckler

Hi,in Oracle you can use decode function to display stringsselect decode( status, 1, 'In Process',2, 'Issue',3, 'On Hold',-1, 'Completed'.-2, 'Cancelled','unkown' ) from dtreeHope this helps

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

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

Hi Rouven,

You do not need this in a table. You can convert data "inline" in the SQL query.

If you are using Oracle you can use the DECODE function, as Martin has just mentioned.

If you are using SQL server, then use a case statement.

In principle, this has the form

Select Rank, case Rank
When 1 then 'HIGH'
When 2 then 'MED'
When 3 then 'Low'

end
from TabName;

In your case it might be select work_workid, case work_status when 1 then 'In Process' when 2 then 'Issue' when 3 then 'On Hold' when -1 then 'Completed' when -1 then 'Cancelled' else 'Unknown'

end, work_project

from wwork;

Regards

Lindsay

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 07 July 2009 06:48
To: eLink Recipient
Subject: Table for Status description (Livelink 9.7.0)

Table for Status description (Livelink 9.7.0)		Posted by rouven.bilgeri@oerlikon.com (Bilgeri, Rouven) on 2009/07/07 01:46
In reply to: i pulled this from livelink api documentation so hopefully this is right		Posted by anair@alitek.com (Nair, Appu) on 2009/07/06 12:32