google-api-nodejs-client icon indicating copy to clipboard operation
google-api-nodejs-client copied to clipboard

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

Open joeyave opened this issue 1 year ago • 1 comments

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 avatar Feb 26 '24 20:02 joeyave

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)

joeyave avatar Feb 26 '24 21:02 joeyave