# Documents not showing up in Discover, but are showing up in queries in Dev Tools
**URL:** https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451
**Category:** Kibana
**Created:** [August 4, 2022, 4:48pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451 "2022-08-04T16:48:00Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@Arjun\_Meena](https://discuss.elastic.co/u/Arjun_Meena)
#### Post date: [August 4, 2022, 4:48pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/1 "2022-08-04T16:48:01Z")
I have an index **spoms-audit-2022.08.04** in which there are 4 documents. When I search them from the dev console, i am able to see all the documents.
Below is the search query:
These are the results I get back:
As we can see that I have 4 documents in total in this index pattern.
When I go to the discover tab and then in the index pattern **spoms-audit** \*, I am not able to see any logs.
The time range I have set in Discover tab far exceeds the time the logs were generated. Yet I am not able to see any logs here..
Any help would be appreciated. Thanks!
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 4, 2022, 4:58pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/2 "2022-08-04T16:58:29Z")
Hi @Arjun_Meena Welcome to the Commuity.
Did you set the `@timestamp` field as the time field in the index pattern when you set it up?
What version are you on?
---
### Author:  [@Arjun\_Meena](https://discuss.elastic.co/u/Arjun_Meena)
#### Post date: [August 4, 2022, 4:58pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/3 "2022-08-04T16:58:46Z")
Yes I did.
Here is the screenshot
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 4, 2022, 4:59pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/4 "2022-08-04T16:59:44Z")
What version are you on?
Do a Shift Reload of the Discover page.
---
### Author:  [@Arjun\_Meena](https://discuss.elastic.co/u/Arjun_Meena)
#### Post date: [August 4, 2022, 5:01pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/5 "2022-08-04T17:01:11Z")
Logstash is 8.3 and Elasticsearch is 8.2
---
### Author:  [@Arjun\_Meena](https://discuss.elastic.co/u/Arjun_Meena)
#### Post date: [August 4, 2022, 5:02pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/6 "2022-08-04T17:02:04Z")
I did Shift Reload, but still see nothing ☹
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 4, 2022, 5:04pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/7 "2022-08-04T17:04:23Z")
🙂 What timezone are you in?
Try this set discover to a future time say a day in the future
Pretty sure you are loading your time with out timezone so it is in the future.
Also when you show text please paste as text not screen shot... some people can not see the images and the can not be searched or debug... example I could not cut-paste your date
The Future 🙂
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 4, 2022, 5:16pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/9 "2022-08-04T17:16:08Z")
Simple / Most Likely your logs are in local / IST but when you are parsing with logstash you are not setting / accounting for the IST timezone.
If no timezone is provided then Logastash / Elastic assume UTC... that is what is happening you are "Ahead" of UCT
Where ever you are processing the date on ingest you need to account for timezone.
---
### Author:  [@Arjun\_Meena](https://discuss.elastic.co/u/Arjun_Meena)
#### Post date: [August 4, 2022, 5:20pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/10 "2022-08-04T17:20:29Z")
I'm updating the timestamp using the logstash filter, Is there any way I can tell it this time is in IST?
@stephenb I figured out the setting that I need to change... Thanks a lot!! We were stuck on this for about a week now..Thanks a lot for your help. You rock 🙂 🤩
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 4, 2022, 5:33pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/11 "2022-08-04T17:33:25Z")
@Arjun_Meena
OK good community is to not post screen shot... and if you do have a solution you should post that for others to benefit from.. you say you solved it but did not show.. please do 🙂 so the next person can learn from you!
---
### Author:  [@Arjun\_Meena](https://discuss.elastic.co/u/Arjun_Meena)
#### Post date: [August 4, 2022, 9:19pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/12 "2022-08-04T21:19:07Z")
The timestamp of my logs was in the local timezone (IST). I was picking the timestamp from my logs and overwriting it to the @timestamp field using logstash date filter plugin. I didn't specify any timezone setting there, so elasticsearch is taking that @timestamp as UTC and converting it to our local time zone, making them 5:30 hours ahead of their actual time.
So a log with an original timestamp of August 4th, 2022 20:40:58.364 (IST) would be shown in the discover tab as August 5th, 2022 02:10:58.364.
All I had to do to fix this was basically specify the timezone of the logs in the date filter plugin, so the elasticsearch would know that the logs timstamp are already in the IST timezone, and it doesn't need to add any offset.
Below is the working logstash config:
```auto
#Update the timestamp with the timestamp present in the log
date {
match => ["timestamp", "dd-MM-yyyy'T'HH:mm:ss.SSS"]
target => "@timestamp"
timezone => "Asia/Kolkata"
}
```
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 1, 2022, 9:19pm UTC](https://discuss.elastic.co/t/documents-not-showing-up-in-discover-but-are-showing-up-in-queries-in-dev-tools/311451/13 "2022-09-01T21:19:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.