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`)
"
Filter Usage
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
2 posts
• Page 1 of 1
Filter Usage
by janokary » Mon Jun 18, 2007 9:55 am
- janokary
- Posts: 21
- Joined: Thu May 31, 2007 2:08 am
- Location: Greece
by mflorell » Tue Jun 19, 2007 6:15 am
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.
And you really should test it before running it during production hours so you don't have a database lockup.
- mflorell
- Site Admin
- Posts: 18384
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 60 guests