DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]rideearthtom[/eluser]
[quote author="TheJim" date="1271382257"]@rideearthtom

I'm not sure of the exact source of your first error (though I suspect it's #1 below), but there are three things to get out of the way before digging too deeply:
[/quote]

@TheJim

Thanks for your reply:

1. This was the first time I had found a need for subqueries. In particular, I needed an extra where() in the join_documents_locations_project query, which I could not find a way to replicate with joins (at least using DMZ - with raw SQL it would be pretty easy). Maybe there is functionality I'm unaware of.

2. This code does in fact work. DMZ's user guide contains examples in the same format - selecting a single column, then using it as a subquery. So there are no problems with that code.

3. I'd forgotten the grouping functions - thanks for pointing this out. where_not_related() does not exist! But I think you mean where_related('sme_profile', 'id !=', ...), which does work. We got there between us

Code:

private function has_documents_to_accept()
    {
//        $accepted_documents = new Document();
//        $accepted_documents->where_related('sme_profile', 'id', $this->sme_profile->id)
//            ->get();
//        $ids_1 = array();
//        foreach ($accepted_documents as $item)
//        {
//            $ids_1[] = $item->id;
//        }
//        $products_purchased = new Product();
//        $products_purchased->select('id')
//            ->where_related('purchase', 'sme_profile_id', $this->sme_profile->id);
        $join_projects_purchased = new Join_documents_locations_project();
        $join_projects_purchased->select('id')
            ->where_related('project/purchase', 'sme_profile_id', $this->sme_profile->id)
            ->where('location_id', $this->sme_profile->location_id);
        $documents = new Document();
        $documents->group_start()
//            ->where_related_subquery('product', 'id', $products_purchased)
            ->where_related('product/purchase', 'sme_profile_id', $this->sme_profile->id)
            ->or_where_related_subquery('join_documents_locations_project', 'project_id', $join_projects_purchased)
            ->group_end()
            ->where_related('sme_profile', 'id !=', $this->sme_profile->id);
//        if (count($ids_1) > 0)
//        {
//            $documents->where_not_in('id', $ids_1);
//        }
        return $documents->count() > 0 ? TRUE : FALSE;
    }

As far as I can see, the original problem I posted about where_not_in_related_subquery() not working properly still stands.