# Availability of employees during a period
**URL:** https://discuss.elastic.co/t/availability-of-employees-during-a-period/24075
**Category:** Elasticsearch
**Created:** [June 22, 2015, 11:19am UTC](https://discuss.elastic.co/t/availability-of-employees-during-a-period/24075 "2015-06-22T11:19:20Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@alexdtx](https://discuss.elastic.co/u/alexdtx)
#### Post date: [June 22, 2015, 11:19am UTC](https://discuss.elastic.co/t/availability-of-employees-during-a-period/24075/1 "2015-06-22T11:19:20Z")
Hello everybody,
I'm new on elasticsearch and in programming . My purpose is to use the search engine in order to search my employees according to their skills and their availabilities.
For the skills everything is good. For availability, I have no idea how could I do ? How could I map the document and how could I make a research.
Until now for each employee, I have a calendar with days of availability and days of unavailability.
Is it possible to do a research with a day of beginning and a day of end and display the number of day of availability ? or even diplay the date of each day of availability or unavailability ?
Does someone have any idea ? or a new way of thinking to resolve this problem ?
Thanks !
---
### Author:  [@eperry](https://discuss.elastic.co/u/eperry)
#### Post date: [June 22, 2015, 12:47pm UTC](https://discuss.elastic.co/t/availability-of-employees-during-a-period/24075/2 "2015-06-22T12:47:42Z")
Try using RANGE
[https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html)
```auto
{
"range" : {
"born" : {
"gte": "2012-01-01",
"lte": "now",
"time_zone": "+1:00"
}
}
}
```
---
### Author:  [@alexdtx](https://discuss.elastic.co/u/alexdtx)
#### Post date: [June 22, 2015, 1:13pm UTC](https://discuss.elastic.co/t/availability-of-employees-during-a-period/24075/3 "2015-06-22T13:13:46Z")
Ok so in this case, What should be the structure of my employee's document ?
Each employee can have 5 periods of availability and 4 periods of unavailability in one month by example. How can I model that ?
---
### Author:  [@salat](https://discuss.elastic.co/u/salat)
#### Post date: [June 22, 2015, 1:58pm UTC](https://discuss.elastic.co/t/availability-of-employees-during-a-period/24075/4 "2015-06-22T13:58:19Z")
You build a separate index "employee\_schedule" where you save the available dates of each employee. Afterwards you can filter by range and employee\_id, i.e.:
Index: employee
Fields: Id, Firstname, Lastname
Index: employee\_schedule
Fields: Id, Employee\_Id (link to employee index / maybe as parent field), available\_date\_start, available\_date\_end
So each employee can have multiple employee schedule entries... in your application logic you have to check for overlapping date ranges and prevent them.
Best
Steph
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 12:06am UTC](https://discuss.elastic.co/t/availability-of-employees-during-a-period/24075/5 "2017-07-06T00:06:09Z")