Search the SFO Museum Collection
There are no results where
the object has not been digitized
and
the category is 1511214215
and
creditline is Gift of the Ralph F. Mitchell, Jr. Family
.
Would you like to try a new search?
Click here to see the database query used to perform this search
{ "query": { "function_score": { "query": { "bool": { "must": [ { "term": { "sfomuseum:placetype": "object" } }, { "bool": { "should": [ { "term": { "millsfield:category_id": "1511214215" } } ] } }, { "query_string": { "default_field": "sfomuseum:creditline", "default_operator": "AND", "query": "Gift of the Ralph F. Mitchell, Jr. Family" } } ], "must_not": [ { "bool": { "should": [ { "exists": { "field": "millsfield:images" } } ] } }, { "exists": { "field": "sfomuseum:image_id" } }, { "exists": { "field": "edtf:deprecated" } } ] } }, "functions": [], "boost_mode": "multiply", "score_mode": "multiply", "boost": 10, "max_boost": 500 } }, "sort": [ { "_script": { "type": "number", "script": "doc['millsfield:images'].size()", "order": "desc" } }, { "wof:name.keyword": "desc" }, { "date:inception_inner_start": "desc", "date:cessation_outer_end": "desc" } ], "aggs": { "collection": { "terms": { "field": "millsfield:collection_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "category": { "terms": { "field": "millsfield:category_id", "exclude": [ -1, "1511214215" ], "size": 1000, "order": { "_key": "asc" } } }, "subcategory": { "terms": { "field": "millsfield:subcategory_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "airline": { "terms": { "field": "millsfield:airline_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "aircraft": { "terms": { "field": "millsfield:aircraft_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "airport": { "terms": { "field": "millsfield:airport_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "images": { "value_count": { "field": "millsfield:images" } }, "year": { "date_histogram": { "field": "date:inception_lower", "calendar_interval": "year", "min_doc_count": 1 } }, "exhibition": { "terms": { "field": "millsfield:exhibition_ids", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } } } }