AnsweredAssumed Answered

How to create a portlet where the results can be updated by our users ?

Question asked by Stephane_FR on Nov 25, 2014
Latest reply on Dec 5, 2014 by Stephane_FR

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

Outcomes