Searching facts

Classic Servoy
1

Hi all,

In my Servoy Solution, i want to search for some records.

In the Table There are name, age, department (fields).

I search for some records.

After that, I want to remove all the records from the current foundset which has name “A1”, “A2”, “A3”, “A4”.

Is there any technique to do the same?

Waiting for some valuable techniques?

Thanks & Regards,
Acer

2

Got one solution…

controller.find();
//Previous criteria
controller.search();

controller.find();
name = "!= A1";
controller.search( false, true);

controller.find();
name = "!= A2";
controller.search( false, true);

controller.find();
name = "!= A3";
controller.search( false, true);

controller.find();
name = "!= A4";
controller.search( false, true);

But, Is this the Optimal one?

If there are large number of records I want to remove for a same field, then? :?

Thanks & Regards,
Acer