# When saving as CSV from Discover, only some row of search results are saved

**URL:** <https://forum.opensearch.org/t/when-saving-as-csv-from-discover-only-some-row-of-search-results-are-saved/14118>\
**Category:** Reporting Plugin\
**Created:** [April 26, 2023, 11:11am UTC](https://forum.opensearch.org/t/when-saving-as-csv-from-discover-only-some-row-of-search-results-are-saved/14118 "2023-04-26T11:11:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ignos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/ignos/32/5429_2.png) [@ignos](https://forum.opensearch.org/u/ignos)\
**Post date:** [April 26, 2023, 11:11am UTC](https://forum.opensearch.org/t/when-saving-as-csv-from-discover-only-some-row-of-search-results-are-saved/14118/1 "2023-04-26T11:11:27Z")

</div>

**Versions** (relevant - OpenSearch/Dashboard/Server OS/Browser):

OpenSearch 1.1.0 / Dashboard 1.1.0 / Docker ( Amazon Linux release 2 )

**Describe the issue** :

I did the following query in Discover

timestamp \>= 1682504039854 and tags: level=ERROR  
(timestamp field is of number type)

On browser, the data for dates greater than 1682504039854 is displayed normally ( 2000 rows ).  
However, when I save it as a csv using the Reporting function, only the data with timestamp = 1682504039854 is saved ( 3 rows ).

Is there any way to save all the query results printed on the screen as a csv?

**Configuration** :

**Relevant Logs or Screenshots** :

---

<div class="post-metadata">

**Author:** ![Gsmitt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/gsmitt/32/1718_2.png) [@Gsmitt](https://forum.opensearch.org/u/Gsmitt)\
**Post date:** [April 27, 2023, 3:47am UTC](https://forum.opensearch.org/t/when-saving-as-csv-from-discover-only-some-row-of-search-results-are-saved/14118/2 "2023-04-27T03:47:08Z")

</div>

Hey @ignos  
Just ran this through my lab using the filed level=error for last 30 minutes i recieved 81 hits, create a report then downloaded th CSV and showed 81 hits. Im unable to reproduce this issue. What does it show in the logs?

---

<div class="post-metadata">

**Author:** ![ignos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/ignos/32/5429_2.png) [@ignos](https://forum.opensearch.org/u/ignos)\
**Post date:** [April 28, 2023, 1:03am UTC](https://forum.opensearch.org/t/when-saving-as-csv-from-discover-only-some-row-of-search-results-are-saved/14118/3 "2023-04-28T01:03:54Z")

</div>

> [@Gsmitt](#):
>
> Just ran this through my lab using the filed level=error for last 30 minutes i recieved 81 hits, create a report then downloaded th CSV and showed 81 hits. Im unable to reproduce this issue. What does it show in the logs?

 ![os_rep_err](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/2X/b/bdb0a8412c5c5859385a23144584dbf9de6eb844.png)

Thank you for your confirmation. In my case, 1293 results were retrieved as shown in the attached image, but after saving as a CSV, the data was not saved as you can see in the text editor in the image.

Here are the cases I tested

case 1. time: 1682469072590 (10 results)  
10 results saved.

case 2. time \>= 1682469072590 (results: 200)  
0 results. No data saved.

case 3. time \>= 1682469072590 AND … ( Result : 100)  
10 cases saved. When adding AND conditions, only data with time = 1682469072590 is saved.

For reference, I tested with the same data after installing 2.6.0 and found it to be working fine. I looked at the release notes for each version and didn’t see anything about patches for this issue.

---

<div class="post-metadata">

**Author:** ![Gsmitt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/gsmitt/32/1718_2.png) [@Gsmitt](https://forum.opensearch.org/u/Gsmitt)\
**Post date:** [April 28, 2023, 1:25am UTC](https://forum.opensearch.org/t/when-saving-as-csv-from-discover-only-some-row-of-search-results-are-saved/14118/4 "2023-04-28T01:25:52Z")

</div>

Hey @ignos

Thanks for the feed back, that is odd for sure. By chance did you post this issue on Github?

> **[Build software better, together](https://github.com/opensearch-project/OpenSearch/issues/new/choose)**
>
> GitHub is where people build software. More than 100 million people use GitHub to discover, fork, and contribute to over 330 million projects.
