whereNotIn() must be of the type array about pixie HOT 9 CLOSED

Side Note: I'm aware I could use LEFT JOIN in combination with WHERE PCT.id IS NULL to accomplish the same result, however the ability to include the sub-queries can become useful in other situations...

from pixie.

Use

$query = $db->table('RPTC')
            ->select('orig_id')
            ->where($db->raw('`id` NOT IN (SELECT `id` FROM `PCT`)'));

from pixie.

@marc937 shouldn't subQuery() actually work?

from pixie.

Yes it should. This issue could be marked as enhancement.

from pixie.

For now please use Raw.

from pixie.

@usmanhalalit thanks, that's what I've been doing.

from pixie.

Have same problem

from pixie.

@TCB13 can you please update and check if the solution works?
I just merged #99

from pixie.

@usmanhalalit the issue seems to be fixed on whereIn() however the problem is still present on whereNotIn().

from pixie.