Kinook Software Forums

Kinook Software Forums (
-   [UR] General Discussion (
-   -   Retrieve search item results directly via SQLite (

aaronjsolomon 05-27-2019 04:49 PM

Retrieve search item results directly via SQLite

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 05-27-2019 05:08 PM

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 05-27-2019 05:11 PM

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

Cheers, Aaron

All times are GMT -5. The time now is 06:02 PM.

Copyright 1999-2019 Kinook Software, Inc.