Kinook Software Forums

Go Back   Kinook Software Forums > Ultra Recall > [UR] General Discussion

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: 17
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: 5,608
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: 17
That's what I suspected. Thanks for the reply.

Cheers, Aaron
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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:57 PM.


Copyright 1999-2019 Kinook Software, Inc.