- Home /home on the range…
EasyTable Pro! product info & how-to's
- Get EasyTable Pro!
- Getting Started
- Manager Features
- Search Options
- Field Types & Tokens
- Displaying your Table
- Access Control
- Detail View
- Advanced Display Options
- Advanced Settings
- EasyCode Include
- EasyTable Pro! product info & how-to's
Downloads get your files here...
- EasyTable Pro! Login to see your downloads
- EasyNAB for AkSubs Login to see your downloads
- EasyNAB for JDonation Login to see your downloads
- EasyTable for J! free... as in beer.
- EasyCode Include ...the geeks content plugin...
- EasyFooTables ...the cool tables plugin...
- EasyGoogleCSE ...the easy Google search mod...
- EasyStaging ...your website staging helper...
- EasyDownloads ...your secure download manager...
- CommWeb/MIGS for VM2 Login to see your downloads
- Register for Forums
- Category: 1.0
- Published on Friday, 10 June 2011 20:23
- Written by Craig Phillips
- Hits: 5152
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.
If 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.
Select the table you want to link to from the pop-up menu and click the 'Use Table' button.
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.
- The table and field alias' can't be modified.
- The table structure can't be modified so the UI elements aren't displayed at all.
- Other functions work as expected and the table info panel provides details of the table that is linked to.
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.
EasyTable Pro! Subscriptions
EasyTable Pro! Subscriptions are available for 1 or 3 months.
Popular Related Articles
Read More +
With EasyTable Pro's field options you can combine several fields to produce a custom URL for each record. There are lots… Read More +
Sorting CSS Classes
When table sorting is enable clicking on the column heading will sort the records on the current page… Read More +
EasyTable for J 1.0+ and EasyTable Pro! imports data in a CSV file format. (EasyTable Pro! also supports the TSV… Read More +
Simply put, EasyTable is a… Read More +