Constellation 24.1 - Table Column Filter on Prompt List Property Sends Display Value rather than stored value

User Experience Knowledge Share
,
1

Hi All,

We are facing an issue with table filtering on a column backed by a Prompt List property. The property stores backend values such as 0 = Read Only and 1 = Read & Write.

When a user applies a filter on this column, Constellation sends the display text (for example, “Read Only”) as the filter criteria instead of the actual backend value (0). As a result, the filtering logic does not work correctly because the underlying data is stored as numeric values rather than the displayed labels.

We would like to understand if there is a way to configure Constellation table filters to pass the stored prompt list value instead of the display text during filtering.

@MarcCheong @Kamil_Janeczek @RameshSangili

Thanks

2

See Insight using property of type prompt list - #3 by RameshSangili

I would not be using a prompt list here - it’s one of the reasons I don’t like prompt or picklists over a data reference - in the end you want to see all data from that list, so a data reference provides that in insights (via an Association).

You could try creating an Association rule, based on the prompt list values, to then expose this. However, I have not tried this.