Clarity

Can I "grab" tasks from multiple projects and display them in one place as a single task list?  I'd like to "grab" all tasks that require management review.

Thanks,

Mujeeb Chowdhry

Hi Mujeeb,

I think it is not possible to assemble different tasks from multiple projects and gather them at one place. My idea is that since Task is a subobject of Investment, hence it is not possible to take them out from its master Object Instances and display them by listing somewhere outside that Investment Object instance. Let me know if that helps to find your answer.

Thanks,

Abhisek Dhar

You might be able to create your own-user defined portlet using an NSQL Query.

Check out the Technical Reference Guide for schema help and if you need more advanced assistance, reach out to other community members or our CA Services Team.

"You might be able to create your own-user defined portlet using an NSQL Query."
like starting with the prtask table or you could try experimenting using the task object as the dataprovider (it is available even if it is a suboject)

NSQL (Oracle DB) to pull all key task within a 90 day window (-30 days +60 days around start date).

SELECT

@SELECT:DIM:USER_DEF:IMPLIED:DIMENSION:UNIQUE_ID:UNIQUE_ID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:NAME:NAME@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:CODE:CODE@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:PRNAME:PRNAME@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:PREXTERNALID:PREXTERNALID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:PRSTART:PRSTART@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:PRFINISH:PRFINISH@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:PARTITION_CODE:PARTITION_CODE@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:DIMENSION:PRPCTCOMPLETE:PRPCTCOMPLETE@

FROM (

                SELECT rownum as UNIQUE_ID

                                ,inv.NAME

                                ,inv.CODE

                                ,ts.PRNAME

                                ,ts.PREXTERNALID

                                ,ts.PRSTART

                                ,ts.PRFINISH

                                ,ot.PARTITION_CODE

                                ,ts.PRPCTCOMPLETE * 100 AS PRPCTCOMPLETE

                FROM PRTASK ts

                INNER JOIN INV_INVESTMENTS inv ON inv.ID = ts.PRPROJECTID

                INNER JOIN ODF_CA_TASK ot ON ot.ID = ts.PRID

                WHERE ts.PRISKEY = 1

                                AND ts.prstart >= (SYSDATE - 30)

                                AND ts.prstart <= (SYSDATE + 60)

                ORDER BY inv.CODE

                                ,ts.PRSTART

)

WHERE @FILTER@

V/r,

Gene

I have wanted to figure out how to use HTML portlets so using this; I set out to build a HTML portlet that showed a Gantt chart of the key tasks in each project within the 90 window.  Chris in this post was kind enough to point the way to invoking a process via JavaScript.

Can we Access process through HTML portlet using java script?

So what does it take:

jsGantt FREE javascript gantt - JSGantt HTML and CSS only

A soap call to my NSQL query.

Parse the response and add summary task for the project and then the project's task.

Upload the page to the Knowledge Store

Point my HTML portlet to my Knowlede Store document.

jsGantt has a nice timescale feature.

I have zipped the NSQL and HTML page and will upload it to the documents (once I figure out how to do that).

V/r,

Gene