We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Dynamic filter Query for DB based application

Rajesh_IAM
New Contributor III
New Contributor III

We are onboarding new DB based application into Saviynt. It has total 13 dynamic attributes. First 12 attributes contains values (end user select values from these attributes) and last dynamic attribute should show concatenation of all these 12 dynamic attribute values as entitlement value in this filter.

Could you please review and help me write a query concatenate all these 12 selected attributes. 

 

Rajesh_IAM_0-1699874059220.png

Note: In some cases end user may select only few filters out of 12, in this case we need to skip unselected filters and we should show only concatenation of selected filters values.

3 REPLIES 3

SB
Saviynt Employee
Saviynt Employee

Can you confirm on the use case to concatenate all values in the 13th field.


Regards,
Sahil

Rajesh_IAM
New Contributor III
New Contributor III

@SB  We want to display role name in this 13th filed with concatenation of all the selected dynamic fileds. (in these 12, 5 filters are mandatory and rest of the filters are optional).

use SQL case when then condition 

select case when ${Application} is not null and ${Role} is not null then concat('${Application}','${Role}')

end as id from dual


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.