Fixed Search Form - can users omit some fields?

[aksmith]

Hello (again):
I have created a search form for a large botanical db with a few fields (many more to come):

For some reason, the first field (Family = scientific family - it's a dbjoin like the plant type) is a gatekeeper. If a user selects a scientific family, then they can cherry pick the other fields and return valid results.
If they omit that field, and fill all or any combination of the remaining fields, the search returns "No results".
Nothing else seems to distinguish the first field from the others (they're all unlinked copies of the list fields).
Any ideas?
Thanks!
-Alan

 

[aksmith]

Update:
I tried changing the order - without the scientific family it returns "No results".

 

[troester]

Enable 'allow fabrikDebug' in Options, append &fabrikdebug=1 to your jump URL and see which WHERE clauses you get.

Do you use "append jump url with data" or "use as search data"?

 

[troester]

Strange that you say PlantType is working.

Can you try to change in
plugins\fabrik_element\databasejoin\databasejoin.php line 3012 to
if (empty($data) || $data == '-1')

and in plugins\fabrik_form\redirect\redirect.php line 432 to
if (!$element->dataConsideredEmpty($v,0)) //if ($v != '')

 

[aksmith]

That seems to work!
I am appending jump url and "use as search data".
THANK YOU!