When creating a Data Provider using security it is not substituting user id of logged in user.

Products

• Clarity PPM SaaS

Issue/Introduction

When creating a Data Provider using security it is not substituting user id of logged in or impersonated user.

Steps to Reproduce: 

1. Login with the user1, Navigate to Reporting.
2. Create Data Provider by selecting Investment object.
3. Enable Security for Investment object.
4. Click on Preview tab and select at least one attribute.
5. Filter on Name attribute
6. Click on View Query and check the security clause - should show the id of the user who logged in
7. Logout and login with the user2
8. Access the same data provider or create a new data provider same as above
9. In Preview tab, Click on Investment Name filter to load.
10. Click on ViewQuery and check the security clause.
11. It is not showing the id of the user who logged in or the impersonated a user.

Expected Results: It is expected to substitute with the logged in or impersonated user key.

Actual Results: It is picking some other user's key.

Cause

DE208076

Resolution

Under review by Engineering.