Google Drive Search Module Negative doesn't work

[Peter_Chen]

Hey Everyone,

I am trying to add a search query to include certain things and exclude certain things.
I’ve tried many different ways but could not get it to work.

For example, adding a minus sign in front actually gives me a positive result:

Query with the minus sign for the (-447442)

and it’s returning a result with that string

I’ve tried multiple other stuff like:
not name contains ‘{{69.reqNumber}}’
and many others nothing seems to work.

Here’s the config for the module:

I am using search within file/folder names because when I tried the custom query it returned 23 bundles. I am thinking it’s picking up cache files and duplicates so that’s not working.

All I am trying to do is search the folder for specific string that either match or don’t match and save a file with the name “add on” if those conditions fulfills.

Been struggling with this for many hours. Any help would be appreciated.

[samliew]

This is not a Make bug.

Google Drive does not have a “negative” search operator — you cannot use - to exclude words.

For more information, check it out yourself by clicking the advanced search icon to build your own query:

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

---

P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

[Peter_Chen]

If there is no way to search for negative or exclude words, are there any other work arounds?

[samliew]

You can simply use a filter after this module.

[LinkYourTech]

You could just use a filter and set the criterias. Thats probably the easiest way to do it.

[Peter_Chen]

Was able to figure it out with reverse logic of searching positive and then having the router logic reverse too.