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.
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.
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 rownum as UNIQUE_ID
,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
Can we Access process through HTML portlet using java script?
So what does it take:
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).
Retrieving data ...