I would like to do a date filter on a field called "last_update_date", however, if the value is "null", I should use another field called "creation_date". Is there any way to do this?
The filter for the "last_update_date" field is this:
Note, this is on top of my head and untested, but might be worth a try. A bool query, with only should clauses, treats those as an or, so I think this should work, if not, we can reiterate.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.