hi all, i'm attempting to suggest products across a range to users based on dimensions. if there is a "5x10mm Drill Set" for instance and a competitor sales something similar enough then i'd like to have it shown. the range, however, would need to be dynamic. i'm thinking for our initial testing phase we'll go with 10% in either direction of a number.
thus, a document that hits "drill set" but has the size1 field set to 4.5 or 5.5 would match for the "5" in the query. 1) what's the best field type to use for numeric ranges? i'll need to account for decimal places, up to two places though usually only one. 2) is there a way to dynamically set the range? thanks!
