Manage blank fields with xPlore Query form in D2-Config
We have a Property page to allow users to search documents. The form contains 1 text field for fulltext search, 2 date fields, 1 dropdown field that lists document types.
In D2-Config, this property page is mapped to a Query form with xPlore query mode.
In the Criteria section in the query form, I have: sg_doc_type = $value(sg_doc_type)
All fields in the form are optional. That means if user doesn't set a value to the "Type" field, I want that it searches for all document types.
How to manage this case in the Criteria section ? because like it's configured, the query form searches documents that does not have a type (in my case, all documents have a type, so it returns me nothing...).
The problem is similar for date fields. If user doesn't set a date value, we want to ignore the criteria. But currently, the query form searches with empty date value.
Thanks for your helps.
Environment: D2 4.5, Content Server 7.2, xPlore 1.4, xPlore query mode is required.