# Modeling business hours for 'open now' queries

**URL:** <https://discuss.elastic.co/t/modeling-business-hours-for-open-now-queries/133060>\
**Category:** Elasticsearch\
**Created:** [May 24, 2018, 12:12am UTC](https://discuss.elastic.co/t/modeling-business-hours-for-open-now-queries/133060 "2018-05-24T00:12:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![panthersquirrel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/panthersquirrel/32/31548_2.png) [@panthersquirrel](https://discuss.elastic.co/u/panthersquirrel)\
**Post date:** [May 24, 2018, 12:12am UTC](https://discuss.elastic.co/t/modeling-business-hours-for-open-now-queries/133060/1 "2018-05-24T00:12:03Z")

</div>

Suppose i have a set of users that are businesses and these businesses can have business hours in their respective timezones (ie America/Los\_Angeles...). For each of these businesses, they have a set of items, possibly in the hundreds.

I want to perform queries like, "grab me 50 items among all businesses in my area that are open now". I'm not sure the best way to model this considering I'll need to replicate the business hours across the user and all of its items.

My best guess for the most efficient queries would be to model a user/its items like this:

```auto
/users/_doc/1
{
	name: 'bus 1',
	uid: 'alpha',
	...
	hours: {
		0: true,
		49: true
		,...
	}
}

/items/_doc/100
{
	name: 'item name',
	key: 'bravo',
	...
	owner_data: {
		name: 'bus 1',
		uid: 'alpha',
		...
		hours: {
			0: true,
			49: true
			,...
		}
	}
}

```

`hours.0 = true` indicates this business is open 00:00-\>00:30 UTC Sunday.  
`hours.49 = true` indicates this business is open 00:30-\>01:00 UTC Monday.

This means there are a maximum of 336 (7 days a week \* 48 half hours) fields under the `hours` object.

The advantage to this is I can get the current half hour (say 49) and query those items where `owner_data.hours.49 === true`. Another advantage is this allows the users to have multiple open segments, ie '12:00-\> 18:00, 20:00 -\> 22:00`.

Finally, I'm not sure if the following is a disadvantage, and let me know if it isn't. This is a lot of data to replicate for just weekly business hours. An hours object could be 1kb, and in elastic could be much more when placed into the index.

Are there better alternatives? I've thought of the possibility of not storing hours data in the documents for items at all and doing a two stage query; 1st query the users that are open and then query items whose owner\_data.uid === user1openuid || ownerdata.uid === user2openuid ||... I imagine i could have hundreds of uids id have to OR together for each query which could be expensive, IDK.

Also if my original approach is plausible, what would the mapping look like for the hours object? In my opinion, that's a lot of fields for a mapping.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 24, 2018, 1:14am UTC](https://discuss.elastic.co/t/modeling-business-hours-for-open-now-queries/133060/2 "2018-05-24T01:14:10Z")

</div>

Try [https://www.elastic.co/guide/en/elasticsearch/reference/6.2/range.html](https://www.elastic.co/guide/en/elasticsearch/reference/6.2/range.html) instead, it'll be a lot more optimal.

---

<div class="post-metadata">

**Author:** ![panthersquirrel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/panthersquirrel/32/31548_2.png) [@panthersquirrel](https://discuss.elastic.co/u/panthersquirrel)\
**Post date:** [May 24, 2018, 3:17am UTC](https://discuss.elastic.co/t/modeling-business-hours-for-open-now-queries/133060/3 "2018-05-24T03:17:43Z")

</div>

Ok i will try this and post back my results.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 21, 2018, 3:17am UTC](https://discuss.elastic.co/t/modeling-business-hours-for-open-now-queries/133060/4 "2018-06-21T03:17:53Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.