How can the corresponding field condition in SQL not be added to the retrieval when the parameter is not filled in?

I have read the part about Parameter in the document, but Have not found the corresponding solution.
Is there a better solution?

You can’t execute a parameterized query with no value selected

But there’s instructions for something very similar here:

oh。。。。。Okay, thanks for your help.