The Omni Group Forums

The Omni Group Forums (http://forums.omnigroup.com/index.php)
-   OmniFocus Extras (http://forums.omnigroup.com/forumdisplay.php?f=44)
-   -   Script to locate tasks with a certain date in a note (http://forums.omnigroup.com/showthread.php?t=19803)

daltongreen 2011-01-19 02:55 PM

Script to locate tasks with a certain date in a note
 
This is probably is easy script, but I can't seem to find one that works. I need a script to search all tasks in which the note contains a certain date - i.e. find task where note contains today - the "Where in OF" script isn't pulling them up.

Thanks in advance for any advice you can offer.

whpalmer4 2011-01-19 03:05 PM

What is the exact search query you are using in Where in OF? I just tried making a few test actions with "Today" or "1/19/11" in the notes, and had no trouble finding them with "tasks where note contains <txt>" and entering "today" or "1/19/11" when prompted for the value of <txt>...

daltongreen 2011-01-20 09:47 AM

[QUOTE=whpalmer4;91953]What is the exact search query you are using in Where in OF? I just tried making a few test actions with "Today" or "1/19/11" in the notes, and had no trouble finding them with "tasks where note contains <txt>" and entering "today" or "1/19/11" when prompted for the value of <txt>...[/QUOTE]
Hi - thanks for the reply. I have tried several searches is Where OF. I tried the built in search "tasks where note contains <txt>" and the I listed "today" as the text. But it doesn't pick it up. I have also tried writing my own search in the Where OF Library using "tasks where note contains <dte>" and that doesn't come up either.
Thanks for any advice you can provide.

RobTrew 2011-01-20 10:04 AM

Whpalmer4 has already given you the answer:
[INDENT][I]tasks where note contains <txt>[/I][/INDENT]
(I can see that you might intuitively think that a <dte> variable was the answer, but what you are looking for is a piece of [B]text[/B] within a note. Values supplied for <dte> can only match date fields like those in the due date, start date, date completed columns).

When you are prompted for a value for <txt>, enter your date in the exact format in which it occurs in the text of your notes.

whpalmer4 2011-01-20 10:07 AM

[QUOTE=daltongreen;91993]Hi - thanks for the reply. I have tried several searches is Where OF. I tried the built in search "tasks where note contains <txt>" and the I listed "today" as the text. But it doesn't pick it up. I have also tried writing my own search in the Where OF Library using "tasks where note contains <dte>" and that doesn't come up either.
Thanks for any advice you can provide.[/QUOTE]

Okay, are you expecting it to match "1/20/11" (or any other date representation) against "today"? If you have a note with the string "today" in it, a search for "tasks where note contains <txt>" with "today" as the <txt> will find it. It won't find a note with the string "1/20/11", however, unless that is the <txt> you supply.

It might be worth reinstalling [URL="http://bit.ly/OF-Find2"]Where in OF[/URL] to make sure you've got the most recent revision; I won't rule out the possibility that Rob might have had a bug in an older revision which would cause your problem. If that still doesn't work, perhaps you should post a screenshot showing an example of an action you think should be matched, but isn't.


All times are GMT -8. The time now is 03:00 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.