Hi, I have follwoing models:

class Item extends DataObject {
    private static $db = array(
        'Title' => 'Varchar(255)'
    );

    private static $many_many = array(
        'Tags' => 'Tag'
    );
}

class Tag extends DataObject {
    private static $db = array(
        'Title' => 'Varchar(255)'
    );

    private static $belongs_many_many = array(
        'Items' => 'Item'
    );
}

How can I receive all Siblings of an Item by its Tags? Is this Possible in one Request, to make it paginatable?

An inelegant way would be to first get all Tag IDs of an Item's Tags and then get all Items by these Tag IDs excluding my Parent Firswt Item.

Kind regards

andre

Well I don't see another choice but to do the inelegant way...

$siblingItems = Item::get()
	->leftJoin('Item_Tag','Item_Tag.ItemID = Item.ID')
	->filter('Item_Tag.TagID',$myItem->Tags()->Column('ID'))
	->exclude('Item.ID',$myItem->ID);

(note untested, I might have the Item_Tag round the wrong way)