Page 1 of 1

Filter Usage

PostPosted: Mon Jun 18, 2007 9:55 am
by janokary
Hi is it posible to write subqueries in a filter?
for example can I write something like
"
sourceid not in (select distinct(`field`) from `db`.`table`)

"

PostPosted: Tue Jun 19, 2007 6:15 am
by mflorell
I would not recommend it if you have a large database(over 1 million leads)

And you really should test it before running it during production hours so you don't have a database lockup.