googleapis / google-api-nodejs-client

Google's officially supported Node.js client library for accessing Google APIs. Support for authorization and authentication with OAuth 2.0, API Keys and JWT (Service Tokens) is included.
https://googleapis.dev/nodejs/googleapis/latest/
Apache License 2.0
11.26k stars 1.91k forks source link

Full text search doesn't work when using 'in parents' option #3443

Open joeyave opened 4 months ago

joeyave commented 4 months ago

Thanks for stopping by to let us know something could be better!

Environment details

Programming language: go OS: MacOS, Linux Language runtime version: 1.21.6 Package version: v0.167.0 Steps to reproduce

Make a query with full text search that searches inside Google Docs file and add "in parents" option. Such as

Query:

fullText contains 'часом знемагаю' and trashed = false and mimeType = 'application/vnd.google-apps.document' and '1234567' in parents

Result:

{
  "files": []
}

Result is empty files list. But if remove "in parents" part and make another search I get this file. And that file has an ID in parents field.

Query:

fullText contains 'часом знемагаю' and trashed = false and mimeType = 'application/vnd.google-apps.document'

Result:

{
  "files": [
    {
      "parents": [
        "1234567"
      ]
    }
  ]
}

Interesting part is that it returns file if full text search query contains words from file's name.

joeyave commented 4 months ago

Query also works if I duplicate "in parents" part. fullText contains 'часом знемагаю' and trashed = false and mimeType = 'application/vnd.google-apps.document' and ('1234567' in parents or '1234567' in parents)