As shown in the figure below, there are three query conditions. The first two are time intervals, and the last one is a fuzzy query based on name.
If the content written at the beginning is empty, then the data with the field value being null will be returned according to the where condition. So I added two if statements
I would like to ask if there is an easier way, thank you%