I want to filter records from a Phonograph table in a query using Table Search Service, endpoint Search. The problem is (as far as I am aware of) the filter terms have to be low cap and contain no space. So if I search for "Grand Opening", my term would be "grand" or "opening". "Grand" or "grand opening" will not work due to capital and space. My problem of using "grand" is that the result will contain not only "Grand Opening" but also "Grand Closing"
Is there a way to use space in the filter term? Thank you
{
"tableRids": [
"table_phonograph_rid_12344567"
],
"filter": {
"type": "terms",
"terms": {
"field": "this_is_a_field_name",
"terms": ["grand"]
}
}
}