Dynamic filter Query for DB based application

[Rajesh_IAM]

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. 

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.

[SB]

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

[Rajesh_IAM]

@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).

[rushikeshvartak]

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