Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [UR] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=23)
-   -   Retrieve search item results directly via SQLite (https://www.kinook.com/Forum/showthread.php?t=5591)

aaronjsolomon 05-27-2019 03:49 PM

Retrieve search item results directly via SQLite
 
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 05-27-2019 04: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 04:11 PM

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

Cheers, Aaron


All times are GMT -5. The time now is 05:38 AM.


Copyright © 1999-2023 Kinook Software, Inc.