Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 05-27-2019, 03:49 PM
aaronjsolomon aaronjsolomon is online now
Registered User
 
Join Date: 07-06-2011
Posts: 34
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
Reply With Quote
  #2  
Old 05-27-2019, 04:08 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
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.
Reply With Quote
  #3  
Old 05-27-2019, 04:11 PM
aaronjsolomon aaronjsolomon is online now
Registered User
 
Join Date: 07-06-2011
Posts: 34
That's what I suspected. Thanks for the reply.

Cheers, Aaron
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



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


Copyright © 1999-2023 Kinook Software, Inc.