Hi - I'm rather new to creating portlets so bear with me. I created a mirror image of the My Assignments Portlet within PPM, but added a custom field in from another table. The query worked and I can see all of the fields within the portlet creation area.
However, after creating the portlet and adding a tab to my homepage to view it I am not seeing the actual portlet (the data doesn't display), but the filter on the portlet is showing the fields.
I am currently assigned to a project as well and do pull into the My Assignments Portlet for it, which makes this more baffling.
Am I missing something here, feel like this should be straight forward.
Appreciate any assistance.
Is there any error on the app-ca.log?
Is there any condition that is not satisfied within the query ? Try running the sql in the db and check if you get results there
Could you share the query and a screenshot of the portlet not displaying data?
Thanks for responding urmas / navz! So the My Assignments query that pulls in values into the portlet does not work in Oracle either (after switching to preview tab and using the SQL there). I'll go ahead and attach the code / screenshots. The first query is the working portlet / query, while second is not working (pictures are attached below each query). On the second query I bolded the values that I added.
My Assignments - Working Portlet:
I took a look at the join you added. I don't think that will work.
JOIN odf_ca_c_client M ON M.ID = tsk.prid
The id in the odf_ca_c_client is the internal id for each object instance of that type that is generated as it is created. The prid in the prtask table is the internal id for tasks from the odf_ca_tasks table. It doesn't seem logical to me that these would match. Is there a different field on one of these two tables that is a key to the other one?
Senior Support Engineer
CA Technologies, Inc.
Ahh you are right Jeanne. The issue right now is that field comes from a custom table and those tables don't really sync with anything that I can see (ID is the only "Key" number field that I see) .
I think I may have found the answer - Thanks everyone