Add a parameter field for input to SQL searching
Could you please look into providing an input field on SQL Find tool searches to allow the library staff to easily enter a search parameter e.g. an items barcode, a patron barcode.
At the moment with the SQL FIND TOOL searches we have created, we must teach them to go to the WHERE clause and correctly change the parameter before re-executing the query.
A dedicated entry parameter would simplify the use and training of SQL searching using the FIND tool.
Lynton Frost-Foster
shared this idea
-
Wes Osborn
commented
Even allowing the parameters to be defined like you would normally in SQL with the variables at the top of the statement would be helpful. Though I think these might get wrapped as CTEs which might not allow for that.
-
Wes Osborn
commented
Just curious are you normally inputting branch and/or library ids? Forever, I have wanted the ability for us to put in a variable like $LOGGED-IN-BRANCHID into Find Tool sql and it would swap it out for the user's branch. Same with LIBRARYID too.
(sorry, I'm now seeing in your screenshot that your example is a barcode search)
Though your option could be more veristable for other Find Tool searches. It might be cool if the staff person could *optionally* save the parameters they've used for each different search as well.