Getting error when using Attribute name as a LENGTH in OQL Query

0
Hello Everyone, I am trying to get data from data database with ‘LENGTH is not null’  condition using OQL Query.In this case,am getting the error like ‘Error on line 24 character 44: no viable alternative at input 'LENGTH'’.Can you guys help me to fix this issue.Thank you.
asked
2 answers
1

Seems like you are running into a reserved word issue.  See this documentation for instructions on how to use reserved words in OQL queries:  https://docs.mendix.com/refguide/oql/#reserved-oql-words

answered
0

Post your OQL, or at least the relevant part.

You should be able to do the following:

alias/stringattribute != null (means: not empty)

alias/stringattribute != '' (means: not empty string)

LENGTH(alias/stringattribute) != 0

answered