Find one or multiple subj_nums

Classic Servoy
1

Hi all,

Using SQL select you can

select * from table_name where Subj_num in (1,3,5,78, 12)

I have the following find method that searches for one subj_num.
Is there a way to modify it so it can search for one or multiple subj_num
like the above SQL example:

controller.find();
if (globals.Field1_number)
{
subj_num = globals.Field1_number
}
var x = controller.search();
if (x ==0 )
{
	//Nothing was found
	var btn = globals.Error_MSG('No matches found for ' + globals.Field1_number, 'Cancel', 'Try Again' );
	if (btn == 'Try Again')
{
globals.Field1_number = null

//Search();
}
else 
{
controller.loadOmittedRecords();
}
}

Thanks for any help.

Abrahim

2

Couldn’t you simply do something like

controller.find();
subj_num = 1;
controller.newRecord();
subj_num = 3;
controller.newRecord();
subj_num = 5;
controller.newRecord();
subj_num = 78;
controller.newRecord();
subj_num = 12;
controller.search();
3

Patrick,

Your suggestion does what I was looking for!

Thanks,

Abrahim