Studio Attributes grid for 'Database Table' and 'Database Columns' shows incorrect info for some fields
searchcancel
Studio Attributes grid for 'Database Table' and 'Database Columns' shows incorrect info for some fields
book
Article ID: 258748
calendar_today
Updated On: 07-31-2023
Products
Clarity PPM SaaS
Issue/Introduction
STEPS TO REPRODUCE:
Login to Clarity as an administrator user
Navigate to Administration, Studio: Objects, Task Object, Click on the Attributes tab
Look for attributes 'Actuals', 'ETC', 'WBS Sort', '% Expended', or 'Total Effort'
Take a note of the 'Database Table' and 'Database Column' names that are displayed on the UI for these fields (ie. PRTASK PRACTSUM)
Run a Query against PRTASK table for these attributes (SELECT * FROM PRTASK)
The column list from the SELECT query should include the PRTASK.PRACTSUM field (or other noted fields) based on the current information on the Attributes list page
Expected Results: The Attributes list page to show the correct Database Table and Database Column name. Actual Results: The Attributes list page shows incorrect Database Table and Database Column name.
Environment
Release : 16.1.0
Cause
This is reported as DE68304
Resolution
This is fixed in 16.1.2 release
Additional Information
Workaround: Use the results of the SELECT * FROM PRTASK query to see the Database Columns available for a direct SQL Query. Another alternative is to use REST for the Task API to get data for additional fields not stored in the primary task table. The API will provide data results for the related API-enabled fields on the object.