Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future Consideration
Workspace Jedox Platform
Categories In-Memory DB
Created by Guest
Created on Apr 22, 2025

Flexible String Filtering in PALO.DFILTER (Multi-Select or Regex)

Currently, in the PALO.DFILTER function, filtering based on a string value is limited to only one specific value at a time (e.g., = "Comment a"). This limitation restricts the ability to filter multiple values or patterns dynamically.

It would be useful to enhance PALO.DFILTER by allowing:

  • Multiple string values to be selected at once (e.g., = "Comment a" | "Comment b")

  • Regular expressions (Regex) for more flexible filtering (e.g., = "Comment .*" for all comments)

This would eliminate the need for multiple filtering statements.

2 MERGED

String values that match some patterns can be filtered using PALO.DFILTER

Merged
Currently, PALO.DFILTER can work with string values only when using "=" operator (Also, when using ">" operator,some string values are filtered lexicographically,though). But, it does not support pattern matching. In addition,">" operator do...
almost 5 years ago in Jedox Platform / Jedox Web Navigation 0 Future Consideration