examples:builder:belongsto_relation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
examples:builder:belongsto_relation [2021/03/28 21:26]
pdsci-admin [Step 6: Add the related field to the parent table] 		examples:builder:belongsto_relation [2021/04/11 19:27] (current)
pdsci-admin [The belongsTo relation]
Line 9: Line 9:
   * Required: a //**parent** table// and a //**child** table//    * Required: a //**parent** table// and a //**child** table// 
   * Create a model for the child table with list and form   * Create a model for the child table with list and form
-  * Add a field named: //[childModelName]// **to the parent table**+  * Add a field named: //[childModelName]_id// **to the parent table**
   * Extend **the parent controller** with relation behaviour   * Extend **the parent controller** with relation behaviour
   * Extend **the parent model** with the desired relation definition (//hasOne//)   * Extend **the parent model** with the desired relation definition (//hasOne//)
Line 126: Line 126:
 \\ \\
 \\ \\
-===== Step : =====+===== Step 7: Add related fields to form and list ===== 
 +The final step is to add a field to the parent form view, where the related data can be selected and a column to the list view.\\ 
 +\\ 
 +For the form view and the //belongsTo// relation either a //Record finder// widget or a //Relation// widget (which appears as dropdown for a belongsTo relation) can be used. The Record finder gives a more convenient way to select a record, especially if the child table holds a lot of records. If there are only a few to expect in the child table the //Relation// widget is a good choice too.\\ 
 +\\ 
 +Anyhow, if the //Record finder// is the preferred choice, the most important thing to define ist the //List configuration// (see the property box at the right in the picture below). Here a reference to the list view of the child model is required. In the library this is //$/pds/library/models/agegroup/columns.yaml//.\\ 
 +If for some reason the definition of the child list view is not suitable for the //Record finder// - for example if there are too many columns defined that are not of essence for the selection of a related record - another list view can be defined in the child model. For example to hold only the columns needed. Let's call this additional view //columns_finder.yaml//. Then the reference has to be //$/pds/library/models/agegroup/columns_finder.yaml// 
 +\\ 
 +\\
 {{:examples:builder:belongsto-agegroup.19-modelcompletition3.jpg?direct&960|}} {{:examples:builder:belongsto-agegroup.19-modelcompletition3.jpg?direct&960|}}
 \\ \\
 \\ \\