Is it possible to filter the DS text attribute by length?

Owned by Jana Volencová (Deactivated)
Last updated: Aug 02, 2022 by Jan Panoušek
1 min read

Question

I need to filter the entries of the Attribute "MotorBM" in the Datasource "DS_Vehicle" where the length is greater than 6 characters. The attribute type is "Text", so I can't just filter entries greater than 999999. Is there any query or hidden filter function or some kind of workaround I can use?

Answer

You can use the 'contains' filter with underscore _ as a placeholder for any character.

In your case it would be: contains _______ (7 underscores). It will return only values that have 7 characters or more.

Found an issue in documentation? Write to us.