Hi,
(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 @SELECT:DIM:USER_DEF:IMPLIED:DIM1:my_sql.my_unique_id:uq_id@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:DIM1:my_sql.Projet:Projet@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:DIM1:my_sql.Tache:Tache@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:DIM1:my_sql.prDuration:Duree@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:DIM1:my_sql.prExternalId:Matricule@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:DIM1:my_sql.prName:ressource@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:DIM1:my_sql.RAF:RAF@
FROM
(
SELECT P.prID||PR.PRID as my_unique_id,
P.PrName as Projet,
T.prName Tache,
T.prDuration,
r.prExternalId ,
R.prName,
SUM(PR.PRESTSUM)/3600 RAF
FROM
NIKUPRD.PRPROJECT P,
Nikuprd.prTask T,
Nikuprd.prAssignment PR,
Nikuprd.PrResource R
where P.PrID = prProjectID
AND T.prID=PR.prTaskID(+)
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
GROUP BY
P.prID||PR.PRID,
P.Prname,
T.PrWbsSequence,
T.prName,
T.prDuration,
P.PrExternalID,
r.prExternalId,
R.prName
ORDER BY t.PrWbsSequence
) my_sql
WHERE @FILTER@
[ 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 ?
Thanks