Allow use of SQL Queries to get a "Predefined" search term.
I would like to be able to use an SQL query to get the value for a predefined search field.
For instance, to be able to say that the Location field is locked to "SELECT LOCATION from dbo.USER_INFO where USERNAME = 'CURRENTUSERNAME'"
This would allow the predefined fields to be much more useful. The current set of five options is not very thorough, and not extensible at all. Being able to use those five predefined options in SQL queries would open up a much wider scope. Especially if they could be used in conjunction with the index data of the file cabinet.
1
vote
Josh
shared this idea