Clarity PPM

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  How to create a portlet where the results can be updated by our users ?

    Posted 11-25-2014 10:37 AM

    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



  • 2.  Re: How to create a portlet where the results can be updated by our users ?
    Best Answer

    Posted 11-25-2014 11:53 AM

    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.



  • 3.  Re: How to create a portlet where the results can be updated by our users ?

    Posted 11-26-2014 03:15 AM

    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 <communityadmin@communities-mail.ca.com>

    A :     Stephane ROBIOLLE <srobiolle@macif.fr>,

    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



  • 4.  Re: How to create a portlet where the results can be updated by our users ?

    Posted 11-26-2014 03:37 AM

    "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



  • 5.  Re: How to create a portlet where the results can be updated by our users ?

    Posted 11-26-2014 08:17 AM

    "

    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



  • 6.  Re: How to create a portlet where the results can be updated by our users ?

    Posted 12-01-2014 03:50 AM

    Were you able to achieve this ?

     

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

     

    NJ



  • 7.  Re: How to create a portlet where the results can be updated by our users ?

    Posted 12-05-2014 03:04 AM

    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 <communityadmin@communities-mail.ca.com>

    A :     Stephane ROBIOLLE <srobiolle@macif.fr>,

    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