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

[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

[Deactivated User]

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.

[Stephane_FR]

Thanks Urmas,

 

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

 

objects).

 

Is there a way to create a non-NSQL portlet that can use data from theses

2 objects?

 

 

Cordialement,

 

Stéphane ROBIOLLE

Direction Plan Projet / PMO Groupe

Espace Gestion de Projet

 

 

 

De :    urmas <[e-mail]>

A :     Stephane ROBIOLLE <[e-mail]>,

Date :  25/11/2014 17:53

Objet : Re:  - How to create a portlet where the results can be

updated by our users ?

 

 

 

 

CA Communities

 

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

CA Communities

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

[navzjoshi00]

"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)

 

https://communities.ca.com/community/ca-clarity/content?filterID=contentstatus[published]~objecttype~objecttype[idea]

 

NJ

[Deactivated User]

"

Is there a way to create a non-NSQL portlet that can use data from theses

2 objects?"

 

 

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

[navzjoshi00]

Were you able to achieve this ?

 

If you can share your experience(s), would be helpful

 

NJ

[Stephane_FR]

Hi,

 

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,

 

 

Cordialement,

Stéphane ROBIOLLE

Direction Plan Projet / PMO Groupe

 

 

 

De :    navzjoshi00 <[e-mail]>

A :     Stephane ROBIOLLE <[e-mail]>,

Date :  01/12/2014 09:50

Objet : Re:  - How to create a portlet where the results can be

updated by our users ?

 

 

 

 

CA Communities

 

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

reply from navzjoshi00 in CA PPM - View the full discussion

 

Were you able to achieve this ?

 

If you can share your experience(s), would be helpful

 

NJ

 

 

Reply to this message by replying to this email, or go to the message on

CA Communities

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