Can we remove the date column from our reports?

[mpjjonker (Michel Jonker)]

I have seen topics about removing the date (time) column from the discover tableview and I understand it is not that easy.
But maybe there is an easy way to prevent this column from being included in the CSV reports ?

[jsanz (Jorge Sanz)]

Not from the UI but if you copy the POST request from the CSV advanced options you can remove the date field from the columns key

My steps where:

• Copy that POST URL to a text editor
• Copy the jobParams parameter value into an HTML character decoder to easily detect the order_date (my date field) from the columns key and remove it.
  
  
• Encode again the string
• Put that back to a curl POST request and call that endpoint

curl -s -u "${ELASTIC_USER}:${ELASTIC_PASSWORD}" \
  -X POST -H 'kbn-xsrf: true' -H 'Content-Type: application/json' \
  "${KIBANA_HOST}/api/reporting/generate/csv_searchsource?jobParams=(browserTimezone%3AEurope%2FMadrid%2Ccolumns%3A!(products.product_name%2Cproducts.price%2Cproducts.manufacturer%2Ccustomer_full_name)%2CobjectType%3Asearch%2CsearchSource%3A(fields%3A!((field%3Aorder_date%2Cinclude_unmapped%3Atrue)%2C(field%3Aproducts.product_name%2Cinclude_unmapped%3Atrue)%2C(field%3Aproducts.price%2Cinclude_unmapped%3Atrue)%2C(field%3Aproducts.manufacturer%2Cinclude_unmapped%3Atrue)%2C(field%3Acustomer_full_name%2Cinclude_unmapped%3Atrue))%2Cfilter%3A!((meta%3A(field%3Aorder_date%2Cindex%3Aff959d40-b880-11e8-a6d9-e546fe2bba5f%2Cparams%3A())%2Cquery%3A(range%3A(order_date%3A(format%3Astrict_date_optional_time%2Cgte%3A%272023-09-07T00%3A04%3A19.000Z%27%2Clte%3A%272023-10-07T23%3A45%3A36.000Z%27)))))%2Cindex%3Aff959d40-b880-11e8-a6d9-e546fe2bba5f%2Cquery%3A(language%3Akuery%2Cquery%3A%27%27)%2Csort%3A!((order_date%3Adesc)))%2Ctitle%3A%27eCommerce%20data%27%2Cversion%3A%278.10.3%27)"

• Get the CSV from the Kibana Reporting UI and confirm the order_date was not included.
  
  

Hope it helps.