Does anyone know if you can somehow do a case INSensitive attribute search in IDM or IDM Xquery?

Brian Barlow

We are trying to search by an attribute that is text.   From the REST API with POST /items/search  but trying to test and prototype using the attribute search and/or XQuery search within IDM.   Being a text field entered by users, the capitalization will always be interesting.   

Is there a way to do an XQuery function like lowercase(), or a setting on the search query for case insensitive?

Im trying things like this

/File[lower-case(@ATN) LIKE "mud"]  but get Invalid XQuery. All attribute names must start with a '@';. Name: lower-case(@ATN)

if I take out the lower-case, it returns 0 documents even though there are plenty with "Mud"

thanks in advance!

Brian

Legacy Contributor

All queries are case sensitive by default with the exception of the LIKE operator. You can set a Document Type to use a case insensitive LIKE operator when running an XQuery.