Home

User Manual for Fabrik Master Detail example (Joomla 3.2 version)

1. SPILABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version Technical Product Issue 1 Document Status Draft JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page i JFA URM 03 User Manual for Fabrik SPI Laboratory Pty Ltd Master Detail example Joomla 3 2 version Table of Contents Table OF GONGEN svara il CGh nge MS ION see V Configuration Control sssi aaa V DOCUMENT HISTO NE OM a aN V REVISION HISION siio a V Management Authorisation sassannsnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnmnnn V Change Forecast arr V A gt SCOP aonn E sent 1 ET INFOAUCNON Jarre 1 TLZ PIPE 1 Med AUNENEG cireasa E 1 1 4 TOOIS ENVTONMENT ocsi n EEEa 2 15 ASSUMPIONS aisi canetacaieavsane caawinsesanespseteswanansaaiasaiaaieaeeaanes 2 1 6 About the SPI LAB wccciscccccsicccscesicccszesiccsexcececeansccedeszcacases2esceceezeceatsedccaateetceen 2 2 A design perspective of the master detail exercise 3 2 1 DESIGN OVE ION Lane 3 2 2 Entity relationship Model rnxraxrnnennnnnnennnnnnnnnnnnnnnnnnnunnnennnnnnnnnnnnnnnnennunnnen 4 23 SCMeeNn MOCKUDS airian ccc chs a ess di een en ea en cn eee ees 5 3 Create ne LISIS aars 11 ST Ve OVEVIEN Ledende 11 3 2 2 Activity Build the Master and Detail list rrrnnrnnnnnnnnnrnnennnrnnrnnennnnnn 11 39 NS 11 S AN REMATES nn 16 Page ii Issue 1 24 December 2013JFL URM 03 Fabrik Tuto
2. Classes List Alias olasses list Fabrik list Students List Alias students list Fabrik list Classes Form Alias classes form Fabrik form Students Form Alias students form Fabrik form JFA URM 03 yale Q BS Preview trial Ordering ascending Select Language Access Language Public All Figure 97 Students form menu item added Click the Preview Tab Top right corner Figure 98 Front end view The detail form view is presented as shown in the figure below JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Main Menu Home Classes List Students List Classes Form ty Form Login Form 2 Remember Me Create an account gt Forgot your username Forgot your password Page 69 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version trial Students Main Menu Home Classes List Students List Classes Form Students Students Form name Class Please select Login Form Please select Geography Maths 2 Remember Me Create an account gt Forgot your username Forgot your password Figure 99 The students form view 8 4 4 Remarks This completes this tutorial exercise Page 70 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc
3. Packages x date_time date time demo_classes date_time Classes Connections Schedule demo_classes label Classes Filter Plugin Select form Select Status Figure 59 Classes view with hidden columns Page 48 Issue 124 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 1 3 3 3 3 Hyperlink element to data from the master list view Access path Fabrik Elements Groups Select classes demo students RI System Users Menus Content Components Extensions elp trial Q Fabrik lists Joomla List Classes Classes Classes contain students Add 18 Group by name Vv Geography 3 Abe Elle Fred Smith Joe Doe Display 10 Figure 60 The elements classes demo students view Click on the name element as shown in the following figure m Users Menus Content Components Extensions Help tilge Fabrik elements Joomla Z Edit Publish Unpublish Show in list Remove from list Check In Trash Help Options Message 1 element checked in Home a 20 xl Lists Forms Show Groups Full Element Name Group Plugin in List Published Sea demo students id Classes internalid v Visualizations demo students Packages date time date time demo students date time Classes Connecti
4. SPI LABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version 4 3 4 3 4 List Setting Select the List View Setting sidebar Tab a Show in List Select the Yes option Fabrik edit element v a Ll Save as Copy Close Details List view settings Publishing Access l List settings Icons 5 Calculations List view settings Validations Show in list JavaScript Link to details Allow ordering Heading label Custom link Custom link in details Use as row class Include in list query Figure 15 List settings selections Then click Save and Close Users Menus Content Components Extensions Help Fabrik elements Z Edit D Copy Publish Unpublish v Show in list Remove fromiist Y Check in Message Item successfully saved Home Lists Forms Groups ID lt Full Element Name Group Elements 2 Elements 1 demo_classes id Classes Visualizations Packages date_time date time demo_classes date_time Classes Connections Schedule demo_classes label Classes Filter Plugin Figure 16 Elements view label added JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Trash Plugin internalid JFA URM 03 tialg Joomla trial amp o Joomla p Options 20 Show in List Published v v Page 21 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LT
5. Content Components Extensions Help tilg Fabrik elements Joomla Fi Edit Oi Copy Publish Unpublish v Show inlist Remove fromiist V Check In Trash Help Options Home Filte 20 Lists z Forms Show Groups Full Element Name Group Plugin in List Published Elements demo_classes id Classes internalid S4 Visualizations Packages demo students id Students internalid Connections Schedule date time date time demo classes date time Classes Filter date time date time demo students date time Students Plugin Select form Figure 11 Select Forms gt Classes We want to filter to view to restrict the display to elements associated with the classes list This can be achieved by selecting either classes from either the Forms or the Group dropdown menu s The following view will be displayed RI System Users Menus Content Components Extensions Help trial Q Fabrik elements Joomla Z Edit O Copy v Publish Unpublish Show inlist Remove fromlist V Check In Trash Help Options Home TEY 20 Lists d Forms Show Groups ID Full Element Name Plugin in List Published 1 demo classes id sses internalid v v Visualizations Packages Connections E Schedule date_time date time demo_classes date_time Select group Figure 12 Elements filtered by Form selection Now
6. Filter Select Status Select form OM Name Classes Classes demo students Students Label Classes demo students Students Form 4 Classes 4 Classes 4 Students Figure 33 Click on Groups Click on the Lists Tab and click on View Data Fabrik lists Menus Users Content Components Publish Unpublish Home Forms Groups Elements Visualizations Packages Connections Schedule Filter Select Status List name Db table demo_classes Students demo_students The following view will be displayed Page 34 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc Extensions Help 4 Import Trash Element Add Add Form View data i EV data 23 View data 4 Edit 4 Edit Figure 34 Select Lists Tab click on View Data talg Q Joomla Help 9 Options 20 fi Elements Published Add tiale Q Joomla Help Options 20 Published View details v View details v View details SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version Users Content Components Extensions Help trial Q Fabrik lists Joomla List Classes Classes Classes contain students Add 13 Group by V TI Empty id date time id date time 2013 12 10 Geography 2013 12 10 Fred Smith Geograp
7. fo 2013 12 10 ra This series of tasks completes the addition of individual rows of data to each list The next step is to join the master list to the detail list i e the classes Page 30 list to the students list h A ba Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version 6 Join the Master and Detail Lists Access path Fabrik Lists Select Classes 6 1 1 Overview JFA URM 03 This function provides the means for joining two lists in this instance a parent list 1 e master list to a child list i e the detail list 6 2 2 Activity Join the Master and Detail lists The activity focuses upon joining the master and detail lists 6 3 3 Tasks 6 3 1 3 1 Select the Lists function Click on the Lists Tab The following view will appear BX System Users Menus Content Components Extensions Help Fabrik lists i Edit H Copy Publish Unpublish Import D Trash Home Filte a xX Forms MF Listname Db table Element Form View data Groups F demo classes Add Edit 12 View data Elements Visualizations F sue Eea demo students Add Edit 12 View data Packages Connections Schedule Filter Select Status x Figure 29 Select the Classes list 6 3 2 3 2 Click on Classes After clicking on the classe
8. 5 3 3 Tasks 5 3 1 3 1 Select the Lists function Click on the Lists Tab The following view will appear BX System Users Menus Content Components Extensions Help trials Q Fabrik lists Joomla Z Edit DyCopy v Publish Unpublish t Import Trash Help Options Home Forms FE List name Db table Element Form View data Published View details Groups Q X 20 Classes demo classes Add Edit 12 View data v View details Elements Visualizations F Students demo students Add Edit View data v View details Packages Connections Schedule Filter Select Status gt Figure 22 The Lists view 5 3 2 3 2 Click on View data for the classes List After clicking on View data for the classes list the figure below will be viewed Page 26 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version Ry System Users Menus Content Components Extensions Help trial 4 ov Fabrik lists Joomla List Classes Classes Classes contain students er Groupby amp CSV Empty id date time No records Display 10 Figure 23 The list view select Add Click on Add 9 3 3 3 3 Classes List Add data content For the label field enter the value Geography Click Save Ry System Users M
9. Alias casses list ir Public Fabrik list Students List Alias students list vr Public Fabrik list Figure 88 Create a new menu link Under Select Item Type the initial view will list only the top level items Click on Fabrik and the second tier items will be listed Click on List Page 64 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version System Links Tags Users Manager Weblinks Wrapper Details STANDARD Fabrik detsils layout Farm STA L STANDARD Fabrik form layout Package STANDARD Fabrik package layc Visualization visualizatic CSVCSVE Figure 89 Select Fabrik gt Form a Details Menu Title Enter Classes Form b Required settings Form Select Classes talg Menu Manager New Menu Item Joomla v a ae Save amp New Cancel Menu Title Classes Form Details Fabrik Form Options Link Type Page Display Metadata Module Assignment Menu Item Type Form im Select Menu Location Main Menu Fabrik Form Classes x v Parent Item Link index php option com fabrik amp vie Menu Item Root Target Window Parent Ordering Ordering will be available after saving Template Style Use Default Status Published Default Page Access Public Figure 90 Configure the classes form menu item Click the Save Tab The v
10. JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version Ei System Users Menus Content Components Extensions Help Fabrik elements Z Edit Lx Copy v Publish Unpublish Show in list Remove from list v Check In Trash Message Item successfully saved Full Element Name Group demo students id Students Visualizations Packages 2 date time demo students date time Connections Schedule demo students name Students Filter demo students class id JFA URM 03 Help Q Options 20 r Show in Plugin List Published internalid databasejoin Figure 21 Elements added to the students list 4 4 4 Remarks This series of tasks completes the creation of the new elements associated with the classes and students lists The next step is to add some data to each list JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 25 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version 5 Add Data to Lists Access path Fabrik Lists View Data 5 1 1 Overview This function provides the means for adding data to lists 5 2 2 Activity Add data to the Master and Detail lists The activity focuses upon adding data to the master and detail lists Data will be added first to the classes list Data will then be added to the students list
11. Joomla 3 2 version 4 Add Elements to Lists Access path Fabrik Elements New 4 1 1 Overview This function provides the means for adding elements to lists 4 2 2 Activity Add elements to the Master and Detail lists The activity focuses upon creating elements that will be added to the master and detail lists Elements will be added first to the classes list Elements will then be added to the students list 4 3 3 Tasks 4 3 1 3 1 Select the Elements function Click on the Elements Tab The following view will appear BX System Users Menus Content Components Extensions Help talg Fabrik elements Joomla Z Edit 1 Copy Publish amp Unpublish Show in list Remove from list vW Check In Trash Help Options Home 20 Lists Groups lt Full Element Name Group Plugin in List Published i demo_classes id Classes internalid v Visualizations Packages EIET EERIE demo students id Students internalid wae ECUUITS Schedule date_time date time demo classes date time Classes date time date time demo students date time Students Select group Figure 10 The Elements view Page 18 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 4 3 2 3 2 Select the classes view on the Form menu Bi System Users Menus
12. doclssue 1 24 December 2013 Page 59 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version trial Classes Main Menu Home Classes contain students Classes List SER Add t Group by name Login Form Y Geography 4 t o Abe Elle M Remember Me eee 4 Create an account gt oe Doe Joe Do Forgot your username Forgot your password ROD w Maths 1 Anne Other Display 10 e Home classes list form 1 1 Figure 79 The master detail view Click on a student name The detail view will be presented as in the figure below trial Classes Main Menu Home Classes demo_students Figure 80 The detail view 8 3 2 3 2 Display the students list Access path Joomla Menu Item Manager Select New Page 60 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version System Users Menus Content Components Extensions Help tiala Menu Manager Menu Items Joomlal e i Edit Publish Unpublish lv Check In Trash r Home Rebuild m Batch Message Menu item successfully saved Menus Main Menu Search Search tools Clear Menu Items Ordering ascending Select Status v Select Max Levels Select Access Select Language v Status Title Home Access Language ID v Home Alias
13. home Public All 101 Articles Featured Articles Classes List Alias classes list sv Public Fabrik list Figure 81 Create a new menu link for the students list Under Select Item Type the initial view will list only the top level items Click on Fabrik and the second tier items will be listed Click on List Tags Users Manager Weblinks Wrapper Details STANDARD Fa Form STANDARD F pad STANDARD Fabrik list layout ae Visualization Visualizat csv CSV Expori Figure 82 Select Fabrik gt List JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 61 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Menu Manager New Menu Item v Save amp Close Save amp New Cancel Menu Title Students List Details Fabrik List Options Link Type Page Display Metadata Module Assignment Menu Item Type List Main Menu Fabrik List Students v Parent ltem Link index php option com_fabrik amp view Menu Item Root Target Window Parent Ordering Menu Location tilg Q Joomlal Ordering will be available after saving Template Style Use Default Status Published Default Page No Figure 83 Configure the student list details a Menu item details Title Enter Student list b Parameters Basic List Select students Click the Save Tab The view is refreshed as in the figure
14. trial Z Q z Menu Manager Menu Items Joomla med a Z Edit Publish Unpublish IW Check In Trash Home Rebuild m Batch Menus Main Menu x Sea Search tools Clear Menu Items Ordering ascending Select Status v Select Max Levels X Select Access p Select Language v E Status Title Home Access Language ID A v Home Alias home z Public All 101 Articles Featured Articles Figure 74 Create a new menu link Under Details Select Item Type Click Select Under Fabrik click on List JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 57 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Tags Users Manager Weblinks Wrapper Details STANDARD Fab Form STANDARD Fabrik fo List STANDARD Fabrix list la Packd STANDARD Fabrik list layout Visualization visualizatic CSV CS xport Figure 75 Select Fabrik gt List ked tialg z Menu Manager New Menu Item Joomla vY Save amp flose Save amp New Cancel Menu Tite Classes List Details Fabrik List Options Link Type Page Display Metadata Module Assignment Menu Item Type List ig Select Menu Location Main Menu Fabrik List Parent Item Link index php option com fabrik amp vie Menu Item Root Target Window Parent Ordering Ordering will be available after saving Template Style Use Default Status Published Defau
15. 0 Fred Smith Joe Doe Geography Geography Geography Display 10 Figure 52 Master detail view re ordered 7 3 2 3 2 Removing redundant data from the master list view rows Access path Fabrik Elements Groups Select classes demo_ students B System Users Menus Fabrik elements Content Copy Publish Components Unpublish Extensions Help Show in list Remove from list Home Lists Forms Groups Elements Visualizations Packages Connections date_time date time Full Element Name demo students id demo students date time V Check In Group Classes demo students Classes demo students Trash Plugin internalid tilg Joomla Help Options 20 x Show in List Published v Schedule Classes demo_students demo_students name Filter class id demo students class id databasejoin Plugin demo students Select form Select group Classes Classes demo students Students Figure 53 The elements classes demo students view Select the columns to be hidden as shown in the figure below JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 45 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Users Menus Content Components Extensions Help tr
16. 12 10 Display 10 vi Home Fred Smith Joe Doe Abe Elle Rob Anne Other Figure 86 The student list view Geography Geography Geography Geography Maths 2 Gi Remember Me Create an account gt Forgot your username Forgot your password Click on Add The detail view will be presented as in the figure below JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 63 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version trial Students Main Menu Home Classes List Students List Students Login Form Class 2 User Name Please select Geography Maths Remember Me Create an account gt Forgot your username Forgot your password Figure 87 The student list detail view 8 3 3 3 3 Display the classes form Access path Joomla Menu Item Manager Select New System Users Menus Content Components Extensions Help trial oO Menu Manager Menu Items Joomla a Edit Publish Unpublish vV Check In Trash r Home Rebuild a Batch Message Menu item successfully saved Menus Main Menu earch Search tools Clear Menu Items Ordering ascending Select Status v Select Max Levels X Select Access v Select Language v Status Title Access Language ID v Home Alias home Public All 101 Articles Festured Articles Classes List
17. D Master Detail example Joomla 3 2 version 4 3 5 3 5 Add elements for the students list In the Form dropdown select students The elements for the students view will be displayed Users Menus Content Components Extensions Help trial Q Fabrik elements Joomla Z Edit Oy Copy Publish Unpublish Show in list Remove from list V Check In Trash Help Options Home 20 Lists Groups lt Full Element Name Group Plugin in List Published Elements demo students id Students internalid v v Visualizations Packages date_time date time demo students date time Students Connections Schedule Select form Classes Figure 17 Elements initially associated with students 4 3 6 3 6 Add elements to the students list a Add the name element b List view settings Show in List Set the option to Yes Click Save and Close Page 22 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version trial amp Fabrik new element Joomla Placeholder Input type Max length Disable element Read onty Auto complete Speech recognition Figure 18 Add the name element and Save b Details Name Enter class_id element c Details Label Enter Class d Details Element type select database join e Option
18. Data to The created tables now have some data 16 4 rows Tables added to them Join Master steps are now taken to join the tables so that the and Detail master detail relationship is created Tables Configure The presentation of the data in the master detail Master Detail views 1S now configured display Display The master detail view 1s now configured to be Master Detail visible on the frontend view on Frontend 2 2 Entity relationship Model 2 2 1 Master Detail the classes id is linked to the students dass id column s 2 2 2 Summary Name Documentation Page 4 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version Name Documentation OG master Table This table holds the various class values Geography Maths etc l Detail Table This table holds the values that define the students 7 e g Fred Smith Anne Other 2 3 Screen mockups 2 3 1 Backend Classes View Backend Master View This view shows the elements of the detail table linked to the master table Geography Abel Elle Fred Smith Joe Doe Maths Display Numbe 5 10 JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 5 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version 2 3 2 Backend Studen
19. Detail example Joomla 3 2 version trial Classes Main Menu Home Classes List Students List Classes Form Classes Login Form demo students ri F Remember Me Create an account gt Forgot your username Forgot your password Figure 93 The classes form view 8 3 4 3 4 Display the students form Access path Joomla Menu Item Manager Select New Users Menus Content Components Extensions Help trial amp oO Menu Manager Menu Items Joomla Phew Z Edit Publish Unpublish V Check In G Trash r Home Rebuild m Batch Message Menu item successfully saved Menus Main Menu Searci Search tools Clear Menu Items Ordering ascending Select Status v Select Max Levels Select Access 7 Select Language p F Status Title Acces Language ID v Home Alias home Public All 101 Articles Featured Articles Classes List Alias classes list vr Public Fabrik list Students List Alias students list vr Public Fabrik list Classes Form Alias classes form vr Public Fabrik form Figure 94 Create a new menu link Under Select Item Type the initial view will list only the top level items Click on Fabrik and the second tier items will be listed Click on List JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 67 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example
20. I LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 7 Managing the Master and Detail lists display 7 1 1 Overview Various methods are described for managing the display of the joined master detail lists 12 2 Activity Configuring the Master and Detail features The activity focuses upon the methods for managing the master and detail list displays 7 3 3 Tasks 7 3 1 3 1 Ordering rows in the master list view Access path Fabrik Lists Classes Select View Data by System Users Menus Content Components Extensions Help trial Q Fabrik lists Joomla Message Record added updated Classes Classes contain students add 18 Group by date time 2013 12 10 2013 12 10 2013 12 10 label Geography Geography Geography date time 2013 12 10 2013 12 10 2013 12 10 name Fred Smith Joe Doe Abe Elle Class Geography Geography Geography Display 10 Figure 50 The composite master detail view There is a lot of duplicated data in this list view We will apply grouping to the classes list Grouping is often used in conjunction with joins it splits the list into groups of lists grouped by a given value Here we will group by each class Access path Fabrik Lists Select Classes Select Data Tab JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 Decembe
21. JFA URM 03 User Manual for Fabrik SPI Laboratory Pty Ltd Master Detail example Joomla 3 2 version Page iv Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI Laboratory Pty Ltd User Manual for Fabrik JFA URM 03 Master Detail example Joomla 3 2 version Change History Configuration Control Project SPI LABORATORY PTY LTD Title User Manual for Fabrik Master Detail example Joomla 3 2 version Doc Reference D SPI LAB PROJECTS JFA DOCUMENTATIONOBJECTS JM 32 JFL URM 03 FABRIK TUTORIAL MASTER DETAIL JM 32 DOC Created by Alastair Walker Creation Date 10 December 2013 Document History ae oae Sms wo swaai Revision History issue Dee Grans O 2013 12 10 New document created Management Authorisation Issue Date Status Management Board Minute Reference Change Forecast JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page v SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 1 1 1 2 1 3 Detail example Joomla 3 2 version Scope Introduction Master details entity relationships are very common in information rich client server database systems In accounting systems this relationship is seen in the client invoice relationship In this tutorial the master detail relationship context is that of classes that are attended by students Student may attend any numbe
22. Joomla 3 2 version System Links Tags Users Manager Weblinks LS STANDARD Fabrik form layout Package STANDARD Fs Visualization Visuslizstic CSVCSVE Figure 95 Select Fabrik gt Form a Details Menu Title Enter Students List b Required Settings List Select students s Menu Manager New Menu Item Joomla vV Save amp ey Save amp New Cancel Menu Title Students Form Details Fabrik Form Options Link Type Page Display Metadata Module Assignment Menu Item Type Form im Select Menu Location Main Menu Fabrik Form Students Parent Item Link index php option com fabrik amp vie Menu Item Root Target Window Parent Ordering Ordering will be available after saving Template Style Use Default Status Published Default Page Figure 96 Configure the students form menu item Click the Save Tab The view is refreshed as in the figure below Page 68 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version System Users Menus Content Components Extensions Help Menu Manager Menu Items Message Menu item successfully saved Unpublish v Check In Trash Home Rebuild a Batch Main Menu Q Search tools Select Status X Select Max Levels X Select Access Title Home Alias home Articles Featured Articles
23. Menus Content Components Extensions Help trial Q Fabrik lists Joomla Z Edit Oy Copy Publish Unpublish 4 Import Trash Help Options Home ajx Jo Forms List name Db table Element Form View data Published View details Groups x CigRses demo_classes Add Z Edit View data v View details Elements Visualizations Stu 3 demo students Add Z Edit View data F View details Packages Connections Schedule Filter Select Status Figure 71 Select the classes list Click on List name classes Scroll down the page and find the Layout group box Page 54 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version K tialg Fabrik edit list Joomla v Sei jy LM Save as Copy Close Text Filters Navigation Layout Links Notes Advanced Data Templates PDF Publishing Plug ins Front end template bootstrap PDF icon Use Global Admin template PDF template Use Default Show title No Yes PDF Orientation Portrait PDF Paper size a4 Bootstrap list classes Tabs Striped Yes Tab field Bordered z Maximum Tabs displayed include an All tab Condensed Figure 72 Update the Layout configuration settings In the Layout Tab change the following settings a Template Change from default to bootstrap b Admin template Change from de
24. TD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version Menus Content Components Extensions Help trial List Classes Classes Classes contain students OG 2 Group by name v Geography 4 Abe Elle Fred Smith Joe Doe Display 10 Figure 68 Add new row to classes list Click on Add A new row will be added to the classes list and a new row will also be added to the students list Rg System Users Menus Content Components Extensions Help trial amp Q Fabrik forms Joomla Classes Classes demo_students Anne Other Figure 69 New row and details added JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 53 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Bg System Users Menus Content Components Extensions Help trial Q Classes Classes contain students Add S Groupby amp CSV Empty name VY Geography 4 Abe Elle Fred Smith Joe Doe Rob vw Maths 1 Anne Other Display 10 Figure 70 Refreshed master detail display 7 3 4 3 4 Changing the template for the master list view With reference to Figure 70 the columns do not line up We need to select a more appropriate template Access path Fabrik Lists List name classes See the figure below Users
25. Text Filters Navigation Layout Links Notes Advanced Data ID Publishing i Label Classes Plug ins Access Introduction Edit Insert Viewv Format Table v Tools v Paragraph v amp Classes contain students Figure 2 Enter Details and Publish Under Details enter the Label i e Classes under Introduction enter Classes contain students Under Publishing Tab select Yes for Published Click Save 3 3 3 3 3 Set the Access details Select the Access Tab talg Q Fabrik edit list Joomlal v Save amp lose Save amp New Save as Copy Close Access Details Data View list Public Publishing Plug ins 3 te View records Public Edit records Public or use field Add records Public Delete records Guest or ere Sek Super Users Registered Empty records Special Figure 3 Set the Access details Change the default setting of Delete Records from Registered to Public Page 12 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version 3 3 4 3 4 Set the Data details Select the Data Tab pI sm Fabrik new list v th amp Close OG Save amp New Cancel Data Group by Pre filter Joins Related data Details Data Connection site database Data Publishing Table name demo classes Plug ins Access Or Database tabl
26. Users Menus Content Components Extensions Help tilg Q Fabrik forms Joomla Classes Classes label Geography demo_students Fred Smith Joe Doe Figure 47 Add new detail record A new row will be added Add a new name to the row Content Components Extensions Help trialg Fabrik forms Joomla Classes Classes label Geography demo_students Fred Smith Joe Doe Figure 48 New row added to detail list Click Save JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 41 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version ps System Users Menus Content Components Extensions Help trial o Fabrik lists Joomla Message Record added updated List Classes Classes Classes contain students OAdd 5 Group by id date time i date time 2013 12 10 Geography 2013 12 10 Fred Smith Geography 2013 12 10 Geography 2 2013 12 10 Joe Doe Geography 2013 12 10 Geography 3 2013 12 10 Abe Elle Geography Display 10 oS Figure 49 The composite master detail view 6 4 4 Remarks This series of tasks completes the addition of individual rows of data to each list The next step is to join the master list to the detail list 1 e the classes list to the students list Page 42 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SP
27. ail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version ky system Users Menus Content Components Extensions Help tiala Or Fabrik forms Joomla Students Students Fred Smith Please select Geography pa Figure 27 Add data values to fields In the Name field type in Fred Smith From the Class dropdown selection select Geography Click Save The following view will be displayed JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 29 JFA URM 03 User Manual for Fabrik Master Detail example Joomla 3 2 version 5 trial Mozilla Firefox File Edit View History Bookmarks Tools Help F trial l RI T e amp localhost administrator index php option com_fabrik amp task list view amp listid 2 System Users Menus Content Components Extensions Help Fabrik lists Message Record added updated List Students Students belong in classes Add Groupby M amp csv Empty date time 2013 12 10 Fred Smith Geography Display 10 ly E View Site ED Jisitors p Admin Log out OCA e BAG E s a lat d opioa D ra Ey a Figure 28 Row added to Students List 5 4 4 Remarks ee ag Fn IE Serve SPI LABORATORY PTY LTD Pt O trial a Joomla Students 13 24 a me A I8 ae Tuesday
28. asses Filter Plugin Students Figure 57 Elements associated with the classes list JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 47 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Select the elements to be hidden Users Menus Content Components Extensions elp trial Q Fabrik elements Joomla Oy Copy v Publish Show in list Remove from list Trash Help Options Home Lists Forms 20 Show Groups Full Element Name Group Plugin in List Published Elements demo classes id Classes internalid sA St Visualizations Packages date time date time demo classes date time Classes v Connections ht Schedule demo classes label Classes v Filter Plugin Select form Select Status Figure 58 Select elements from the classes list for hiding Then click on the Remove from list view Tab Access path Fabrik Lists Select Classes Select View data Note the removed elements System Users Menus Content Components Extensions Help trial o Fabrik elements Joomla Z Edit O Copy Publish Unpublish Show in list Remove from list V Check In Trash Help Options Home die 20 Lists SES EAE Groups Full Element Name Group Plugin in List Published demo_classes id Classes internalid Visualizations
29. below System Users Menus Content Components Extensions Help Menu Manager Menu Items Z Edit Publish Unpublish V Check In Trash r Home Rebuild E Batch Message Menu item successfully saved Monna Main Menu Search o ewe cea Menu Items E steam Ordering ascending Select Status v Select Max Levels v Select Access v Select Language v F Status Title Access EF v Home Alias home Public Articles Featured Articles F Classes List Alias classes list vr Public Fabrik list Students List Alias students list vr Public Fabrik list Figure 84 Student list menu item added Click the Preview Tab Top right corner yal amp Q l Preview trial Language ID All 101 Page 62 Issue 124 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version Main Menu Home Classes List ee List Login Form 2 a Remember Me Create an account gt Forgot your username Forgot your password Figure 85 Front end view Click on the Student List The student list view is presented as shown in the figure below trial Students Main Menu Home Students belong in classes Classes List Students List qi i Group by date time Login Form 2013 12 10 2013 12 10 2013 12 10 2013 12 10 2013
30. ber 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version a Join type left join b From demo classes c To demo students d From column 1d 1 e this is the primary key in the classes list e To column From the dropdown list select the class 1d item Fabrik edit list E v Save amp Close Save amp New L Save as Copy Close Message item successfully saved Group by Pre filter Related data Details Data Publishing Plug ins Access Join type From To From column To column LEA vr demo cll demo sj l id class idl Display mode Each row separately Delete joined data Figure 32 Capture the join details Click Save and Close 6 3 5 3 5 New defined group classes demo students JFA URM 03 tale Q Joomla Repeatable Click on the Groups Tab The following view will be displayed A new group has been created 1 e classes demo students JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 33 JFA URM 03 User Manual for Fabrik Master Detail example Joomla 3 2 version SPILABORATORY PTY LTD BX System Users Fabrik groups Menus Content Components v Publish Unpublish Extensions V Check In Help Trash Elements Visualizations Packages Connections Schedule
31. cus on evaluating the quality of the delivered product It is in the nature of our work that we spend a great deal of time on product evaluation activities This body of work i e the creation of the reference manual was undertaken as part of a detailed CMS content building technology evaluation exercise Page 2 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 2 A design perspective of the master detail exercise 2 1 Design overview 2 1 1 Use cases create the tables add elements add data join the tables User Lonfiqure display display on frontend 2 1 2 Use case summary Name Documentation Boe E M This tutorial presents an overview of the key steps aster to creating tables that have a master detail relationship Detail Overview JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 3 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Documentation D gt This exercise creates the master details tables Create Tables In this exercise the master table is referred to as classes and the detail table is referred to as students GB Add This exercise adds elements to the haster and detail tables Elements are synonymous with table columns Elements to Tables Add
32. d Detail View Form Frontend Detail View Form Students Students Field Page 10 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master Detail example Joomla 3 2 version 3 Create the Lists Access path Fabrik Lists gt New 3 1 1 Overview JFA URM 03 This function provides the means for creating a new list which will be called the Classes list 3 2 2 Activity Build the Master and Detail list The activity focuses upon creating the master and detail lists The master list is called classes The detail list is called students 3 3 3 Tasks 3 3 1 3 1 Create the master list Users Menus Content Components Extensions Fabrik lists ee Z Edit Ll Copy Publish Unpublish 4 Import Trash Home Ada Forms ID H Listname Db table Element View data Groups Elements Visualizations Packages Connections Schedule Filter Select Status Figure 1 Create a new list JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 talg Joomla Help Options 20 x Published View details Page 11 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version 2 3 2 Capture items under Details and Publish tilg Or eg Fabrik new list Joomlal ma v Save amp Close Save amp New Cancel
33. dents Plug ins Access Or Database table Primary key Auto increment Order by Figure 8 Assign Data details SPI LABORATORY PTY LTD In the Create New List field enter demo students as the list name Then click Save and Close The following display will then appear BX System Users v Menus Content Components Extensions Fabrik lists 4 Edit Copy Publish Unpublish Import Help OD Trash Message ltem successfully saved Home Filter a x KJE Forms F List name Db table Element Groups Classes demo classes Add Elements SP Visualizations F Students demo students Add Packages Connections Schedule Filter Select Status Figure 9 The created lists 3 4 4 Remarks This series of tasks completes the creation of the lists Form 4 Edit 4 Edit View data View data View data tilg Q Joomla tialg Q Joomlial Help Options 20 Published View details v View details v View details Page 16 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version The next step is to add some elements to each list JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 17 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example
34. e Primary key Auto increment Order by Available once saved Figure 4 Assign Data details In the Create New List field enter demo classes as the list name Then click Save and Close 3 3 5 3 5 Create the detail list Access path Fabrik Lists gt New JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 JFA URM 03 talg Joomla Page 13 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version BX System Users Menus v Content Components Extensions Help talg v Fabrik lists Joomlal Se 4 Edit Copy Publish Unpublish 4 Import T Trash Help Options Message Item successfully saved Home Filter oe 20 alx Forms ID HM Listname Db table Element Form View data Published View details Groups 1 F Classes demo classes Add 4 Edit 1 View data v View details Elements Visualizations Packages Connections Schedule Filter Select Status Figure 5 Create a new list trile Q 3 3 6 3 6 Capture items under Details and Publish By Fabrik new list Joomlal o v save8 cose MEE o cance Warning Select a database table or enter a new database table name Text Filters Navigation Layout Links Notes Advanced Data ID Publishing l Label Students Plug ins Access Introduction Edit Insert View Format v Table v Tools v Bragd S Paragrap
35. enus Content Components Extensions Help tiala Q Fabrik forms Joomla Classes Classes Geography Figure 24 Add data content to a row in the Classes List 5 3 4 3 4 Students List Add data content Select the Lists Tab JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 27 User Manual for Fabrik Master Detail example Joomla 3 2 version JFA URM 03 BX System Users Menus Content Components Extensions Help Fabrik lists Home Forms O Copy Y Publish Unpublish Import Trash Q List name Db table Element Form View data Groups 7 t View data i EG w data Classes demo classes Add Edit Elements Visualizations Students demo students Add Edit Packages Connections Schedule Filter Select Status x Figure 25 List View For the students row click on View data By System Users Menus Content Components Extensions Help Fabrik lists SPI LABORATORY PTY LTD tialg Joomla Help Q Options 20 Published View details v View details View details trialg Joomla List Students Students Students belong in classes DO Empty AW Groupby amp CSV id date time No records 10 x Display Figure 26 Students List Add a row Click Add Page 28 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Det
36. fault to bootstrap Click the Save and Close Tab Click on Fabrik Lists Classes Select View Data Classes Classes contain students Gadd fGroupby csv name Vv Geography 4 Abe Elle Fred Smith Joe Doe Rob w Maths 1 Anne Other Display 10 Figure 73 Master detail view using bootstrap template JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 55 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version 7 4 4 Remarks This series of tasks completes the demonstration of some of the configuration possibilities The next step is to display the master detail lists in the front end Page 56 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 8 Display the Master and Detail lists on the frontend 8 1 1 Overview After having explored the means for setting up the master detail list relationships we can display the results on the front end 8 2 2 Activity Configuring the frontend display The activity focuses upon the tasks for displaying the master detail lists on the frontend 8 3 3 Tasks 8 3 1 3 1 Display the classes list Access path Joomla Menu Item Manager Select New Menus Content Components Extensions Help
37. h v 3 ag fr x lt Q PR Students belong in classes Figure 6 Enter Details and Publish Under Details enter the Label 1 e Students under Introduction enter Students belong in classes Under Publishing select Yes for Published Page 14 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 3 3 7 3 7 Set the Access details Select the Access Tab tialg Q Fabrik new list Joomla v sae cpse MEESE o cance Warning Select a database table or enter a new database table name Access Details Data Publishing View list Public Plug i an View records Public Edit records Public or use field Add records Guest Delete records Super Users Registered Special Figure 7 Set the Access details Change the default setting of Delete Records from Registered to Public 3 3 8 3 8 Set the Data details and Save Select the Data Tab JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 15 JFA URM 03 User Manual for Fabrik Master Detail example Joomla 3 2 version Bf f Fabrik new list v i a Save amp New Cancel Warning Select a database table or enter a new database table name Data Group by Pre filter Joins Related data Details Connection site database Data Publishing Table name demo stu
38. hy Display 10 Figure 35 Master and detail lists elements joined To view the Form click on the Id of the Classes List as in the figure below Users Menus Content Components Extensions Help tile Q Fabrik lists Joomla List Classes Classes Classes contain students Qadd 3 Group by v id date time id date time thy 2013 12 10 Geography 2013 12 10 Fred Smith Geography Display 10 Figure 36 To view the form that displays the joined fields JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 35 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version RI System Users Menus Content Components Extensions Help trial o Fabrik forms Joomla Classes Classes Geography demo_students name Fred Smith Class Geography Save Figure 37 Form with joined lists 6 3 6 3 6 To add Repeat Group buttons to the form Click on the Groups Tab The following view will be displayed Select the group 1 e classes demo students BX System Users Menus Content Components Extensions Help tilg Fabrik groups Joomla Z Edit Publish Unpublish w Check In Trash Help Options Message Item successfully saved 20 E Name Label Form Elements Published Elements EH Classes Classes 4 Classes Visualizations Packages F Classes demo demo_s
39. ial Q Fabrik elements Joomla Z Edit D Copy Publish Unpublish Show in list See V Check In Trash Help Options Home Filter 20 Lists Forms Show Groups Full Element Name Group Plugin inList Published Elements k G demo students id Classes internalid v v Packages date_time date time demo students date time Classes v v demo students Connections Schedule demo students name Classes demo students class id demo students class id Classes databasejoin i demo students Select form Classes demo_stu denti Select Status Figure 54 Removing elements from the list view Click on the Remove from list view Tab The list view will be updated as shown in the figure below Users Menus Content Components Extensions Help trial g Q Fabrik elements Joomla Z Edit Lh Copy Publish Unpublish v Show in list Remove from list Y Check In Trash Message 3 elements successfully removed from list view Home Filter 20 Lists Forms Show Groups Full Element Name Group Plugin inList Published Elements E Elements demo_students id Classes internalid ad Visualizations demo students Packages date time date time demo students date time Classes demo students Connections Schedule demo students name Classes demo students Filter class_id demo_students class_id Classes databasejoin Pl
40. iew is refreshed as in the figure below JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 65 User Manual for Fabrik Master Detail example Joomla 3 2 version JFA URM 03 System Users Menus Content Components Extensions Menu Manager Menu Items Message Menu item successfully saved Publish Unpublish w Check In Trash Home Menus Main Menu Menu Items Select Status X Select Max Levels v Select Language v Title Home Alias home Articles Festured Articles Classes List Alias classes list Fabrik list Students List Alias students list Fabrik list Classes Form Alias classes form Fabrik form Rebuild SPI LABORATORY PTY LTD talg John m Batch Search tools Clear Ordering ascending Select Access Acces Language ID Public All 101 Public Public Public Figure 91 Classes form menu item added Click the Preview Tab Top right corner Main Menu Home Classes List Students List Me Form Login Form Sp I lane Remember Me Create an account gt Forgot your username Forgot your password Figure 92 Front end view The Master detail view is presented as shown in the figure below Page 66 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03
41. lt Page Access Public Figure 76 Configure the details a Details Menu Title Enter Classes List b Details Menu item type Classes c Details Fabrik list Select Classes Click the Save and Close Tab The view is refreshed as in the figure below Page 58 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version System Users Menus Content Components Extensions Help talg Q Menu Manager Menu Items Me Preview trial Z Edit Publish Unpublish W Check In Trash r Home Rebuild a Batch Message Menu item successfully saved Menus Main Menu searc Search tools Clear Menu Items Ordering ascending Select Status v Select Max Levels X Select Access v Select Language v Status Title Access Language ID Home Alias home Public All 101 Articles Festured Articles Classes List Alias classes list vr Public Fabrik list Figure 77 Menu item added Click the Preview Tab Top right corner Main Menu Home Classes ty Login Form User Name Password Remember Me Create an account gt Forgot your username Forgot your password Figure 78 Front end view Click on the Classes List menu item The Master detail view is presented as shown in the figure below JFL URM 03 Fabrik Tutorial Master Detail JM 32
42. nts Extensions Help trial g o Fabrik lists Joomla List Classes Classes Classes contain students OAdd 5 Group by CSV TI Empty name w Geography 3 KUE Fred Smith Joe Doe Display 10 Figure 64 Select a name Select a name from the list and click on it Menus Content Components Extensions Help trial Q Classes demo_students Abe Elle Fred Smith Joe Doe Figure 65 The form view is displayed If the Add icon 1s clicked a new row will be added to the students list but not to the classes list as shown in the following figure JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 51 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Menus Content Components Extensions Help trial Q Classes demo_students Abe Elle Fred Smith Joe Doe Figure 66 Add a row Add details to the name element and click Save Menus Content Components Extensions Help trial amp Q Classes demo_students Abe Elle Fred Smith Joe Doe Figure 67 New row and details added to students list Now add a new row to the classes list and a new row to the students list Access path Fabrik Lists Select View Data Page 52 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY L
43. ons demo students Schedule demo students name Classes demo students Filter class id demo students class id Classes databasejoin demo students Plugin Figure 61 Click on the name element JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 49 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version tilg Fabrik edit element Joomla v Save amp Close L Save as Copy Close e Element properties linked to e name fh ny Figure 62 Click on unlink Click on unlink and then click on the List Settings Tab In Link to details click the yes radio button tilge Fabrik edit element Joomla v Save amp Close Save amp New 1 Save as Copy Close e Element properties linked to e name o Unlink List view settings Publishing Access List settings Icons Filters CSS Calculations List view settings Validations Show in list Link to details No ERO Allow ordering JavaScript Heading label Custom link Figure 63 Link to details Click Save and Close Access path Fabrik Lists Select Classes Select View data Page 50 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version a System Users Menus Content Compone
44. r 2013 Page 43 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version tilge Fabrik edit list Joomla v Save amp fy Save amp New Save as Copy Close Data Group by Pre filter Joins Related data Details ed s Publishing Plug ins Access Public Access Order by demo_students name Front end template fdemo classes label Order direction Ascending Start collapsed Yes Collapse others Yes Figure 51 Modify the Group By configuration a Group by Group by Select id pertaining to the classes id b Group by Order by Select demo students name c Group by Template Add fdemo classes label Click Save and Close Access path Fabrik Lists Select Classes Select View data The rows will be re ordered as in the following figure Note that the label Geography appears at the top of the list Page 44 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version SPILABORATORY PTY LTD RI System Users Menus Content Components Extensions Help trial Q Fabrik lists Joomla Classes Classes Classes contain students Add Group by id date time date time w Geography 3 2013 12 10 2013 12 10 Abe Elle 2013 12 10 2013 12 10 Geography Geography 2013 12 10 Geography 2013 12 1
45. r of classes The basis of this tutorial can be found at http fabrikar com help tutorials details 3 24 Purpose The tutorial referenced in Section 1 1 was created in the context of Joomla version 3 2 and Fabrik version 3 1 RC2 This document seeks to present the substance of that video based tutorial in a step by step fashion breaking the overall exercise down into a number of activities and their related tasks We have also added an introductory chapter i e Chapter 2 that seeks to present a design overview comprising use cases an entity relationship diagram and a number of screen mockups These additional items can be helpful in gaining an overall perspective regarding what is being attempted in the tutorial Unashamedly this reference manual presents a blow by blow approach in reproducing the original tutorial While a video tutorial is very useful in gaining a quick overall view of a tool s capabilities when it comes to actually digesting the material from a competency building perspective trying to reproduce the behaviour illustrated in the video is a bit like trying to drink from a fire hydrant possible yes but not very effective Audience The audience for this document comprises the following stakeholders including e Individuals who are trying to evaluate the capabilities of fabric and e Individuals are seeking to acquire competency to design Fabrik based components JFL URM 03 Fabrik Tu
46. rial Master Detail JM 32 doc SPI Laboratory Pty Ltd User Manual for Fabrik JFA URM 03 Master Detail example Joomla 3 2 version 4 Add Elements 10 LISS scriosann aunat Eie 18 Tr BONN 18 42 2 Activity Add elements to the Master and Detail lists 0 0000 18 45 ISS RANE 18 KRENKE 25 93 POG Data 10 PSUS nae 26 eth ONE cesia a EE E vera 26 5 2 2 Activity Add data to the Master and Detail lists 00 eee 26 93 9 MASKS ee 26 54 4 REMATKS Foes cies ces ices sides a eta de ere ne rer edi aw ncaa enka tett 30 6 Join the Master and Detail Lists rrnnrnnnrnnnrnnennnrnnnnnnnnnnnnnennunnnenne 31 ol TOVervIoW orriren EEEE de 31 6 2 2 Activity Join the Master and Detail lists rnnrrnnnnnrnnnrnnrnnennnnnnennennnenn 31 03 3s TASKS Ge 31 GA JF Kenaks isoina eaaa 42 7 Managing the Master and Detail lists display 00 43 EA TOVE ve 43 7 2 2 Activity Configuring the Master and Detail features 00 43 fees lemme Peal irs hte ee re emo oe ee 43 TA TRENGS cocci caecum ee a ocean com eee rete eReneceneE 56 8 Display the Master and Detail lists on the frontend 57 oT T OVeENVIEW neran auoureectnadictenits 57 8 2 2 Activity Configuring the frontend display axrnnvnnnrnnnnnennnnnnvnnennnnnn 57 D SPSS KS n E T nes necmeeeeeeeee 57 BA AL REMIKS He 70 JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page iii
47. s Classes Geography demo_students Fred Smith Geography Figure 41 Add a new student A new row is added Add Joe Doe to the name field and select Geography for the class field Users Menus Content Components Extensions Help Classes Geography demo_students Fred Smith Geography Joe Doe Figure 42 New student added capture the details Click Save 6 3 8 3 8 Unlink the detail list class from the master list With reference to Figure 42 it is inconvenient to display the class for each student in a given group The way to treat this is as follows Page 38 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version Select Elements and click on the class_id element Users Menus Content Components Extensions elp trial o Fabrik elements Joomla DY Copy v Publish Unpublish Show in list Remove fromiist V Check In Trash Help Options Home Filter 20 ix Lists Forms Show Groups Full Element Name Group Plugin in List Published Elements 5 i demo students id Students internalid v Visualizations J Packages date_time date time demo students date time Students Connections Schedule F demo_students name Students Filter F f ss id demo students class id Students databasejoin Plugin Studen
48. s Data List Select demo classes f Options Data Value Select 1d from the dropdown list g Options Data Label Select label from the dropdown list Click Save and Close JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 23 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Sm JavaScript Label Plug in databasejoin Id 0 Group Students ise Order New elements will appear at the er Drop down or radio lists containing data looked up in another table Options Data Default Add option in front end Advanced Render as Drop down Connection site database Table demo classes Value id Recommended Label Figure 19 Add element class id h Select the List Settings Tab on the left 1 Show in list Select the Yes command button trials O Fabrik edit element Bee aa el Y amp Close Save amp New L5 Save as Copy Close Help Details List view settings Publishing Access List settings Icons C Calculations Vslidations Show in list JavaScript Link to details Allow ordering Heading label Custom link Custom link in details Use ss row class Include in list query Always Render Figure 20 Save element settings After the Save and Close button has been clicked the following view will be displayed Page 24 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail
49. s link the figure below will be presented JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 trial Lo r Joomla Help Q Options 20 Published View details Y View details vY View details Page 31 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version trials Fabrik edit list Joomla Save amp Close Save amp New Un Save as Copy Close Text Filters Navigation Layout Links Notes Advanced 4 Save Data qm ID Publishing i Label Classes Plug ins Access Introduction Edit Insetv Viewv Format Table Tools 1B TU amp Paragaph v amp I Bis o 2 il lt gt Br x Xx Q Classes contain students Figure 30 Select the Data view Click on the Data Tab 6 3 3 3 3 Classes List Data View Joins Tab Add a join To create a list join between the master list and the detail list click on the Add function in the Joins group box tialg Fabrik edit list Joomla v Save amp Close Save amp New C Save as Copy Close Data Group by Pre filter Related data Details Data Joins Publishing Plug ins Add t ACCESS Display mode Each row separately Delete joined data Yes Figure 31 Click Add in the Joins group box 6 3 4 3 4 Define the Join parameters Set the values as follows Page 32 Issue 1 24 Decem
50. select New as shown in the figure below JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 19 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version Users Menus Content Components Extensions Help trial oO Fabrik elements Joomla E Z Edit D Copy Publish Unpublish Show in list Remove from list w Check In Trash p Options Home Filter Q xX 20 ix Lists Forms Show Groups ID F Full Element Name Plugin in List Published Elements i Elements 1 demo classes id Classes internalid v Visualizations Packages date time date time demo classes date time Connections Schedule Filter Plugin Select group Select Status Figure 13 Create a new element 4 3 3 3 3 Classes list Create element label Capture the following details for this element a Details For Name enter label b Details For label enter label c Details Under Group select Classes d Under Element type Select field e Under Options Advanced Tab Maximum Length Enter text 20 Joomla Details Name Label New elements will appear at the Plug in Renders an Input Field Placeholder Input type Max length m ua Figure 14 Capture the details for the label element Page 20 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc
51. torial Master Detail JM 32 doclssue 1 24 December 2013 Page 1 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version 1 4 Tools environment The following tools were used to create the content contained in this reference manual a The use cases and entity relationship diagramme presented in Chapter 2 were created using Visual Paradigm for UML www visual paradigm com b The screen mockups were created using MockupScreens www mockupscreens com c The WAMP environment used for local hosting is Uniform Server version 8 9 2 http sourceforge net projects miniserver files Uniform 20Server 8 9 2 Coral d The version of Joomla used is 3 2 See http www joomla org download html e The version of Fabrik use is http fabrikar com download look for version 3 1 RC2 applicable to Joomla 3 2 and click Download 1 5 Assumptions We have not described the steps needed to set up the WAMP i e Uniform server or how to install Joomla or Fabrik Instructions to support these installations are freely available on the Web 1 6 About the SPI LAB The SPI Laboratory Pty Ltd www spilab co za amongst other themes has a strong focus upon performing software quality assurance activities with most attention being paid to the early phases of product development e g working with the client to develop the product specification and the later parts of the lifecycle that fo
52. ts Select group Figure 43 Click on class id element talg Q Fabrik edit element Joomla Pi Save v Save amp Close Save amp New L1 Save as Copy Close e Element properties linked to e Class F Unlink ly Figure 44 Prepare to unlink the class id element from the parent Click on unlink Under Options click Hidden to set it to Yes Click Save and Close You may be asked for a confirmation click Save and Close again JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 39 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version masi Pi e Element properties linked to e Uisss Unlink Details Details Label Plug in m Drop down or radio lists containing data looked up in another table Options Data Default Add option in front end Advanced Default Figure 45 Hide the element Redisplay Figure 42 It will now appear as follows Bg System Users Menus Content Components Extensions Help trial Q Fabrik forms Joomla Classes Geography demo_ students Fred Smith Joe Doe Figure 46 The class label is now hidden in the students view Click on Add Page 40 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version BX System
53. ts View Backend Detail View Student Select Fred Smith Geography LE al y Abe Elle Geography LE 2013 12 07 Rober Another Maths O Display Number v 5 10 Page 6 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 2 3 3 Front end Classes View Frontend Master View This view shows the elements of the detail table linked to the master table from the front end Geography Students Select Abel Elle Maths Display Number JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 7 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version 2 3 4 Front end Students View Frontend Detail View Student Fred Smith Geography Abe Elle Geography 2013 12 07 Rober Another Maths Display Number v Page 8 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version 2 3 5 Frontend Master View Form Frontend Master View Form Classes Classes Label Students Name Field JFL URM 03 Fabrik Tutorial Master Detail JM 32 doclssue 1 24 December 2013 Page 9 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version 2 3 6 Front en
54. tudents 4 Classes Connections Schedule F Students Students 4 Students Filter Select Status Select form Figure 38 To add Group buttons click on Classes demo students a Repeat Repeatable Select the Yes command button Page 36 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version tilge Joomla Y sa gone Save amp New 1 Save as Copy Close Details Repeat Layout Pagination multi page forms Repeat Repeatable Template Repeat max Repeat min Add access Public Delete access Public or use field Copy values Figure 39 Configure the group button settings Click Save and Close The view in Figure 37 is now displayed as B System Users Menus Content Components Extensions Help trial Oo Fabrik forms Joomla Classes label Geography demo_students Fred Smith Geography Figure 40 The form with Group Buttons displayed 6 3 7 3 7 Add a new student to the group Now select the Add button and click it JFL URM 03 Fabrik Tutorial Master Detail JM 32 docIssue 1 24 December 2013 Page 37 JFA URM 03 User Manual for Fabrik SPI LABORATORY PTY LTD Master Detail example Joomla 3 2 version B System Users Menus Content Components Extensions Help tiale Q Fabrik forms Joomla Classe
55. ugin demo_students Select form Figure 55 Elements removed from the list view Access path Fabrik Lists Select Classes Select View data Note the removed elements Page 46 Issue 1 24 December 2013JFL URM 03 Fabrik Tutorial Master Detail JM 32 doc SPI LABORATORY PTY LTD User Manual for Fabrik Master JFA URM 03 Detail example Joomla 3 2 version Content Components Extensions ile trial g Fabrik lists Joomla List Classes Classes Classes contain students Add 13 Group by SV O Empty id date time v Geography 3 2013 12 10 Geography Abe Elle 2013 12 10 Geography Fred Smith 2013 12 10 Geography Joe Doe Display 10 Figure 56 Revised display student elements removed Now we need to take steps to hide the elements associated with the classes list Access path Fabrik Elements Groups Select classes The following view will be displayed Menus Content Components Extensions Help trial Q Fabrik elements Joomla Oy Copy Publish Unpublish v Show in list Remove fromiist V Check In Trash Help Options Home Filter 20 Lists m Forms Show Groups Full Element Name Group Plugin in List Published Elements demo classes id Classes internalid v v Visualizations wi R Packages date time date time demo classes date time Classes Connections Schedule demo classes label Cl

User Manual for Fabrik Master Detail example (Joomla 3.2 version)

Contents

Download Pdf Manuals

Related Search

Related Contents