# Data Table and large fields

**URL:** <https://discuss.elastic.co/t/data-table-and-large-fields/84482>\
**Category:** Kibana\
**Created:** [May 4, 2017, 4:32am UTC](https://discuss.elastic.co/t/data-table-and-large-fields/84482 "2017-05-04T04:32:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tobymaro](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@Tobymaro](https://discuss.elastic.co/u/Tobymaro)\
**Post date:** [May 4, 2017, 4:32am UTC](https://discuss.elastic.co/t/data-table-and-large-fields/84482/1 "2017-05-04T04:32:55Z")

</div>

Hello,

I have search logs that contains query to database. Sometimes this query can contain more than 300 words(and symbols). I tried to build data table visualization and everything looks ok, but all records with query fiels bigger then approximately 220 symbols do not show up in visualization table. I tried to increase size option - but no luck.  
Any advise?

Thanks,  
Max.

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [May 4, 2017, 12:37pm UTC](https://discuss.elastic.co/t/data-table-and-large-fields/84482/2 "2017-05-04T12:37:48Z")

</div>

Which version of Kibana are you on? Does the table scroll horizontally or cut off?

In newer versions the words should be wrapping, we had [https://github.com/elastic/kibana/issues/2025](https://github.com/elastic/kibana/issues/2025) for tracking it.

---

<div class="post-metadata">

**Author:** ![Tobymaro](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@Tobymaro](https://discuss.elastic.co/u/Tobymaro)\
**Post date:** [May 5, 2017, 6:00am UTC](https://discuss.elastic.co/t/data-table-and-large-fields/84482/3 "2017-05-05T06:00:10Z")

</div>

Hello,  
Kibana has version 5.1.2. And the actual problem is missing logs. On dashboard I see all logs. But via data table I do not see all logs. I noticed that there are missing logs with large filed "query". Probably some other logs are missing as well.

Here is my table:

```
    {
  "title": "Usage Logs with Query",
  "type": "table",
  "params": {
    "perPage": 10,
    "showMeticsAtAllLevels": false,
    "showPartialRows": false,
    "showTotal": false,
    "sort": {
      "columnIndex": null,
      "direction": null
    },
    "totalFunc": "sum"
  },
  "aggs": [
    {
      "id": "1",
      "enabled": true,
      "type": "count",
      "schema": "metric",
      "params": {}
    },
    {
      "id": "2",
      "enabled": true,
      "type": "terms",
      "schema": "bucket",
      "params": {
        "field": "Department.keyword",
        "size": 5,
        "order": "desc",
        "orderBy": "1"
      }
    },
    {
      "id": "4",
      "enabled": true,
      "type": "terms",
      "schema": "bucket",
      "params": {
        "field": "Web_User_Id.keyword",
        "size": 5,
        "order": "desc",
        "orderBy": "1"
      }
    },
    {
      "id": "5",
      "enabled": true,
      "type": "terms",
      "schema": "bucket",
      "params": {
        "field": "User_Full_Name.keyword",
        "size": 5,
        "order": "desc",
        "orderBy": "1"
      }
    },
    {
      "id": "6",
      "enabled": true,
      "type": "terms",
      "schema": "bucket",
      "params": {
        "field": "User_Query.keyword",
        "size": 5,
        "order": "desc",
        "orderBy": "1"
      }
    }
  ],
  "listeners": {}
}
```

---

<div class="post-metadata">

**Author:** ![Tobymaro](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@Tobymaro](https://discuss.elastic.co/u/Tobymaro)\
**Post date:** [May 5, 2017, 9:25am UTC](https://discuss.elastic.co/t/data-table-and-large-fields/84482/4 "2017-05-05T09:25:27Z")

</div>

I would like to add, that if I enable option "Show partial rows". I see all logs records. But filed with "query" is empty for logs with large "query" filed. Looks like kibana doesn't get correct responce from elasticsearch.

---

<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:** [June 2, 2017, 9:31am UTC](https://discuss.elastic.co/t/data-table-and-large-fields/84482/5 "2017-06-02T09:31:56Z")

</div>

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