Skip to main content
Top Header
Solved

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

  • December 24, 2024
  • 1 reply
  • 18 views
sivasakthi.dhand
Level 3
Forum|alt.badge.img+4

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}'

Best answer by sivasakthi.dhand

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.

View original

sivasakthi.dhand
Level 3
Forum|alt.badge.img+4

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.

sivasakthi.dhand
1 person likes this
  • sivasakthi.dhand
    sivasakthi.dhand

Reply


Community Code of Conduct