Use cases not covered by MARC search query api

Use CaseQuery neededAdded byCommunity WorkaroundsNotes/Next steps
I need to find records for videos that are non-English and in the original language for language departments. For example, French films originally filmed in French, not English films with French dubs. I'd like to query fields 041$a and 041$h for 'fre' and leader position 6 for 'g'.Searches that combine and the leader and MARC fields

this seems to works now on Orchid-SP-6

I need to find records for books that were published pre-1501 for Special Collections. Inventory queries for publication dates (mapped from 264$c) have not been fruitful due to the variability of the field. I'd like to query 008 position 7 (008.07_04) for >1 and <1501.Searches date range in the 008

Jamie Jesanis (Unlicensed) Wellesley College