Report on multiple tasks lists

Sebastien_Beauval_(sglcadmin32_-_(deleted))

I have several task list in several livelink project. How to do a report to list all the task of a user / somes users which come from the different tasks lists ?

Find more posts tagged with

Comments

Marie_Lindsay_(MLindsay_(Delete)_15608)

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

This LiveReport should list all tasks and the person to whom each task is assigned:

select dtree.*, kuaf.name from dtree where %1 and kuaf.id = dtree.assignedto

%1 should be linked to the "Filter Tasks" system parameter.
For this example, you would want to use the LiveReport format, and you would want to list kuaf.name as a "Display Column" (enter "kuaf.name" under "Field", with a column header under "Column Title").
You could add to the WHERE clause to restrict according to the assignee -- for example, AND ASSIGNEDTO = %2, where %2 is mapped to a user input that is of type User.

Hope that gets you started.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, September 23, 2003 4:05 AM
To: eLink Recipient
Subject: Report on multiple tasks lists

Report on multiple tasks lists Posted by SglcAdmin32 (Beauval, Sebastien) on 09/23/2003 05:00 AM

I have several task list in several livelink project. How to do a report to list all the task of a user / somes users which come from the different tasks lists ?

eLink User