Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query fields not showing after saving and loading dashboard. #848

Closed
DannyJoris opened this issue Jan 20, 2014 · 7 comments
Closed

Query fields not showing after saving and loading dashboard. #848

DannyJoris opened this issue Jan 20, 2014 · 7 comments

Comments

@DannyJoris
Copy link

First of all, thank you for creating Kibana. It's a great tool and I love it.

After saving a dashboard and loading it again, not only are my queries missing, but I can't create any new queries at all. The query field isn't showing up: http://cl.ly/image/3x0s2z1o3609

The total, timeline and documents panels remain empty, but the other ones (term panels) do show up based on all results.

Any suggestions on how to debug this?

@DannyJoris
Copy link
Author

Same result in Firefox, Chrome and Safari.

@DannyJoris
Copy link
Author

I'm getting a lot of these in my js console:

TypeError: Cannot read property 'pin' of undefined at http://various.dev/kibana/app/app.js?r=f8e34a6:22:7528 at Array.filter (native) at Function.x.filter.x.select (http://various.dev/kibana/app/app.js?r=f8e34a6:6:29734) at Object.<anonymous> (http://various.dev/kibana/app/app.js?r=f8e34a6:22:7465) at e (http://various.dev/kibana/app/app.js?r=f8e34a6:8:13081) at Cd.| (http://various.dev/kibana/app/app.js?r=f8e34a6:9:18756) at l.constant (http://various.dev/kibana/app/app.js?r=f8e34a6:8:12629) at http://various.dev/kibana/app/app.js?r=f8e34a6:8:13333 at Object.c (http://various.dev/kibana/app/app.js?r=f8e34a6:8:22669) at Object.f.$digest (http://various.dev/kibana/app/app.js?r=f8e34a6:8:23370)

I'm running Elasticsearch and Kibana (with MAMP) both locally.

Where do project settings get stored when I save them? Locally in files or the browser?

@rashidkpc
Copy link
Contributor

Can you export the dashboard that is causing this and attach it to the issue? What version are you experiencing the issue with? Master or ?

@DannyJoris
Copy link
Author

ok - I found that the settings are stored in ES itself. I unescaped and formatted the stored json string. At first glance I can't see much wrong. I do see that under Services > Query, there's one query listed under "list", but 4 ID's under "ids".

Using kibana-latest.zip, downloaded Jan 18th.

{
   "title":"Drupal jobs",
   "services":{
      "query":{
         "list":{
            "0":{
               "query":"*",
               "alias":"",
               "color":"#7EB26D",
               "id":0,
               "pin":false,
               "type":"lucene",
               "enable":true
            }
         },
         "ids":[
            0,
            1,
            2,
            3
         ]
      },
      "filter":{
         "list":{

         },
         "ids":[

         ]
      }
   },
   "rows":[
      {
         "title":"Options",
         "height":"",
         "editable":true,
         "collapse":false,
         "collapsable":true,
         "panels":[
            {
               "span":4,
               "editable":true,
               "type":"hits",
               "loadingEditor":false,
               "style":{
                  "font-size":"52pt"
               },
               "arrangement":"horizontal",
               "chart":"total",
               "counter_pos":"above",
               "donut":false,
               "tilt":false,
               "labels":true,
               "spyable":true,
               "queries":{
                  "mode":"selected",
                  "ids":[
                     0
                  ]
               },
               "title":"Total"
            }
         ],
         "notice":false
      },
      {
         "title":"Graph",
         "height":"500px",
         "editable":true,
         "collapse":false,
         "collapsable":true,
         "panels":[
            {
               "span":12,
               "editable":true,
               "type":"histogram",
               "loadingEditor":false,
               "mode":"count",
               "time_field":"posted_on_date",
               "value_field":null,
               "x-axis":true,
               "y-axis":true,
               "scale":1,
               "y_format":"short",
               "grid":{
                  "max":null,
                  "min":0
               },
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "annotate":{
                  "enable":false,
                  "query":"*",
                  "size":20,
                  "field":"_type",
                  "sort":[
                     "_score",
                     "desc"
                  ]
               },
               "auto_int":false,
               "resolution":100,
               "interval":"1w",
               "intervals":[
                  "auto",
                  "1s",
                  "1m",
                  "5m",
                  "10m",
                  "30m",
                  "1h",
                  "3h",
                  "12h",
                  "1d",
                  "1w",
                  "1y"
               ],
               "lines":true,
               "fill":0,
               "linewidth":1,
               "points":false,
               "pointradius":5,
               "bars":false,
               "stack":false,
               "spyable":true,
               "zoomlinks":true,
               "options":true,
               "legend":true,
               "show_query":true,
               "interactive":true,
               "legend_counts":true,
               "timezone":"browser",
               "percentage":false,
               "zerofill":true,
               "derivative":false,
               "tooltip":{
                  "value_type":"cumulative",
                  "query_as_alias":true
               },
               "title":"Timeline"
            },
            {
               "error":false,
               "span":12,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"groups.original",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":250,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":true,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"bar",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Groups"
            },
            {
               "error":false,
               "span":4,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"telecommute.original",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":10,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":true,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"pie",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Telecommute"
            },
            {
               "error":false,
               "span":4,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"employment_type.original",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":10,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":true,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"pie",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Employment type"
            }
         ],
         "notice":false
      },
      {
         "title":"Lists",
         "height":"500px",
         "editable":true,
         "collapse":false,
         "collapsable":true,
         "panels":[
            {
               "error":false,
               "span":3,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"company.original",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":25,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":false,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"table",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Company"
            },
            {
               "error":false,
               "span":3,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"job_title.original",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":25,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":false,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"table",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Job title"
            },
            {
               "error":false,
               "span":3,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"job_title",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":25,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":false,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"table",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Job title (keywords)"
            },
            {
               "error":false,
               "span":3,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"posted_by.original",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":25,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":false,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"table",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Posted by"
            },
            {
               "error":false,
               "span":3,
               "editable":true,
               "type":"terms",
               "loadingEditor":false,
               "field":"terms.original",
               "exclude":[

               ],
               "missing":true,
               "other":true,
               "size":25,
               "order":"count",
               "style":{
                  "font-size":"10pt"
               },
               "donut":false,
               "tilt":false,
               "labels":true,
               "arrangement":"horizontal",
               "chart":"table",
               "counter_pos":"above",
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "tmode":"terms",
               "tstat":"total",
               "valuefield":"",
               "title":"Terms"
            }
         ],
         "notice":false
      },
      {
         "title":"Events",
         "height":"650px",
         "editable":true,
         "collapse":false,
         "collapsable":true,
         "panels":[
            {
               "error":false,
               "span":12,
               "editable":true,
               "group":[
                  "default"
               ],
               "type":"table",
               "size":100,
               "pages":5,
               "offset":0,
               "sort":[
                  "company",
                  "asc"
               ],
               "style":{
                  "font-size":"9pt"
               },
               "overflow":"min-height",
               "fields":[
                  "company",
                  "job_title",
                  "posted_on_date",
                  "groups"
               ],
               "highlight":[

               ],
               "sortable":true,
               "header":true,
               "paging":true,
               "spyable":true,
               "queries":{
                  "mode":"all",
                  "ids":[
                     0,
                     1,
                     2,
                     3
                  ]
               },
               "field_list":true,
               "status":"Stable",
               "trimFactor":300,
               "normTimes":true,
               "title":"Documents",
               "all_fields":false,
               "localTime":false,
               "timeField":"@timestamp"
            }
         ],
         "notice":false
      }
   ],
   "editable":true,
   "index":{
      "interval":"none",
      "pattern":"[logstash-]YYYY.MM.DD",
      "default":"scraper/jobs",
      "warm_fields":false
   },
   "style":"dark",
   "failover":false,
   "panel_hints":true,
   "loader":{
      "save_gist":false,
      "save_elasticsearch":true,
      "save_local":true,
      "save_default":true,
      "save_temp":true,
      "save_temp_ttl_enable":true,
      "save_temp_ttl":"30d",
      "load_gist":true,
      "load_elasticsearch":true,
      "load_elasticsearch_size":20,
      "load_local":true,
      "hide":false
   },
   "pulldowns":[
      {
         "type":"query",
         "collapse":false,
         "notice":false,
         "query":"*",
         "pinned":true,
         "history":[
            "groups.original:\"Vancouver\"",
            "groups.original:\"Washington, DC Drupalers\"",
            "groups.original:\"New York City\"",
            "*",
            "groups.original:\"New York\"",
            "groups.original:\"Boston\"",
            "telecommute.original:\"Not allowed\"",
            "telecommute:\"Not allowed\"",
            "solr",
            "Solr"
         ],
         "remember":10,
         "enable":true
      },
      {
         "type":"filtering",
         "collapse":false,
         "notice":true,
         "enable":true
      }
   ],
   "nav":[
      {
         "type":"timepicker",
         "collapse":false,
         "notice":false,
         "status":"Stable",
         "time_options":[
            "5m",
            "15m",
            "1h",
            "6h",
            "12h",
            "24h",
            "2d",
            "7d",
            "30d"
         ],
         "refresh_intervals":[
            "5s",
            "10s",
            "30s",
            "1m",
            "5m",
            "15m",
            "30m",
            "1h",
            "2h",
            "1d"
         ],
         "timefield":"posted_on_date",
         "enable":true,
         "now":false
      }
   ],
   "refresh":false
}```

@rashidkpc
Copy link
Contributor

You might try a build from today. I fixed an issue related to this here: #842 You may have gotten a build without the fix.

@DannyJoris
Copy link
Author

Thanks Rashid,

First I tried downloading from http://download.elasticsearch.org/kibana/kibana/kibana-latest.zip as stated in the readme.md file under Installation. That didn't work, but then I tried the github master download and that seems to have worked: https://github.com/elasticsearch/kibana/archive/master.zip .

Thanks again for your feedback!

@rashidkpc
Copy link
Contributor

ok, I'll go ahead and close this then, thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants
@DannyJoris @rashidkpc and others