Search With OR operator

Classic Servoy
1

I have a form with critical contact info: first, last, phone, etc. Then there are 3 fields specialty1, specialty2, specialty3.

How can I build a search to find records that have a value in any one of the 3 specialty fields. I need an OR operator.

I would hope I don’t need to drop down to the getDatasetByQuery() level for this.

2

This is an option:

//Start a find request
controller.find();
specialty1 = globals.searched_value
controller.search();
controller.find();
specialty2 = globals.searched_value
controller.search(false,false); //to extend foundset
controller.find();
specialty3 = globals.searched_value
controller.search(false,false); //to extend foundset

Hope this helps

3

Another TIP: NEVER design your schema with field01, field02, field03. If you find you need this type of data - then make another table and put the data in there (make it relational).

It will allow you to have an unlimited number of specialties and will solve your search problem as well.

Cheers,

Bob Cusick