Obsolete
Status Update
Comments
ko...@gmail.com <ko...@gmail.com> #2
Thanks for reporting this issue, I've been able to replicate the problem.
jo...@fl-dc.org <jo...@fl-dc.org> #3
then why isn't this fixed? i create a document in GAS then search for a term within it to display on a UI but it doesn't show up in the UI - it should be searchable instantaneously after creation, I mean you all are supposed to be the search experts right? why not give us a folder refresh or something or just fix the issue already - year later and still broken
da...@davidfisco.com <da...@davidfisco.com> #4
Supporting Joe's comments. This functionality is needed.
[Deleted User] <[Deleted User]> #5
I have had this issue for a while but couldn't find the right topic,
I have tried indexing with the title and it works fine as a temporary fix,
i was using a unique string for each of my documents (formatted: AAAA/00) every time it made the document but couldn't be found within both drive and through the API, then i would add the same string within the body of the document and it would be fine,
one question on the indexing topic, are there limitations with the types of characters supported? (as this is going to be implemented, i think it's a good time to find out if there are any planned exclusions from this).
I have tried indexing with the title and it works fine as a temporary fix,
i was using a unique string for each of my documents (formatted: AAAA/00) every time it made the document but couldn't be found within both drive and through the API, then i would add the same string within the body of the document and it would be fine,
one question on the indexing topic, are there limitations with the types of characters supported? (as this is going to be implemented, i think it's a good time to find out if there are any planned exclusions from this).
jo...@fl-dc.org <jo...@fl-dc.org> #6
week later and a script created doc still does not get returned in a script generated search/find
jo...@fl-dc.org <jo...@fl-dc.org> #7
still doesn't work - how can there be such a huge difference in functionality - a doc is a doc and should be searchable - but no...if you create it with GAS then it's down the rabbit hole unless you only search via title and not the doc body
ma...@gmail.com <ma...@gmail.com> #8
We have Google Apps for Business, and we are testing an important project where Docs are created, from a template, filled by a script, with content coming from our ERP system. Currently indexing works only on document title, and this is a severe issue. (This is my private user, I can provide Google with the business one). I will also open this as a support request.
el...@techrockstars.com <el...@techrockstars.com> #9
Bump! I'm having the same problem but with spreadsheets. I'm building a search string that looks something like this:
var searchParams = "mimeType = 'application/vnd.google-apps.spreadsheet' and title contains 'Employee Timesheet' and trashed = false and (fullText contains '03/15/2015' or fullText contains '03/16/2015' or fullText contains '03/17/2015')";
And then using it in searchFiles() with DriveApp like this:
var timesheets = DriveApp.searchFiles(searchParams);
However, since most of the sheets I'm searching for are created and modified via GAS it doesn't look like they are being indexed and as a result not being returned by my search query. I'm using GAS to write a project for a major client and this functionality is absolutely necessary for performance. Please fix this.
ea...@pvld.org <ea...@pvld.org> #10
My company has been experiencing the same issue for a couple years now also. I've contacted Google Apps for Business support, but Google Apps Script isn't covered. Their recommendation is to open each Google Doc, make an edit, save it, and that makes the Doc searchable after a few minutes (I assume some indexing process runs after an edit). The issue for us (and probably others in this thread) is that a lot of Docs are created and sometimes they do not require manual editing but may need to be retrieved later. It would make finding Docs a lot easier if they were searchable without manual edits.
Here's how Docs are generated in our case:
An employee with a Google Apps for Business account fills out a Google Form. The Form submission goes to a Google Spreadsheet with a Google Apps Script that writes the contents of the row to a Doc Template where a Doc is created from the Doc Template. For organization, the new Doc is placed inside of a folder that is created (and titled with metadata from the submission) and nested inside a generic folder that is shared with the company.
For example: 2015 Reports Folder > My Report Folder - April 21, 2015 > My Report Doc (and other files I upload)
Here's how Docs are generated in our case:
An employee with a Google Apps for Business account fills out a Google Form. The Form submission goes to a Google Spreadsheet with a Google Apps Script that writes the contents of the row to a Doc Template where a Doc is created from the Doc Template. For organization, the new Doc is placed inside of a folder that is created (and titled with metadata from the submission) and nested inside a generic folder that is shared with the company.
For example: 2015 Reports Folder > My Report Folder - April 21, 2015 > My Report Doc (and other files I upload)
ek...@google.com <ek...@google.com>
ek...@google.com <ek...@google.com>
jp...@google.com <jp...@google.com> #11
Closing this as obsolete to better prioritize work. Please open a new issue if it is still valid. Thank you.
Description
1. Create 3 documents via script, all with the same text. I used the 'You can't handle the truth' speech from 'A Few Good Men'
2. Create 1 document manually, pasting in the same text.
3. Wait a short while, then from your main 'My Drive' folder search on one of the words such as 'weapon'. Only the manually created document is returned as a hit.
4. Wait a day and repeat. Again only the manually created document is returned as a hit.
5. Open one of the documents and close without editing. Open a second of the documents and make some edits.
6. Repeat the search again. This time the manually created document and document that has been edited will be returned as hits. The document that was opened/closed and the third that hasn't been touched after creation still are not found.
What is the expected output? What do you see instead?
The documents created via script should return in search results.
If possible, provide the code for a small sample script that reproduces the issue:
function newDoc() {
var title = "Document Search Testing ";
var txt = "You can't handle the truth! Son, we live in a world that has walls, and those walls have to be guarded by men with guns. Who's gonna do it? You? You, Lieutenant Weinberg? I have a greater responsibility than you can possibly fathom! You weep for Santiago and you curse the Marines. You have that luxury. You have the luxury of not knowing what I know: that Santiago's death, while tragic, probably saved lives. And my existence, while grotesque and incomprehensible to you, saves lives! You don't want the truth, because deep down in places you don't talk about at parties, you want me on that wall! You need me on that wall! We use words like honor, code, loyalty. We use these words as the backbone of a life spent defending something. You use them as a punchline! I have neither the time nor the inclination to explain myself to a man who rises and sleeps under the blanket of the very freedom that I provide, and then questions the manner in which I provide it! I would rather you just said Thank you, and went on your way. Otherwise, I suggest you pick up a weapon, and stand a post. Either way, I don't give a damn what you think you are entitled to!";
for (i=0; i<3; i++) {
var doc = DocumentApp.create(title + i);
doc.appendParagraph(txt);
doc.appendParagraph(" ");
doc.appendParagraph("the end");
doc.saveAndClose();
}
"done";
}
On which browser & OS?
Windows XP and 7, both tried with Chrome and Firefox
Please provide any additional information below.
I posted this as a question on Stack Overflow and did not receive any responses.