Discussions

In 20.3, I've added a custom field in a query using an sql expression. Is there a way to now reference that field in the filter of the same query?

Use case, we're needing to strip out non-numeric characters from phone numbers to compare to a phone number coming in as a parameter of a url. I can get the stripped down version of the phone number to display when running the query but the custom field is not then available in the filter drop down to use for the url param comparison.

Another option is to add a custom property to a business object for the stripped down phone number but can't figure out a way to apply the formatting sql to the field using expression builder.

Any help is appreciated.