Filter using parameter in view not working in object centric data model table.

Question

I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.

This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'

This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'

sivasakthi.dhand · Accepted Answer

I found the issue. There is a bug in Celonis. When the value is passed to View overlays thru a variable, two spaces(trailing) getting added to the value. So the filter is not applied as expected.

It works fine after removing the trailing spaces using ‘rtrim’ string function ie rtrim('${var_dn_id}').

Hope Celonis will fix this issue soon.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN