I have an ecommerce solution for classes that we are using Appsearch. We are indexing Parent classes with Child class attributes for specific sections
Section 1, Jan 1 @ 8am
Section 2, Jan 15 @ 10am
Section 3, Feb 1 @ 2pm
Title: Class ABC
StartDates array [jan 1, jan 15, feb 1]
StartTimes array [8am, 10am, 2pm]
We now need to be able to filter results for a starting date rate, AND a Starting time range and retrieve the appropriate results.
- StartDates between Jan 15 and Feb 15 AND StartTimes between 8am and 11am. It should return the above parent in the results because Jan 15 starts at 10am.
- StartDates between Jan 15 and Feb 15 AND StartTimes between 8am and 9am. No results should be returned because both constraints can't be satisfied.
Can that be accomplished in Appsearch? We are having trouble getting that request to work.
Elasticsearch supports "Nested object" and/or "join" features to support this requirement ... are those in Appsearch?