View source for Column alias

The JTable class makes it possible to use column aliases. This can be used for when your database table has a different name than the data going into your table class.

An example is the state field. Often you will find that the database table has a field called state to keep track of the published/unpublished state of an item. Using the name state within Joomla is not recommended as it can lead to conflicts, instead the name published is used.

How to tell Joomla to store the value of the published form field into the state database field? We do this by using the method setColumnAlias().

We tell JTable that the database table has a field called state and not published. This statement needs to go into the __construct() method of your table class.

<source lang="php">
$this->setColumnAlias('published', 'state');
</source>

Now when you publish an item the database query will look like this:

<source lang="sql">
UPDATE prefix_yourtable
SET `state` = 1
WHERE (checked_out = 0 OR checked_out = 748) AND `id` = '72'
</source>

As you can see not the field published is set but the state field is set here.