Clarity

  • 1.  Query that inculdes name of the subprojects

    Posted Feb 08, 2016 12:40 PM

    Hi all,

    • I'm new here. i'd make a query that let me have the following informations:
      > direct Children from parent source (project manager)
      > Allocation rate
      > Names of subprojects

    Here is the SQL I'm using:

     

    select inv.parent_id parent,

    inv.child_id child,

    DEFAULT_ALLOC_PCT alloc

    from INV_HIERARCHIES

     

    The problem is, how can i associate the name of subprojects with INV_HIERARCHIES?

    Any helps?

    thanks

     



  • 2.  Re: Query that inculdes name of the subprojects



  • 3.  Re: Query that inculdes name of the subprojects

    Posted Feb 09, 2016 04:42 AM

    INV_INVESTMENTS.NAME contains the project name, INV_INVESTMENTS is keyed on ID, which matched the IDs that you have got from INV_HIERARCHIES.

     

    --

     

    If you are planning on doing more of this, you should try to understand the basics of the Clarity datamodel - the entity relationship diagrams in the technical reference section on the documentation would be a good place to start! https://docops.ca.com/ca-ppm/14-3/reference/technical-reference/entity-relationship-diagrams-erd