Relationships

When relationships are defined during the customization step, Forest Admin collections act as if the two collections were natively linked at the data source level.
You may have noticed that relationships within a data source are configured out of the box, so you won't need to define those.
However, you may want to create additional intra and cross-data source relationships to:
Help users navigate within your admin panel.
Create charts that use data from multiple data sources.
Let users filter, use scopes, or segment with conditions that cross data-source boundaries.
Minimal example
use ForestAdmin\AgentPHP\DatasourceCustomizer\CollectionCustomizer;
use ForestAdmin\SymfonyForestAdmin\Service\ForestAgent;
​
$forestAgent->customizeCollection(
    'Town',
    function (CollectionCustomizer $builder) {
        $builder
            // Towns belong to countries
            ->addManyToOneRelation(
                name: 'myCountry',
                foreignCollection: 'Country',
                foreignKey: 'country_id'
            )
​
            // Towns have one mayor
            ->addOneToOneRelation(
                name: 'myMayor',
                foreignCollection: 'Mayor',
                originKey: 'town_id'
            )
​
            // Towns have multiple inhabitants
            ->addOneToManyRelation(
                name: 'inhabitants',
                foreignCollection: 'Person',
                originKey: 'town_id'
            )
​
            // Towns electricity is supplied by power-plants which are shared with other towns.
            ->addManyToManyRelation(
                name: 'myPowerPlants',
                foreignCollection: 'PowerPlant',
                throughCollection: 'UtilityContract',
                originKey: 'town_id',
                foreignKey: 'powerplant_id'
            );
​
            ->addExternalRelation(
                'honoraryCitizen',
                [
                    'schema' => ['firstName' => 'String', 'lastName' => 'String'],
                    'listRecords' => function ($record) {
                        $client = new \GuzzleHttp\Client();
                        $response = $client->get('https://api.example.com/user/' . $record['id']);
                        return $response->getBody();
                    }
                ]
            )
    }
);
Write your own
To a single record
Last modified 18d ago