Re: Search using filter query on multivalued fields

2019-05-03 Thread David Hastings
another option is to index dynamically, so you would index in this case, or this is what i would do: INGREDIENT_SALT_i:40 INGREDIENT_EGG_i:20 etc and query INGREDIENT_SALT_i:[20 TO *] or an arbitrary max value, since these are percentages INGREDIENT_SALT_i:[20 TO 100] On Fri, May 3, 2019 at

Re: Search using filter query on multivalued fields

2019-05-03 Thread Erick Erickson
There is no way to do this with the setup you describe. That is, there’s no way to say “only use the third element of a multiValued field”. What I’d do is index (perhaps in a separate field) with payloads, so you have input like SALT|20, then use some of the payload functionality to make this

Search using filter query on multivalued fields

2019-05-03 Thread Srinivas Kashyap
Hi, I have indexed data as shown below using DIH: "INGREDIENT_NAME": [ "EGG", "CANOLA OIL", "SALT" ], "INGREDIENT_NO": [ "550", "297", "314" ], "COMPOSITION PERCENTAGE": [ 20, 60, 40