foundset AND filter

Classic Servoy
1

Hello!

Is there any way to perform an AND filter with the same field on an foundset?

foundset.find()

foundset.myfield != 36
AND
foundset.myfield != my_var

foundset.search()

thanks

2 
if(foundset.find()) {
foundset.myfield != 36
foundset.newRecord()
foundset.myfield != my_var
foundset.search()
}
3

foundset.newRecord() is for OR filter https://wiki.servoy.com/display/public/ … LogicalAND

4

Try reduced search:

foundset.find()
foundset.myfield = '!'+36
foundset.search()
foundset.find()
foundset.myfield = '!'+my_var
foundset.search(false,true)
5

DEK4:
foundset.newRecord() is for OR filter https://wiki.servoy.com/display/public/ … LogicalAND

ah your right,
I always mix those two up.
I now see indeed, that you are trying it on the same field!

You could also write a simple query that does that and use it in the: foundset.loadRecords(vSQL, vArgs)

6

You could also have a look at the query builder.
You can take the existing foundset query and add some conditions like 'column not in (val1, val2)

See https://wiki.servoy.com/display/SERV61/Query+builder

Rob

7

rgansevles:
You could also have a look at the query builder.
You can take the existing foundset query and add some conditions like 'column not in (val1, val2)

See https://wiki.servoy.com/display/SERV61/Query+builder

Rob

Exactly: you can use querybuilder for complex find with “where” statement.

8

You could also do a search for the first condition and then for the second condition with the extend parameter on