Labour Day Public Holiday - Office Closed

Have a Great Queens Birthday Weekend - (is it anachronistic that we celebrate a foreign Monarch birthday with a public holiday?)We hope you enjoy River Fire at the Brisbane Festival this year! (We will).We'll be closed on Monday 6th October 2014. Clients with Priority Support contracts will not be affected. Ad-hoc Support clients can still lodge tickets but they won't be processed until we return to the office on Tuesday 7th October 2014.

Linking External Tables

Share

In the same way that you can display data from tables you've imported from CSV/TAB files EasyTable Pro can link to any standard Joomla! database table that it has access to (with a few restrictions). Please note linked tables may not work as with EasyTable Pro! if they use multiple or compound index keys or use foriegn keys. A linked table must have at least one primary key (all tables created by Joomla do).

For security purposes EasyTable Pro won't link to any table with "_core_acl" or "_session" in their name.

When you link an external table with EasyTable Pro there are a few restrictions that are mostly to protect the data in those tables.

EasyTable Pro will let you:

  • show all fields in the linked table (except ones called 'id' )
  • set the display order
  • set the appearance on fields in the list/detail views
  • use field options to affect the display of field data
  • enable front end searching of nominated fields

EasyTable Pro will not let you:

  • modify the structure of a linked table
  • edit data in a linked table
  • add/delete data in linked tables
  • upload data to linked tables

To link EasyTable Pro to a table Joomla! can access you must be logged in as either a "Super Administrator" or a level that you have given permission too through the Settings view.

Step 1

Link Table ButtonIf you have permission to link external tables to EasyTable Pro you will see the link icon ( shown to the right ) in Joomla's Toolbar when you open the EasyTable Pro component. Click on the button to open the Table Linking Popup.

EasyTable Pro - Link Table Popup Window

Step 2

Select the table you want to link to from the pop-up menu and click the 'Use Table' button.

Step 3

After clicking the 'Use Table' you are taken to the EasyTable Table Editor — as you will notice in the screenshot below some features are missing when compared to a standard table you've created in EasyTable Pro.

EasyTable Pro - Linked Table in Editor

  1. The table and field alias' can't be modified.
  2. The table structure can't be modified so the UI elements aren't displayed at all.
  3. Other functions work as expected and the table info panel provides details of the table that is linked to.
Once in the table editor you can configure the table name, description and display options for fields just like a norma EasyTable. Once you've done that don't forget to click the "Save" or "Apply" buttons.
 

Remember linking to other tables in your database should be done with care and consideration for any security, private or personal information that could potentially be revealed.
If you are unsure in anyway about linking to a table in your database we recommend that it not be done.

Share

You need to login to access the forums.

Member Login

You need to Login to access your Subscription details or the Forums.