Skip to Main Content
Feature Request FR-2293
Product Area Page Components
Status DELIVERED

1 Voters

Facet based on colon separated column

shunt Public
· Jan 20 2022

Idea Summary
It would be amazingly useful to be able to defined the datatype for a facet column as being a "colon delimited" 

Use Case
I am storing the values of a multi-select LOV as a colon delimitated string in the database.  Each value in that string is then counted as a separate value and used to filter to any record that contains that value in the string.

Preferred Solution (Optional)
Add a new source type to the facet of “Colon Separated”.  When selected, it will convert the string to columns and count each value seperately.

This has been delivered in Oracle APEX 21.2!

Comments

Comments