[xwiki-users] Length of string in HQL query
Hello all, Is there a way to test the length of a string property using HQL? I want to use length as a criteria in my WHERE clause, but I can't seem to find an example anywhere of the syntax or if it's even possible. Thanks in advance, Jason
Hello Jason, Here an example : select doc.fullName from XWikiDocument doc WHERE length(doc.fullName) > 15 You can find others possible expression here : https://docs.jboss.org/hibernate/orm/3.3/reference/fr/html/queryhql.html#que... Sidali 2015-02-12 23:26 GMT+01:00 Jason Clemons <jason.clemons@live.com>:
Hello all,
Is there a way to test the length of a string property using HQL? I want to use length as a criteria in my WHERE clause, but I can't seem to find an example anywhere of the syntax or if it's even possible.
Thanks in advance,
Jason _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
participants (2)
-
Djebloun Sidali -
Jason Clemons