Clarity

  • 1.  Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 12:03 AM

    CA-PPM :14.3

     

    I have a custom attribute on the 'project object' but it behaves differently on program list page.

     

    Here is the scenario:

     

    Custom Attribute Name:  Portfolio Name

    This field is updated by custom process.  I can see the value updated in Project List page but the same attribute is not updated on the program list page.

     

     

    Project Page

     

     

    Program list page

     

     

    Any help/pointer is greatly appreciated

     

    Thanks

    -Venkitta



  • 2.  Re: Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 12:26 AM

    Is it on a secured sub-page?

     

    NJ



  • 3.  Re: Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 12:36 AM

    No.  it is not on the secured sub-page



  • 4.  Re: Project Attribute behaves differently in Program list page

    Broadcom Employee
    Posted Feb 21, 2018 01:03 AM

    Hi

     

    I believe that Program list page should show the same value.

     

    Can you clear the browser cache ?

    Or Can you try to make restore default Program list page ?

     

    Regards,

    Tomomichi



  • 5.  Re: Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 02:24 AM

    I tried but still seeing the same issue.



  • 6.  Re: Project Attribute behaves differently in Program list page

    Broadcom Employee
    Posted Feb 21, 2018 02:17 AM

    Hi,

     

    Your custom process updates "Portfolio Name" column for Project correctly, but it may not update "Portfolio Name" column for Program.

     

    If possible, please run below query to verify project tables directly.  It will show all program with "Portfolio Name"

    (Please change portfolioname to correct your column name before you run it)

     

    select ii.name program_name, ii.code program_code, op.portfolioname portfolio_name
    from inv_investments ii, inv_projects ip,odf_ca_project op
    where ii.id=ip.prid
    and ip.is_program=1
    and op.id=ii.id

    and ii.odf_object_code='project'

     

    I think that your custom process will not update "Portfolio Name" column for Program.

     

     

    Regards,

    Shoichi

     



  • 7.  Re: Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 02:25 AM

    Are you saying that the single db attribute from the custom table is used differently in project and program?



  • 8.  Re: Project Attribute behaves differently in Program list page

    Broadcom Employee
    Posted Feb 21, 2018 03:46 AM

    Hi,

     

    I mentioned if it is program instance,  then is_program column of inv_projects table is true.

    And you can view it via program list. (you cannot view it via project list)

     

    If it is project instance,  then is_program column of inv_projects table is false.

    And you can view it via project list. (you cannot view it via program list)

     

    I assume that your problem is the following. Is it correct?

    You updated custom attribute on odf_ca_project table for both project and program instances. 

    You could view updated custom value of project instance on project list.

    You could NOT view updated custom value of program instance on program list.

     

    Regards,

    Shoichi 



  • 9.  Re: Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 02:26 AM

    Have you checked on the database ie select * from odf_ca_project where id = 9999 -- where 9999 is the 5,000,000 for the program.  Assuming you have created the attribute on odf_ca_project.

     

    A 'program' still stores all its data in exactly the same database tables as 'projects'.  There are just different views for Projects and Programs but it looks like you have pushed the attribute over to the Project List View and Program List View based on your screen shots.

     

    If the data is not in the database, then you will need to go back to your process to determine why it didn't get populated.



  • 10.  Re: Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 02:37 AM

    Hi Roland,

     

    Yes. the custom attribute is created on the table odf_ca_project.

     

    Even, I manually updated the custom attribute (project page) but it shows only on the project page and NOT on the program page.  

     

    Thanks



  • 11.  Re: Project Attribute behaves differently in Program list page

    Posted Feb 21, 2018 04:18 AM

    What if you put the attribute on a PROGRAM edit page (unsecured) - do you see it OK then?

     

    (like NJ's original reply, it seems to like a secured subpage issue, i.e. to do with the user not having rights to see a page that the attribute is upon if you are securing subpages with access rights)

     

    Or to put it another way - for your "Program List" view options, what are the settings in the "Attribute Value Protection" option. Investigate that?