Azure search: flat data from Collection(Edm.String) -
i have following json structure after request azure search service (using search=*):
"value": [ { "@search.score": 1, "id": "160", "title": "title1", "description": "description", "address": "ranelagh gardens, london, sw6 3pr, uk", "categories": [ "{\r\n \"description\": \"c1\",\r\n \"id\": \"3\"\r\n}", "{\r\n \"description\": \"c2\",\r\n \"id\": \"4\"\r\n}" ] }
i want search inside categories such description=c1 can't. tried use $filter/categories.any(t:t eq 'c1') isn't working.
unfortunately azure search not yet support complex data types such this. top requested feature, high on our list support, take time implemented.
in meantime, of things might want in see if there option flatten documents. example, realistic create field in azure search index called categoriesdescription , 1 called categoriesid both collection type (basically array of strings)?
for example, perhaps have categoriesdescription contain ["c1", "c2] , categoriesid contain ["3", "4"]?
kirk evans did nice blog post covers topic of flattening json documents might find helpful.
liam
Comments
Post a Comment