VALART, LLC
·Arturo Sanz

Issue applying filters to the get filter path field

This has been driving me crazy for a while, because it has been working well until recently.

The order object has the attribute number of type uuid. I use the get filter to obtain the uuid value, and apply a couple more filters to extract the last 6 characters and make them uppercase. In case the number attribute is not present, then I substitute the result for the ? character. Simple, not a big deal. This is the formula …

The formula has been working well for some time, returning the last 6 uppercased characters of the order number (ex: F176E2). However, suddenly it didn't work anymore, always returning the default character ?. Why? I don't know. It doesn't matter what filters I apply to the get filter path field, they all fail forcing the get filter to return the default value. Also, it doesn't matter whether the number attribute is of type uuid or text. Those filters fail anyhow.

Thank God that if I apply the substr filter to the ? character trying to extract the 6 last characters, the result is still the ? character. So there is an easy workaround …

Applying filters to the get filter path field when the value is no text (integer, …) still works fine. No issues with those types of values. But with text and uuid values, filters fail.

Now, I must check all functions where I apply a text filter inside a get filter making sure they work. Even a simple to_upper filter can fail if applied to the get filter path field. 🤯

1 reply