How to use LIKE in AQL?

Specifications AQL
#1

hello, I’m trying to use a LIKE in AQL, but it doesn’t work … how do I like to search for any place that has this certain date?

How can I do it?

Captura de Tela 2020-12-04 às 13.24.19
Captura de Tela 2020-12-04 às 13.24.192110×1372 339 KB

#2

Hi @luiz_Minelli
would something like this match your question?

image
image921×451 38.8 KB

#3

So, I do like you and it doesn’t work for me …

I wanted him to catch everyone without the timezone

Captura de Tela 2020-12-04 às 14.20.06
Captura de Tela 2020-12-04 às 14.20.062148×1146 262 KB

#4

Am I doing something wrong?

#6

LIKE is only available for String values, I suspect your path …/items[at0075]/value is a DV_DATE_TIME, not a String.

To get the String representation, you need to add a /value to tour path.

Remember operators apply to certain types. I guess the AQL editor is not doing type checking over the paths and operators, that is why you don’t know what the error is.