(Datamapper) One-to-Many Self Relationships [SOLVED]

[eluser]Empu[/eluser]
That was my mistake, does not read the manual carefully.

Now the databases structure to be like this,

Code:

`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`holding_id` int(5) unsigned DEFAULT NULL,
`name` varchar(255) NOT NULL

and the model & controller to be like this,

Code:

/* model */
class Organization extends DataMapper {

    var $table = 'organizations';
    var $has_one = array(
    'holding' => array(
        'class' => 'organization',
        'other_field' => 'organization'
    ));
    var $has_many = array(
    'organization' => array(
        'other_field' => 'holding'
    )
    );
// ...


/* controller */
$org = new Organization();
$org->include_related('holding', array('name'));
$list = $org->get();

As you say, it's work fine.

Thanks so much...