How to use NOT IN in $criteria as i m trying to get result which is not in other table in search: like
incidents and statements
so in incidents in am trying to search all the statments which are not in statements table. the reverse is true using inner join but this is Not working… I have used select for it but it is not working with other filters!!!