More powerful saved searches?
Does the UI selection for a saved search result in a SQL query behind the scenes? Might it be possible to expose this to the user in text form and then allow the user to edit the query or to supply their own code? This is possible in Biblioscape and was very helpful for custom searchers and custom sorting of the results beyond the options supported by the UI.
Here is an example:
select Ref_ID, Folder, Folder_ID, Priority, Ref_type_ID, Year_pub, Authors, Title, Sec_title, Categories, Ref_Mark, Icon_au, Date_Freeform from bib where Deleted IS NULL and (UPPER(Ref_Type) = UPPER('Grant')) and (UPPER(Authors) like UPPER('%Smith%') or UPPER(Sec_Authors) like UPPER('%Smith%')) order by COALESCE(CAST(Year_pub AS VARCHAR(4)),
CASE WHEN RIGHT(date_freeform, 4) = 'oing'
THEN '9999'
ELSE RIGHT(date_freeform, 4)
END
) DESC,
date_freeform DESC
Here is an example:
select Ref_ID, Folder, Folder_ID, Priority, Ref_type_ID, Year_pub, Authors, Title, Sec_title, Categories, Ref_Mark, Icon_au, Date_Freeform from bib where Deleted IS NULL and (UPPER(Ref_Type) = UPPER('Grant')) and (UPPER(Authors) like UPPER('%Smith%') or UPPER(Sec_Authors) like UPPER('%Smith%')) order by COALESCE(CAST(Year_pub AS VARCHAR(4)),
CASE WHEN RIGHT(date_freeform, 4) = 'oing'
THEN '9999'
ELSE RIGHT(date_freeform, 4)
END
) DESC,
date_freeform DESC
This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.
There's also been talk of allowing custom user scripts to be saved and retrieved in that window.