# Data modeling qustion

**URL:** <https://discuss.elastic.co/t/data-modeling-qustion/196641>\
**Category:** Logstash\
**Created:** [August 25, 2019, 1:07am UTC](https://discuss.elastic.co/t/data-modeling-qustion/196641 "2019-08-25T01:07:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [August 25, 2019, 1:07am UTC](https://discuss.elastic.co/t/data-modeling-qustion/196641/1 "2019-08-25T01:07:05Z")

</div>

I have a user record database which has  
employee, userinfo1, userinfo2, managername  
foo1, info1, info2, foo2  
foo2, info1, info2, foo3  
foo3, info1, info2, foo4

as now I have  
manager level foo4 -\> foo3 -\> foo2 -\> foo1

foo1 has three manger on top of him

how do I setup data model so every employee has manager and his manager and his manger all the way to top.

that way when I search for foo4 I get every employee under him and not just direct report employee.

is this possible?

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [August 26, 2019, 12:58pm UTC](https://discuss.elastic.co/t/data-modeling-qustion/196641/2 "2019-08-26T12:58:58Z")

</div>

I do not control how data is created on other end (mysql database)  
I just have permission to pull that data

---

<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:** [September 23, 2019, 12:59pm UTC](https://discuss.elastic.co/t/data-modeling-qustion/196641/3 "2019-09-23T12:59:47Z")

</div>

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