Clarity PPM

Expand all | Collapse all

How to get all the instances associated to a custom object under a specific OBS using data warehouse tables.

  • 1.  How to get all the instances associated to a custom object under a specific OBS using data warehouse tables.

    Posted 02-15-2018 02:18 AM

    1. I have created a custom object "Associated Releases" and have enabled it in the data warehouse.

    2. Created a new OBS and associated it to the newly created custom object "Associated Releases".

    3. I have created instances for the custom object "Associated Releases" and also selected the associated OBS.

    4. Now I need a query that would fetch all the instances if the custom object associated with a specific OBS unit.

     

    Thanks in advance. 



  • 2.  Re: How to get all the instances associated to a custom object under a specific OBS using data warehouse tables.

    Posted 02-15-2018 04:30 AM

    Not a data warehouse table, but the current relationship is held in the PRJ_OBS_ASSOCIATIONS table. Search for that on the community and you will find several examples.