Parameters not working in the Modern UX

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We have a lookup based attribute whose NSQL is as below.

select
@select:id:[email protected],
@select:user_name:[email protected],
@select:locale:[email protected]
from cmn_sec_users
where @[email protected]
and id = @where:param:[email protected]
and locale = @where:param:[email protected]
and user_name = @where:param:[email protected]

We have another attribute which relies on the first attribute. Both these attributes do not show any value in the Modern UX.

Environment

Version: 15.9.2

Resolution

The attributes mentioned above were recreated since the issue was in a non-production environment.