Search results- zero matches equals all records

So I’m curious why on a ‘Do Search For’ when a criteria isn’t met all records or rows are shown. That seems backwards to me.

Let’s say I have a search set up to show me all the rows of a specified data type where a field in that data type matches a field in another data type. If the field in the second data type is not blank everything works great. But if it’s blank I get everything. This doesn’t make sense to me because zero records in the first data type’s field has a value that is empty. To me I should get a result of zero rows.

Can anyone help me understand the reasoning behind this scenario?


1 Like

Ive found the opposite where searching for blank = all records is helpful. I guess it depends on person to person
. You can always condition the repeating group or action with a if field is empty then use a different data source or datasource = blank

So how is it helpful? If I want every record I won’t put in a condition. Yes I know how to ‘get around’ the issue but it takes more work and has to be planned for. But even if it’s helpful in certain scenarios it still seems illogical to me, which is why I’m asking to have the reasoning explained. So far no one seems willing. :neutral_face:

I ask the same question.

You should note thought that this happens only with associated conditions, (for example: only if this contains “Do search” first item), but if you say: only if Field A is yes, and there is no item with yes, it will return 0 items.

But i got a great workaround: always use the negative form: “is not” or the “<>” and use the cases it should not equal to.

This way, if no item equals that 2nd search, its ok, because those items you DID NOT want.

It’s helpful for me when adding a search bar
I can have the repeating group set to do a “search for” with the constraints “any field = search value”
If the “search value” is empty it will display all results if it is not it will display result that meet that value

If it didn’t act that way I would have to put conditions in the repeating group which I have found more laborious than adding an extra search condition when I don’t want it

There are a few other cases however it would be longoreous to explain and it’s skmilar to above