View Single Post
Brilliant, absolutely brilliant! Using SQL reduces processing time drastically. Thanks so much, Rob.

There is one more thing: What I would need in the end is a list containing three pieces of information: a handle to the tasks (like task id = your first answer), the DEVONthink link (=your second answer) and the task status (on hold, dropped, etc.).

I've seen that there is a discrepancy between the number of tasks and the number of links in executing your SQL commands. One reason is that there might be more than one link in one paragraph. I tried using "words" instead of "paragraphs", however the count does not match either. Is there an easy way to get the corresponding task (and task status) for each link using the method in your second reply?

Thanks!