Search Criteria

[Hayley]

Hi everyone. I want to search the Owner_ID using report datapage, but the problem is I want to show both blank and filled data? How can I achieve it?

[PotatoMato]

Hi @Hayley, for you to achieve it, you will insert a criteria under the Owner_ID field, then setup an AND logic to show both blank and filled data. You can also refer to the attached screenshot.

 

You can also check this How-to article: https://howto.caspio.com/datapages/reports/creating-a-report-datapage/.

 

[telly]

Hi @Hayley,

You can simply select the field it will display the Criteria Group Settings  you can choose OR or AND:

 

[RuisiHansamu]

To know  more about the AND/OR logic, I suggest you check this documentation: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/ this helped me a lot when I was just starting to try this on my end.