(Clarity v 12)
I created a portlet based on an NSQL query, showing projects, their key tasks, the users allocated on the task and the estimate.
Here is the NSQL :
SELECT P.prID||PR.PRID as my_unique_id,
P.PrName as Projet,
where P.PrID = prProjectID
AND pr.PrResourceID = R.prID
AND (UPPER(P.prExternalID) LIKE '%_GLOBAL%')
AND (T.PrName NOT LIKE 'Collecte%')
AND t.prIsKey <> 0
ANd t.prIsTask <> 0
ORDER BY t.PrWbsSequence
[ Yes I know using PrProject is not the best way to do it, I'm just an old NIKU user since 2002 :-) ]
When using this portlet, I can see all the data : project, task, resources, estimate, .... But I want my users to be able to modify duration and estimate, and the action menu does not offer the possibility to go to "Edit Mode"
Do you have some ideas or good advice about that ?
You portlet can't be NSQL portlet it has to be based on system data providers, most of which are objects. Then you have edit option.
This is what I tried at first, but I could not make a portlet that showed
Tasks and resources data (I had to choose between one of these two sources
Is there a way to create a non-NSQL portlet that can use data from theses
Direction Plan Projet / PMO Groupe
Espace Gestion de Projet
De : urmas <email@example.com>
A : Stephane ROBIOLLE <firstname.lastname@example.org>,
Date : 25/11/2014 17:53
Objet : Re: - How to create a portlet where the results can be
updated by our users ?
How to create a portlet where the results can be updated by our users ?
reply from urmas in CA PPM - View the full discussion
You portlet can't be NSQL portlet it has to be based on system data
providers, most of which are objects. Then you have edit option.
Reply to this message by replying to this email, or go to the message on
Start a new discussion in CA PPM by email or at CA Communities
Following How to create a portlet where the results can be updated by our
users ? in these streams: Inbox
"Is there a way to create a non-NSQL portlet that can use data from theses 2 objects?" - NO
However, you can put in an idea (if one doesn't exist, already)
IMHO no, but you can use a system data provider that combines those two objects: assignment.
Do not that all the fields are not editable eg invest, resource and task while ETC is
Were you able to achieve this ?
If you can share your experience(s), would be helpful
I won't have time during the next weeks to test the assignment object, but
I will need to update my portlet in the next months. I will then try and
come back to share it.
Thanks to all,
De : navzjoshi00 <email@example.com>
Date : 01/12/2014 09:50
reply from navzjoshi00 in CA PPM - View the full discussion