Filter based on length of string value?

Question

Hello! I'm trying to figure out if it's possible to filter a given field based on the character length of its value. This is for a clean-up project. In my case, I'm trying to find records where the "Matter Name" field is below a certain number of characters.FYI - I do not have access to the backend configuration stuff for the e-cube, so any solution that involves messing with the tables or creating new columns will not be of help to me. I can only do what's available in the front-end UI. Also wo...

Jake Raz · Accepted Answer

Okay, nevermind, figured it out on my own after more experimentation 🙂For anyone else trying to do this: use a "Doesn't Contain" filter, and then chain the number of underscores for the number of characters you're looking for. This will show you with everything that has LESS than the number of underscores you specify. For instance, this is using six underscores in a row, meaning it returns any Matter Name that has 5 or less characters.If you want to reverse it, change the operator to "Contains"...