Many-to-One Table Reference REFERENCE_TABLE

Opens a table popup for the user to select a related record. Corresponds to the JPA @ManyToOne relationship. Suitable when the referenced data is best displayed in a list format.

Basic Usage

@ManyToOne
@JoinColumn(name = "table_id")
@EruptField(
    views = {
        @View(title = "Sort", column = "sort"),
        @View(title = "Name", column = "name")
    },
    edit = @Edit(title = "Reference Table", type = EditType.REFERENCE_TABLE,
        referenceTableType = @ReferenceTableType(id = "id", label = "name")
    )
)
private Table table;

Referenced entity class:

@Entity
@Table(name = "t_table")
@Erupt(name = "Table")
public class Table extends BaseModel {

    @EruptField(views = @View(title = "Sort"), edit = @Edit(title = "Sort"))
    private Integer sort;

    @EruptField(views = @View(title = "Name"), edit = @Edit(title = "Name"))
    private String name;

}

Configuration

public @interface ReferenceTableType {

    String id() default "id";       // The field in the referenced table used for storage (primary key)

    String label() default "name";  // The field in the referenced table used for display

    String dependField() default ""; // The field name in the current table that this field depends on, used for cascading

    String dependColumn() default "id"; // The column in the dependency field used for matching

}

Example: Province-City-District Cascading

@ManyToOne
@JoinColumn(name = "province_id")
@EruptField(
    views = @View(title = "Province", column = "name"),
    edit = @Edit(title = "Province", type = EditType.REFERENCE_TABLE,
        referenceTableType = @ReferenceTableType(id = "id", label = "name"))
)
private Province province;

@ManyToOne
@JoinColumn(name = "city_id")
@EruptField(
    views = @View(title = "City", column = "name"),
    edit = @Edit(title = "City", type = EditType.REFERENCE_TABLE,
        referenceTableType = @ReferenceTableType(
            id = "id", label = "name",
            dependField = "province",
            dependColumn = "province.id"
        ))
)
private City city;

Contributors

YuePeng

Claude Opus 5 (1M context)

Changelog

Last edited 2 minutes ago

View full history

f3752b9-filter: add a role-based row-level data filtering example