How to use MySQL Views

fabrikAn excellent feature of Fabrik is the ability to use MySQL views.  This allows you to build sophisticated queries, from which to create Fabrik Lists.  This article desribes the process.


phpMyAdmin

Open your preferred MySQL editor and create the view.  I recommend using a consistent naming convention when saving the view (e.g. view_contacts).

 

Fabrik Lists

Browse to the back-end of Joomla with your Administrator account.

  1. Go to Components > Fabrik > Lists.
  2. Click New.
  3. Give your list a Name.
  4. Select Data in the left pane.
  5. From the Database table dropdown, select the view that you just created.
  6. Make sure that Table name is blank.
  7. Click Save.

 

Primary Key

You will now need to select the Primary key for this list.

  1. Open the newly created list for editing.
  2. Select Data in the left pane.
  3. Select a Primary Key (usually ID).

 

Your Fabrik list based on a MySQL view should now be ready for use.

 

Thanks for visiting.