Task Report - Reporting Milestone and Assigned To

Does Livelink have the ability to pull the names from the "Assigned To" and "Milestone" of a Task in a Category? Currently when I try to report on the Assigned To field I can only pull back 0(not assigned) or 1(Assigned). When I pull the Milestone information, I need to correlate to the task it is assigned to.Thanks in advance for all help!

Find more posts tagged with

Comments

Bo Warburton

Hey Jessica, this isn't an answer to your question, I know, but I am curious to know if you are actively using Tasks. It seems like a much-underused feature of Livelink. I've been working on an XML skin (export stylesheet) for tasks that we use to track issues when specific projects get to the test-and-fix stage. Maybe that would meet your requirements? Also, not sure what you meant by task in a category?

Jessica_Hixon

Lately we have been using tasks as the tool of chose because of the quick turnaround to create and modify. I may have misstated what I meant when I said Task in a category. We are using categories to apply attributes to the task lists. This information is reported on using segmentblobs.With yourXML skin are you able to pull the assignedto and milestones in a report?

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 can get the required information if you query the Assignees table in the database:

Columns:

AssignedTo -- The user the node is assigned to

DataID -- The assigned node

- 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, September 20, 2010 5:27 PM
To: eLink Recipient
Subject: Task Report - Reporting Milestone and Assigned To

Task Report - Reporting Milestone and Assigned To

Posted by jessica.r.hixon@lmco.com (Hixon, Jessica) on 2010/09/20 17:26

Bo Warburton

Jessica, you have got me thinking about the limits of my ancient XML skin. To my mind, standard out-of-the-box Livelink Tasks are most useful when used as action items from a recurring meeting. In other words, you have:- More people involved than a thing to do- Fewer interdependencies than tasks in a WBS- Less complexity than a workflow step assignment- Fewer reporting requirements than an issue listBut to make such a use case really useful, you need a transformation, a LiveReport, or a WebReport that people can use to cut and paste into a document or spreadsheet or view online to see the big picture at a glance. I will revisit this and see what I can do. Maybe my team will take up the challenge...