My data view in kibana has no fields

[Fatiha (Chaibi)]

HI I want to visualize my data from mysql to kibana
I create my file logstash.conf

input {
  jdbc {
    jdbc_driver_library => "E:/ELK/mysql-connector-java-8.0.17.jar"
    jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
    jdbc_connection_string => "jdbc:mysql://localhost:3306/mydata"
    jdbc_user => "root"
    jdbc_password => "admin"
    schedule => "* * * * *"
    statement => "SELECT * FROM analyse"
  }
   jdbc {
    jdbc_driver_library => "E:/ELK/mysql-connector-java-8.0.17.jar"
    jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
    jdbc_connection_string => "jdbc:mysql://localhost:3306/mydata"
    jdbc_user => "root"
    jdbc_password => "admin"
    schedule => "* * * * *"
    statement => "SELECT * FROM analyse_elementanalyse"
  }
output {
  elasticsearch {
    hosts => ["localhost:9200"]
    index => "index_analyse"
    document_id => "%{id}" 
    user => "elastic"
    password  => "qwVx8sqUc14XHG+HZF3I"
  }
   elasticsearch {
    hosts => ["localhost:9200"]
    index => "index_analyse_elementanalyse"
    document_id => "%{id}" 
    user => "elastic"
    password  => "qwVx8sqUc14XHG+HZF3I"
  } 

I create the data view in kibana but when want to create my charts I look the index is empty no fields

**Available fields**

0

There are no available fields that contain data.

**Try:**

* Extending the time range 

what is the probleme ?
i work in windows 10

[stephenb (Stephen Brown)]

Hi @Fatiha

Kibana - Dev Tools

run

GET _cat/indices?v

And share the results

[Fatiha (Chaibi)]

that what is i have :

yellow open   index_analyse                  38HisQH1RXawSMF-XI-rOw   1   1     168689           86     11.2mb         11.2mb
yellow open   index_resultatanalyse          I7Lj_FcTQDaGaVSjG5ijmg   1   1     168683          268     11.2mb         11.2mb

[stephenb (Stephen Brown)]

Ok good looks like you have data.

Most likely you are not looking in the correct time frame

If you go to Discover and set the Time Picker from 3 Months Ago to 3 Months from Now and take a look (or Years etc)...

Also simply do a Search and see what the @timestamps are?

GET index_analyse/_search

How did you set up the data view? Did you set a time field?