I’ve been playing around with script fields to manipulate data returned by ElasticSearch queries. As an example, data where there are a few nested objects with values that need to be multiplied together:<\/p>\n\n\n
\n{\n\t"order": {\n\t\t"item1": {\n\t\t\t"cost": 31.55,\n\t\t\t"count": 111\n\t\t},\n\t\t"item2": {\n\t\t\t"cost": 62.55,\n\t\t\t"count": 222\n\t\t},\n\t\t"item3": {\n\t\t\t"cost": 93.55,\n\t\t\t"count": 333\n\t\t}\n\t}\n}\n<\/pre><\/div>\n\n\nAnd to retrieve records and multiply cost by count:<\/p>\n\n\n
\n{\n "query" : { "match_all" : {} },\n\t"_source": ["order.item*.item", "order.item*.count", "order.item*.cost"],\n "script_fields" : {\n "total_cost_1" : {\n "script" : \n {\n "lang": "painless",\n "source": "return doc['order.item1.cost'].value * doc['order.item1.count'].value;"\n }\n },\n "total_cost_2" : {\n "script" : \n {\n "lang": "painless",\n "source": "return doc['order.item2.cost'].value * doc['order.item2.count'].value;"\n }\n },\n "total_cost_3" : {\n "script" : \n {\n "lang": "painless",\n "source": "return doc['order.item3.cost'].value * doc['order.item3.count'].value;"\n }\n } \n }\n}\n<\/pre><\/div>\n\n\nUnfortunately, I cannot find any way to iterate across an arbitrary number of item# objects nested in the order object. So, for now, I think the data manipulation will be done in the program using the API to retrieve data. Still, it was good to learn how to address values in the doc record. <\/p>\n","protected":false},"excerpt":{"rendered":"
I’ve been playing around with script fields to manipulate data returned by ElasticSearch queries. As an example, data where there are a few nested objects with values that need to be multiplied together: And to retrieve records and multiply cost by count: Unfortunately, I cannot find any way to iterate across an arbitrary number of …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1588],"tags":[1590,1589],"class_list":["post-9072","post","type-post","status-publish","format-standard","hentry","category-elk","tag-elasticsearch","tag-elk"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/9072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9072"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/9072\/revisions"}],"predecessor-version":[{"id":9073,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/9072\/revisions\/9073"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}