# Not Getting data from Index pattern using SQL

**URL:** <https://discuss.elastic.co/t/not-getting-data-from-index-pattern-using-sql/218031>\
**Category:** Kibana\
**Created:** [February 5, 2020, 5:11pm UTC](https://discuss.elastic.co/t/not-getting-data-from-index-pattern-using-sql/218031 "2020-02-05T17:11:12Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![emad101](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/emad101/32/82338_2.png) [@emad101](https://discuss.elastic.co/u/emad101)\
**Post date:** [February 13, 2020, 2:23pm UTC](https://discuss.elastic.co/t/not-getting-data-from-index-pattern-using-sql/218031/4 "2020-02-13T14:23:03Z")

</div>

@Andrei_Stefan,  
I have actually not added any leading dots on my field names, it was automatically done somehow when pushing data. I am also using the latest version.

If you see the below picture, there is a highlighted red dot in the appcode field in the JSON tab

 ![Screen Shot 2020-02-13 at 9.19.58 AM](https://us1.discourse-cdn.com/elastic/original/3X/4/4/4422f99aa50957b92edb37665ed88f8269d0abe3.png)

However, in the table tab there is still no do in the app code field

 ![Screen Shot 2020-02-13 at 9.20.28 AM](https://us1.discourse-cdn.com/elastic/original/3X/b/9/b9eea4602676c9c681e4059ecc15c5e140d40a0e.png)

And when I try to query through the field this is the error I get  
"Unknown column [app\_code], did you mean [app\_code]"

This is the how I created the fields in the DevTools

 ![Screen Shot 2020-02-13 at 9.41.53 AM](https://us1.discourse-cdn.com/elastic/original/3X/1/7/17f609217b32600438bff54bc65c4f8ae3280c98.png)

---

_[View the full topic](https://discuss.elastic.co/t/not-getting-data-from-index-pattern-using-sql/218031)._