Lookups Do Not Work When Using Partitions

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Filters do not work when partitions are involved.

Steps To Reproduce

1. Create a lookup query. The following query can be used:

 

select
             @SELECT:tr.z_name:z_name@,
             @SELECT:tr.CREATED_DATE:CREATED_DATE@,
             @SELECT:tr.LAST_UPDATED_DATE:LAST_UPDATED_DATE@
from
             odf_ca_test_server tr
where
             (tr.z_enddate is null or tr.z_enddate>sysdate)
             and @FILTER@

 

2. Create a partition.
 

3. Go to Classic Administration > Data Administration > Studio > Team > object and create custom lookup attribute on the created partition
 
4. On the Project > Team , configure the lookup filter and list view.

5. Login as a user assigned to the partition and configure the project Team list and filter view.

6. Attempt to filter for a value that returns results.

Expected Results: The filter should work.

Actual Results: The filter does not work and blanks out while the filter displays all results.
Any other custom lookup field being used will reset the view.

Workaround: Use the personal Configure, but as soon as General > Restore Default is used, the issue comes back.

 

Environment

All

Resolution

This is reported as DE79931.
The issue is not able to be reproduced in 16.2.1