menu-btn

Relation

Relation

Form Widget

relation - renders either a dropdown or checkbox list according to the field relation type. Singular relationships display a dropdown, multiple relationships display a checkbox list. The label used for displaying each relation is sourced by the nameFrom or select definition.

categories:
    label: Categories
    type: relation

The following field properties are supported and commonly used.

Property Description
label a name when displaying the form field to the user.
comment places a descriptive comment below the field.
nameFrom a model attribute name used for displaying the relation label. Default: name.
excludeFrom a parent model attribute used to exclude related keys in the list, optional.
select a custom SQL select statement to use for the name.
emptyOption text to display when there is no available selections.
conditions specifies a raw where query statement to apply to the model query.
scope applies a query scope method to the related form model, can be a model method name or a static PHP class method (Class::method).
defaultSort sets a default sorting column and direction, supports a string for the column name or an array with keys column and direction. The direction can be asc for ascending (default) or desc for descending order.
useController automatically detects if this field configured with Relation Controller behavior and use it. Default: true
controller specifies an array to manually configure integration with the Relation Controller behavior.

Use the nameFrom property to customize the label used for the related record.

categories:
    label: Categories
    type: relation
    nameFrom: title

Alternatively, you may populate the label using a custom select statement. Any valid SQL statement works here.

user:
    label: User
    type: relation
    select: concat(first_name, ' ', last_name)

# Applying Conditions

You can filter the available records using SQL or PHP conditions using the approaches below.

# SQL Query Condition

You may limit the related model using a raw SQL query using the conditions property.

user:
    label: User
    type: relation
    conditions: is_featured = true

The value also supports simple parameters parsed from the parent model attributes. The parameter names begin with a colon (:) character.

country:
    label: Country
    type: relation

state:
    label: State
    type: relation
    dependsOn: country
    conditions: custom_country_id = :country_id

# PHP Query Scopes

You can provide a model scope to use to filter the results with the scope property.

user:
    label: User
    type: relation
    scope: withTrashed

The scope can be used to connect two related fields, for example, connecting a Country and State model, where the available states are filtered by the selected country. The dependsOn property enables field dependencies and updates the state options when a country is selected.

country:
    label: Country
    type: relation

state:
    label: State
    type: relation
    dependsOn: country
    scope: filterStates

The scope value filterStates translates to the scopeFilterStates method defined in the State model. The $model (second argument) supplied to the model query scope lets you capture the selected country and filter the available options.

public function scopeFilterStates($query, $model)
{
    if ($countryId = $model->country_id) {
        $query->where('country_id', $countryId);
    }
}

# Relation Controller Integration

If the controller implements the Relation Controller behavior and the field is defined there, then it will be displayed using this definition. Set the useController property to false to disable this functionality.

countries:
    label: Categories
    type: relation
    useController: false

The controller property may be used to specify inline configuration.

products:
    label: Products
    tab: Products
    type: relation
    controller:
        label: Product
        list: $/october/test/models/product/columns.yaml
        form: $/october/test/models/product/fields.yaml

← Repeater →