This won't create the searches, but once you have created them (it sounded like you already did), you can update several in one step (specifying their ItemIDs as mentioned).
The initial steps outlined above for identifying the items and attributes to update should be a one-time effort, then you would periodically execute the customized SQL command to advance the searches.
You can save the SQL command in a .sql file (i.e., update.sql), then create a batch file (i.e., update.bat) like this:
sqlite3 mydb.urd <update.sql
Put sqlite3.exe, update.sql, and update.bat in the same folder as your database and double-click the .bat file (or set up a scheduled task, etc.) to run the command.
|