Hello,
i tried to continue this using your example, but i could not add the documents to the index. It says there is no body, even if there clearly is. What am i doing wrong here?
My first post was a bit confusing because i was talking about two problems at once. The other one being visualisations breaking, because of fields that are not found because of no document containing the field. Which i was trying to solve by giving the mapping. But let's leave this out for now.
What i'm trying to understand now is how to create a lens showing some fields (including a date field that can be empty) of all documents, even if a document has an empty date field.
Sorry, i have to modify your example as i could not get it to work:
POST delete_date_missing/_bulk
{"index":{}}
{"persnr.keyword":"3014","bestaetigtes_datum_string":"-"}
{"index":{}}
{"persnr.keyword":"3021","bestaetigtes_datum":"10.11.2024 @ 00:00:00.000","bestaetigtes_datum_string":"10.11.2024"}
{"index":{}}
{"persnr.keyword":"3024","bestaetigtes_datum_string":"-"}
If i create the lens with persnr.keyword and bestaetigtes_datum_string it works as expected:
Two columns showing the content of the fields.
Now, if i add the date field, only the document containing this field is shown:
My expectation was: if i flip the switch "Include empty rows" that all three documents are shown again, similar to the "include documents without this field" switch for empty string fields. But as it turns out, this does not happen:
So this would be what i expected:
The discoverer is able to do it, but it seems like table lens is not:
Using a saved search is sadly no option, because as far as i know it is not possible to include a saved search in a dashboard without the ability to look at the whole document, because the expand document button at the start:
can not be removed. And the people who will work with the dashboard should not be able to see all fields of the documents.
Maybe this works as intended, but then i don't understand what this switch for empty rows is for. I assumed if i can include documents with empty string fields it should be possible for empty date fields as well.
Best regards
Jonas