Search Using Both "and" And "or"

[ISlp59lp]

I'm using a search and report data page to show specific ball games.

 

User can select the sport to be "football" or "basketball".

User can select a game date.

User can select a school name.

 

My table of games lists sport, date, home school, and opposing school.  (The list of valid school names is the same for both home school and opposing school.)

 

In my search and report data page, the results are selected to be "Results that match all criteria (AND)".

 

How do I setup the search such that the user can insert one school name and the report will contain any games where the school name shows up in either the home school OR opposing school?

 

That is, I want my search to be 

     "sport" AND "date" AND (

          (schoolname = "home school" ) OR (schoolname = "opposing school")  )

[MayMusic]

Try to add criteria to the field which needs to have OR and see if that works in some cases it works

[MayMusic]

You can add criteria to the field by selecting it from the picker (exactly the same way you add an HTML Block http://howto.caspio.com/datapages/datapage-components/html-blocks/)and choose OR as the logical operator between the criteria, so user will be able to select two options to search for.

 

Or you can select listbox as form element and check to allow multi select and select OR.

[ISlp59lp]

This isn't quite what I need.

 

Think of a basketball game where there is a home team and an away team.

 

I want the user to input one team name.

Then I want the search to work so that it displays all games where (home team = team) OR (away team = team)

[MayMusic]

Combination of AND and OR is not a feature in Caspio yet It is not possible to do this kind of search

[ManokNaPula]

Hello there,

This feature is now possible in Caspio. I have the same logic with my app, I think it will be something like this one: https://prnt.sc/mbltu9

Also, you can check out this link for more information about Comparison Types in your Reports DataPage: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/

Have a great day