TheHive node broken filter

[dream91]

Describe the bug
I had TheHive workflow where I got Case by Title filter. After TheHive update I can't got the case. I know that TheHive made some changes in search backend.

Previously worked: "Critical Vulnerability Detected". It doesn't return anything right now.

Now works only with one word for example: "critical" (but it is werid - for "Critical" doesn't work)

To Reproduce
Steps to reproduce the behavior:

1. Use the newest TheHive version
2. Add TheHive node
3. Get All Cases and filter by Title
4. Try get some case with multiple words

Expected behavior
When I filter by Title "Critical Vulnerability Detected" then I should case with that title.

Environment (please complete the following information):

• n8n Version 0.159.1

Extra
Node configuration

[Joffcom]

Hey @dream91,

What version of TheHive were you previously using and what version are you running now?

[dream91]

Hello @Joffcom,

Previously 4.1.0
Now 4.1.14

[Joffcom]

Cheers @dream91,

I will get TheHive set up in my test environment here this week and see if I can reproduce the same issue 👍

[Joffcom]

Hey @dream91,

Sorry for the delay, I have managed to reproduce the issue I am on 4.1.17-1. I will work on getting a fix in place for this one.

[dream91]

@Joffcom
Great to hear that it is not only my problem :)

Meanwhile I made workaround: I changed wildcard query to Text* instead of *Text* and it works good for me.

[dream91]

I think it is TheHive bug in new versions. Someone also noticed that. TheHive-Project/TheHive#2299 (comment)

[Joffcom]

Well that is interesting, Nice spot @dream91. I will keep an eye on that one.

[Joffcom]

Hey @dream91,

It looks like the issue on the other side is still open, As this isn't directly our issue I am going to mark this one as closed on our side although if you still believe it is an issue we can resolve I can open it again.

Let me know what you think.