# Elastic Stack **URL:** https://discuss.elastic.co/c/elastic-stack/81.md?page=882 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 883 --- ## [Sorted Pagination on Composite Aggregation](https://discuss.elastic.co/t/sorted-pagination-on-composite-aggregation/308498)
**Author:** [@Mohammad\_Musharraf](https://discuss.elastic.co/u/Mohammad_Musharraf)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 4:19pm UTC](https://discuss.elastic.co/t/sorted-pagination-on-composite-aggregation/308498 "2022-06-29T16:19:36Z")
I have ElasticSearch 7.1 documents with following mappings:- { "event" : { "mappings" : { "properties" : { "Code1" : { "type" : "keyword" }, "Code2" : { "type" : "… --- ## [Cannot add a value for field \[stepContexts.pageContext.metas\] since one of the intermediate objects is mapped as a nested object: \[stepContexts\]](https://discuss.elastic.co/t/cannot-add-a-value-for-field-stepcontexts-pagecontext-metas-since-one-of-the-intermediate-objects-is-mapped-as-a-nested-object-stepcontexts/308122)
**Author:** [@Sohaib\_Ameen](https://discuss.elastic.co/u/Sohaib_Ameen)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 4:13pm UTC](https://discuss.elastic.co/t/cannot-add-a-value-for-field-stepcontexts-pagecontext-metas-since-one-of-the-intermediate-objects-is-mapped-as-a-nested-object-stepcontexts/308122 "2022-06-29T16:13:31Z")
"stepContexts" : { "type" : "nested", "properties" : { "additionalContext" : { "type" : "text", "analyzer" : "custom\_analyzer" }, "branchId" : { … --- ## [Alternatives to stemming for plural search term match](https://discuss.elastic.co/t/alternatives-to-stemming-for-plural-search-term-match/308111)
**Author:** [@ano](https://discuss.elastic.co/u/ano)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 4:09pm UTC](https://discuss.elastic.co/t/alternatives-to-stemming-for-plural-search-term-match/308111 "2022-06-29T16:09:30Z")
Hi all, I have a use case where I want a match when the search string is a plural of a word that's in the index. So, for eg, if the word "Sweet" is indexed, then a search term "Sweets" should match. I know this can be d… --- ## [Mapper\_parsing\_exception when indexing JSON with id property name](https://discuss.elastic.co/t/mapper-parsing-exception-when-indexing-json-with-id-property-name/308493)
**Author:** [@paolovalladolid](https://discuss.elastic.co/u/paolovalladolid)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 3:55pm UTC](https://discuss.elastic.co/t/mapper-parsing-exception-when-indexing-json-with-id-property-name/308493 "2022-06-29T15:55:26Z")
This is the error message: Elasticsearch.Net.ElasticsearchClientException: 'Request failed to execute. Call: Status code 400 from: PUT /developer-api-portal/\_doc/d63ec56a-c5af-4c1c-a0e0-14340658aa86. ServerError: Type: … --- ## [Accessing the previous value in a field in logstash](https://discuss.elastic.co/t/accessing-the-previous-value-in-a-field-in-logstash/308462)
**Author:** [@dishant.sharma](https://discuss.elastic.co/u/dishant.sharma)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 3:47pm UTC](https://discuss.elastic.co/t/accessing-the-previous-value-in-a-field-in-logstash/308462 "2022-06-29T15:47:24Z")
A detailed explanation of the issue is on the above link. --- ## [Query to get latest document per minute](https://discuss.elastic.co/t/query-to-get-latest-document-per-minute/308452)
**Author:** [@Yair\_Gofen](https://discuss.elastic.co/u/Yair_Gofen)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 3:32pm UTC](https://discuss.elastic.co/t/query-to-get-latest-document-per-minute/308452 "2022-06-29T15:32:37Z")
Hi, I am looking for a way to filter documents according to their timestamp, and get only latest document per 1 min. for example, i have 10 document indexed per minute, and i want to query over time range of 10 minutes… --- ## [Accessing pages from a Datatable in Kibana canvas by the arrows](https://discuss.elastic.co/t/accessing-pages-from-a-datatable-in-kibana-canvas-by-the-arrows/306698)
**Author:** [@SamuelSMendes](https://discuss.elastic.co/u/SamuelSMendes)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 3:27pm UTC](https://discuss.elastic.co/t/accessing-pages-from-a-datatable-in-kibana-canvas-by-the-arrows/306698 "2022-06-29T15:27:02Z")
I want to be aple to change the pages in the table by using the arrows (like in the image below) is there a way to do so? Kibana version: 7.10.0 --- ## [Aggregations by combining in/out datetimes to get inventory over time](https://discuss.elastic.co/t/aggregations-by-combining-in-out-datetimes-to-get-inventory-over-time/308484)
**Author:** [@mattvl](https://discuss.elastic.co/u/mattvl)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 2:40pm UTC](https://discuss.elastic.co/t/aggregations-by-combining-in-out-datetimes-to-get-inventory-over-time/308484 "2022-06-29T14:40:33Z")
I have several inventory documents stored in elasticsearch, here is a simplified example (dates in database format YYYY-MM-DD): \[ {"item\_id": "a1", "in": "2020-12-01", "out": "2021-02-03"}, {"item\_id": "b2", "in… --- ## [Configured ELK Basic TLS Security](https://discuss.elastic.co/t/configured-elk-basic-tls-security/308387)
**Author:** [@ftayyab](https://discuss.elastic.co/u/ftayyab)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 2:34pm UTC](https://discuss.elastic.co/t/configured-elk-basic-tls-security/308387 "2022-06-29T14:34:06Z")
Hi, I have been able to follow the documentation and generate my own certificates and used them in Elasticsearch for Transport and HTTP security. Elasticsearch is up and running. I have also been able to establish conne… --- ## [How to use Atlassian Jira integration with Elastic Agent?](https://discuss.elastic.co/t/how-to-use-atlassian-jira-integration-with-elastic-agent/308478)
**Author:** [@SamuelSMendes](https://discuss.elastic.co/u/SamuelSMendes)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 1:52pm UTC](https://discuss.elastic.co/t/how-to-use-atlassian-jira-integration-with-elastic-agent/308478 "2022-06-29T13:52:58Z")
I've been trying to setup the Atlassian Jira integration by Elastic Agent in the Elastic Cloud but so far haven't been able to. Is there a place I can see step by step how to setup it? Landed 3 pipeline assets but I sti… --- ## [How do I apply search analyzer to specific field in elasticsearch](https://discuss.elastic.co/t/how-do-i-apply-search-analyzer-to-specific-field-in-elasticsearch/308477)
**Author:** [@Ngabo\_Tresor](https://discuss.elastic.co/u/Ngabo_Tresor)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 1:37pm UTC](https://discuss.elastic.co/t/how-do-i-apply-search-analyzer-to-specific-field-in-elasticsearch/308477 "2022-06-29T13:37:51Z")
Hello, I'm newbie to elasticsearch and would like to use the search analyzer on a certain field in the existing index. For instance, I want to convert the uppercase values in the retrieve field to lowercase letters. I wo… --- ## [JDBC Communication error with Logstash](https://discuss.elastic.co/t/jdbc-communication-error-with-logstash/308454)
**Author:** [@Simone1](https://discuss.elastic.co/u/Simone1)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 1:26pm UTC](https://discuss.elastic.co/t/jdbc-communication-error-with-logstash/308454 "2022-06-29T13:26:50Z")
I'm trying to collect data with Logstash from a remote MySQL db and i'm receving the following error: \[ERROR\] 2022-06-29 11:44:57.733 \[\[main\]\"… --- ## [High CPU load when using vector tile search API](https://discuss.elastic.co/t/high-cpu-load-when-using-vector-tile-search-api/308373)
**Author:** [@thibaultclem](https://discuss.elastic.co/u/thibaultclem)\ **Replies:** 5\ **Last updated:** [June 29, 2022, 1:18pm UTC](https://discuss.elastic.co/t/high-cpu-load-when-using-vector-tile-search-api/308373 "2022-06-29T13:18:45Z")
Hi everyone, We use Elasticsearch mainly for the vector tile search API and we are trying to figure out what could be the best way to configure it for better performance. We have a CPU optimized deployment on Elastic C… --- ## [Kibana install](https://discuss.elastic.co/t/kibana-install/308193)
**Author:** [@chandramouli\_ravi](https://discuss.elastic.co/u/chandramouli_ravi)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 1:18pm UTC](https://discuss.elastic.co/t/kibana-install/308193 "2022-06-29T13:18:14Z")
Hi, I have installed ElasticSearch 8.2.3 and its working ok and able to created index, document, able to search etc., Now, i want to install kibana-8.2.3 My os # Windows 10 When i run kibana.bat, i am getting this err… --- ## [Systemctl status kibana & systemctl status Elasticsearch is Running but kibana page is not loading](https://discuss.elastic.co/t/systemctl-status-kibana-systemctl-status-elasticsearch-is-running-but-kibana-page-is-not-loading/308467)
**Author:** [@bbkunbi](https://discuss.elastic.co/u/bbkunbi)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 1:15pm UTC](https://discuss.elastic.co/t/systemctl-status-kibana-systemctl-status-elasticsearch-is-running-but-kibana-page-is-not-loading/308467 "2022-06-29T13:15:14Z")
command result :==\> journalctl -fu kibana.service Jun 29 18:18:13 linux kibana\[54048\]: FATAL Error: Unable to complete saved object migrations for the \[.kibana\] index. Please check the health of your Elasticsearch clu… --- ## [Two questions about Kibana alarms](https://discuss.elastic.co/t/two-questions-about-kibana-alarms/306289)
**Author:** [@fgjensen](https://discuss.elastic.co/u/fgjensen)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 1:15pm UTC](https://discuss.elastic.co/t/two-questions-about-kibana-alarms/306289 "2022-06-29T13:15:11Z")
Hi Could you, please, help with two issues about Kibana alarms? The tags I can add to a rule when creating a rule from the Rules and Connectors page seem to be integrated with the tags I can create from the Kibana Ta… --- ## [Importing csv in Kibana with array of object](https://discuss.elastic.co/t/importing-csv-in-kibana-with-array-of-object/308469)
**Author:** [@KRISHNAPRASAD\_HG](https://discuss.elastic.co/u/KRISHNAPRASAD_HG)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 12:56pm UTC](https://discuss.elastic.co/t/importing-csv-in-kibana-with-array-of-object/308469 "2022-06-29T12:56:31Z")
My CSV has this kind of data. When i import 'Colours you like' is imported as text. How i can make an array while importing the csv? Thanks in advance Name Colours you like Raj Black, Blue Ram Blue, White, Red Mohan Red… --- ## [Can't access to dashboard via Markdown link](https://discuss.elastic.co/t/cant-access-to-dashboard-via-markdown-link/307992)
**Author:** [@franckfct](https://discuss.elastic.co/u/franckfct)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 12:45pm UTC](https://discuss.elastic.co/t/cant-access-to-dashboard-via-markdown-link/307992 "2022-06-29T12:45:56Z")
Hi, I have several dashboards, i can access to them via the dashboard menu without any issues. I created a "landing" dashboard with Markdown text and links. When i try to access to them, i have the message : ## You do… --- ## [Add New field by Comparing Date](https://discuss.elastic.co/t/add-new-field-by-comparing-date/307895)
**Author:** [@RahulWagh](https://discuss.elastic.co/u/RahulWagh)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 12:06pm UTC](https://discuss.elastic.co/t/add-new-field-by-comparing-date/307895 "2022-06-29T12:06:27Z")
Hi, I am using Kibana v7.17 where I am trying to create new calculated field by comparing the date present in the existing field with hardcoded date. For e.g. if(doc\['trans\_date'\].value \>= "2021-02-15" {emit("FY 2021"} … --- ## [ElasticSearch REST API](https://discuss.elastic.co/t/elasticsearch-rest-api/308316)
**Author:** [@nijojob](https://discuss.elastic.co/u/nijojob)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 11:43am UTC](https://discuss.elastic.co/t/elasticsearch-rest-api/308316 "2022-06-29T11:43:41Z")
We are planning to send logs from Boomi to Elasticsearch directly using ELK REST APIs without using either Beats or Logstash. Document APIs | Elasticsearch Guide \[8.2\] | Elastic Is there any rate limiting for these API… --- ## [Convert Array to String by ingesting three double quotes](https://discuss.elastic.co/t/convert-array-to-string-by-ingesting-three-double-quotes/308358)
**Author:** [@Elie](https://discuss.elastic.co/u/Elie)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 10:40am UTC](https://discuss.elastic.co/t/convert-array-to-string-by-ingesting-three-double-quotes/308358 "2022-06-29T10:40:31Z")
Hi, I am wanting to change an Array to a String to make it easier for me to store in my Elasticsearch, but I am having trouble finding the way of doing so. There are some special cases in my data where my field "value" … --- ## [How to show data on cell when move pointer to this cell](https://discuss.elastic.co/t/how-to-show-data-on-cell-when-move-pointer-to-this-cell/308091)
**Author:** [@vuhai\_fo4](https://discuss.elastic.co/u/vuhai_fo4)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 10:21am UTC](https://discuss.elastic.co/t/how-to-show-data-on-cell-when-move-pointer-to-this-cell/308091 "2022-06-29T10:21:04Z")
Hi all, I have an issue with cells on my dashboard. I can't resize column because data on them is so long. Now, I want to view data on cell by move pointer to this cell. It same hint or suggest click about data of this c… --- ## [Kibana maps - add DSL Filter](https://discuss.elastic.co/t/kibana-maps-add-dsl-filter/308267)
**Author:** [@Yair\_Gofen](https://discuss.elastic.co/u/Yair_Gofen)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 10:03am UTC](https://discuss.elastic.co/t/kibana-maps-add-dsl-filter/308267 "2022-06-29T10:03:41Z")
Hi, I want to add filter to a layer on my map to reduce number of returned documents. however, i can only add a filter in KQL format and not DSL format. my filter uses painless script, and i don't know how to do that … --- ## [Regarding Mutate Ruby filter](https://discuss.elastic.co/t/regarding-mutate-ruby-filter/308426)
**Author:** [@suresh\_u](https://discuss.elastic.co/u/suresh_u)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 9:49am UTC](https://discuss.elastic.co/t/regarding-mutate-ruby-filter/308426 "2022-06-29T09:49:43Z")
I have 1 sample transaction number 10004567-P658910-569876. I want to seperate above transaction number with index 0 as 1 seperate field and remaining as other field. Ex: 10004567-P658910-569876 Num\_field = 10004567 … --- ## [Is "properties of analysis\_config" in Preview transform API Doc right?](https://discuss.elastic.co/t/is-properties-of-analysis-config-in-preview-transform-api-doc-right/308432)
**Author:** [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 9:40am UTC](https://discuss.elastic.co/t/is-properties-of-analysis-config-in-preview-transform-api-doc-right/308432 "2022-06-29T09:40:32Z")
Hi, Team, Preview Transform API Though it is not so important property for preview , "Properties of analysis\_config" should be "Properties of time"? In Create Transform API, it says "Properties of time". --- ## [Convert iso 8601 timestamp to UNIX\_MS](https://discuss.elastic.co/t/convert-iso-8601-timestamp-to-unix-ms/306693)
**Author:** [@The-morpho](https://discuss.elastic.co/u/The-morpho)\ **Replies:** 15\ **Last updated:** [June 29, 2022, 9:38am UTC](https://discuss.elastic.co/t/convert-iso-8601-timestamp-to-unix-ms/306693 "2022-06-29T09:38:08Z")
Hello, I have json logs wich have a field timestamp in iso 8601 format I want to convert it to UNIX\_MS so I can calculate the response time between step 1 and 2, 1 and 3 for each mid. How this can be done ? This is an… --- ## [Rollover and Consolidation of Shards](https://discuss.elastic.co/t/rollover-and-consolidation-of-shards/307158)
**Author:** [@parthmaniar](https://discuss.elastic.co/u/parthmaniar)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 9:28am UTC](https://discuss.elastic.co/t/rollover-and-consolidation-of-shards/307158 "2022-06-29T09:28:31Z")
Hello, my cluster has 1150 primary shards with 2300 total shards. I wanted to: consolidate them into recommended size of 50 GB each (100 with replica). I have attempted to this via Kibana GUI (using force merge) but it… --- ## [ProducerConfig values not all set](https://discuss.elastic.co/t/producerconfig-values-not-all-set/308438)
**Author:** [@mikhatanu](https://discuss.elastic.co/u/mikhatanu)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 9:23am UTC](https://discuss.elastic.co/t/producerconfig-values-not-all-set/308438 "2022-06-29T09:23:11Z")
Hello, i've been using the kafka plugin and set some ssl settings in the plugin. The config checker (before starting logstash) detects my config values, but the producerConfig (in the log) is not set. my config: input … --- ## [Filter data in interval or based on a specific field](https://discuss.elastic.co/t/filter-data-in-interval-or-based-on-a-specific-field/308351)
**Author:** [@Alice\_Ionescu](https://discuss.elastic.co/u/Alice_Ionescu)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 9:02am UTC](https://discuss.elastic.co/t/filter-data-in-interval-or-based-on-a-specific-field/308351 "2022-06-29T09:02:35Z")
Hello, I would like to filter data based on an interval or based on a specific field. For example I have a filter for begin date, one for end date and one for a specific date Begin date filter looks like this I … --- ## [Default configuration Local installation of ES on windows 10](https://discuss.elastic.co/t/default-configuration-local-installation-of-es-on-windows-10/308356)
**Author:** [@ftayyab](https://discuss.elastic.co/u/ftayyab)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 8:59am UTC](https://discuss.elastic.co/t/default-configuration-local-installation-of-es-on-windows-10/308356 "2022-06-29T08:59:05Z")
Hello, I am able to run ES and Kibana on window 10 machine with default configuration. However if I shut down the ES process and try to start ES again after few days, I get the following: java.security.cert.Certificate… [Previous page](https://discuss.elastic.co/c/elastic-stack/81.md?page=881) [Next page](https://discuss.elastic.co/c/elastic-stack/81.md?page=883)