Studio Attributes grid for 'Database Table' and 'Database Columns' shows incorrect info for some fields
search cancel

Studio Attributes grid for 'Database Table' and 'Database Columns' shows incorrect info for some fields

book

Article ID: 258748

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE: 

  1. Login to Clarity as an administrator user 
  2. Navigate to Administration, Studio: Objects, Task Object, Click on the Attributes tab
  3. Look for attributes 'Actuals', 'ETC', 'WBS Sort', '% Expended', or 'Total Effort' 
  4. Take a note of the 'Database Table' and 'Database Column' names that are displayed on the UI for these fields (ie. PRTASK PRACTSUM) 
  5. 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.