Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button.  The answer will now appear with a checkmark.  Please be sure to always mark answers that resolve your issue as verified.  Your fellow Community members will appreciate it!  Learn more.

  • State Verified Answer
  • Replies replies
    2
  • Subscribers subscribers
    12
  • Views views
    159
  • Users 0 members are here
Related
Options

Query for PPM Project Settings

Bryan Legaspi

Hi everyone,

May I ask if anyone has a sql select query for a list of PPM projects that has a specific settings

For example, a list of Projects which has a Project Settings > Project Scheduling Integration > Integration Mode > Control is shared is selected (please see photo below).

Appreciate your response on this.

Parents

  • Verified Answer

    +1  

    Hi Bryan,

    SELECT p.project_id, p.project_name, sa.*
 
  FROM itg_settings_attributes sa, itg_settings_cont_attrs sca, 
       itg_settings_containers sc, pm_projects p,
       pm_project_types pt, pm_work_plans wp
WHERE sc.settings_container_id  = sca.settings_container_id
   AND sca.settings_attribute_id = sa.settings_attribute_id
   AND p.project_type_id         = pt.project_type_id
   AND pt.pt_settings_key        = sc.settings_container_id
   AND wp.project_id             = p.project_id 
and name like '%msp.integrationMode%'
--and p.project_id  37462

Reply

  • Verified Answer

    +1  

    Hi Bryan,

    SELECT p.project_id, p.project_name, sa.*
 
  FROM itg_settings_attributes sa, itg_settings_cont_attrs sca, 
       itg_settings_containers sc, pm_projects p,
       pm_project_types pt, pm_work_plans wp
WHERE sc.settings_container_id  = sca.settings_container_id
   AND sca.settings_attribute_id = sa.settings_attribute_id
   AND p.project_type_id         = pt.project_type_id
   AND pt.pt_settings_key        = sc.settings_container_id
   AND wp.project_id             = p.project_id 
and name like '%msp.integrationMode%'
--and p.project_id  37462

Children

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.