Any pointers on the same would help.
Op vrijdag 20 december 2013 21:16:08 UTC+1 schreef Bijuv V:
>
>
> I have the data in the following format in Elastic Search (from sense)
>
> POST slots/slot/1
> {
> locationid:"1",
> roomid:"10",
> starttime: "08:45"
> }
>
> POST slots/slot/2
> {
> locationid:"1",
> roomid:"10",
> starttime: "09:00"
> }
>
>
> POST slots/slot/3
> {
> locationid:"2",
> roomid:"100",
> starttime: "08:45"
> }
>
>
> POST slots/slot/4
> {
> locationid:"2",
> roomid:"101",
> starttime: "09:00"
> }
>
> POST slots/slot/5
> {
> locationid:"3",
> roomid:"200",
> starttime: "09:30"
> }
>
> In short , the data is in the following format.
>
> A Location has multiple rooms and each room has multiple slots of 15
> minutes. So slot 1 for Room10 starts at 8:45 and ends at 09:00, Slot 2 for
> same room starts at 09:00 and ends at 09:15
>
> Locationid RoomId Starttime
> 1 10 08:45
> 1 10 09:00
> 2 100 08:45
> 2 101 09:00
> 3 200 09:30
>
> Im trying to write a query/filter which will give me all locations where a
> room is available with two or three slots.
>
> For e.g Find a location that has 08:45 slot and 09:00 slot (configurable)
> Answer should be location 1 only
> Should Not be location 2 as room 100 has 08:45 slot but not the 09:00
> slot. Room 101 has 09:00 slot but doesnt have the 08:45 slot
>
>
>
>
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/25861339-0a77-4969-a67f-084cd42b9aa4%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
