LIKE operator on IDM, is it like SQL?

Hi to all,

is it the LIKE operator in IDM like the SQL? I'm trying to get a document with the LIKE operator but it seems not working as expected. It has the same behaviour as the EQUAL operator.

I tried just using the word as it is, e.g. complete string is "2022 #TEST". Response: 0 matching documents.

The XQuery is: /DocumentTypeName[@CustomField LIKE "TEST"]

I tried to use "%" but same result.

Thank you,

Eleazar

Find more posts tagged with

Infor Document Management (IDM)

Accepted answers

Kevin Heiman

You should have success using % as the wildcard.

In this example it is both before and after to find the string anywhere in the Attribute.

All comments

Jeremy Townsend

I've never tried using the Like function, but just did and I too cannot get it to work as expected. If no one else answers with how, it seems like a bug to me! I tried using asterisks as well.

Kevin Heiman

You should have success using % as the wildcard.

In this example it is both before and after to find the string anywhere in the Attribute.

Copyright © 2025 Infor. All rights reserved.