Symptoms
I have created a K2 SmartForm that will have four search fields. This form has a list view from a SharePoint list using the SmartObject 'Get List Method'. The user will choose which of the 4 search fields they would like to fill the list view with. When they click the search button, a rule is fired to invoke the 'Get List Method' and map the data using the search fields.
The problem that I am having is that if any of the search fields are left empty the search results is zero rows returned. If you put a spaces in the fields instead of leaving them empty. The search results in rows being returned.
Diagnoses
The issue is surfacing because the customer is using a condition that is looking for values in the other searchboxes as well. This leads to the blank search because it cannot
Resolution
The best way to handle multiple search fields is with advanced conditions. Each of these advanced conditions will handle each search scenario.
For example:
Searchbox 1 filled, all other empty.
Searchbox 1 and 2 filled, 3 and 4 empty.
Searchbox 2 and 3 filled, 1 and 4 empty.
Searchbox 1, 2, 3 and 4 filled.
Then filter based on each search criteria.
