Tasks Workspace views do not display data
search cancel

Tasks Workspace views do not display data

book

Article ID: 429369

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Tasks Workspace views do not display data correctly, if an existing view refers to a Task object virtual attribute and the same virtual attribute is part of a project business rule.

STEPS TO REPRODUCE:

  1. Classic > Administration > Studio > Project object > Attributes tab
  2. Create a lookup attribute based on a static lookup: MyCustomLkp. Above waterline lookup can be used for the testing purposes
  3. Classic > Administration > Studio > Task object > Attributes tab 
  4. Create a virtual attribute of the above project custom field: MyCustomVirtualTaskLkp
  5. In Clarity MUX > Create a project and create a few tasks
  6. On the project grid, add the project custom column and fill it in, let say with Above Waterline value
  7. In Clarity MUX > Go to the Tasks workspace
  8. Create or access a view with no filtering. Notice data is displayed
  9. Create a new view and add the custom project field to the filter and choose both Below Waterline and Above Waterline values to the filter
  10. Data gets displayed in both views: the one with filtered criteria and the one with no filters
  11. MUX > Administration > Blueprints > Create a project blueprint
  12. On the Rules tab > Create a rule:
    • Target object: Task
    • Rule Type: View Page   
    • Conditions: MyCustomVirtualTaskLkp=Above Waterline and Access Groups != ABC   
    • Actions: Disable Editing Attributes > Disable All Except Selected > Choose some fields
  13. Activate the rule and publish the blueprint
  14. Associate the project in Step 5 to the blueprint
  15. Go back to the Tasks Workspace and navigate through the views.


Expected Results: All views display data accordingly.
Actual Results: Some views do not display the data as expected (for example the one with no filtering criteria) 

Environment

Clarity 16.2.3 to 16.4.1

Cause

This i caused by DE182581

Resolution

This is fixed in Clarity 16.4.2

Additional Information

app-ca.log file registers the following:

ERROR 2026-02-13 03:18:46,459 [http-nio-8080-exec-1159] odata.EntitiesResponseImpl (clarity:myuser:mysession) Exception reading objects: oba_task
com.niku.union.persistence.PersistenceApplicationException
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2529)
 
ERROR 2026-02-13 03:18:59,022 [http-nio-8080-exec-1155] persistence.PersistenceController (clarity:clarity:myuser:mysession) Error happened with error code:42P01
ERROR 2026-02-13 03:18:59,022 [http-nio-8080-exec-1155] union.persistence (clarity:myuser:mysession):PPM_REST_API)  Exception on odf-pmd.oba_task.select-list-rest-api-conditional.map statement null
org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "project____odf_ca_project"
  Position: 3381