Retrieve search item results directly via SQLite

[aaronjsolomon]

Hi,

Is it possible to create a SQL query that can be run in SQLite client and, by referencing the Item ID of a given search item, produce the same results that the item produces in Ultra Recall itself?

Alternatively, is there any other way to programmatically access and manipulate these results?

I'd like to do things like run a SQL, VBScript, PowerShell, or batch script that sets the status/flag for all results of a given search item.

Thanks, Aaron

[kinook]

Not easily, since the query can be quite complex and will vary based on search settings and options. You could use the /item command-line flag to initiate the search, and then select all of the search results and update the Flag attribute, but it would be difficult to completely automate the process.

[aaronjsolomon]

That's what I suspected. Thanks for the reply.

Cheers, Aaron