.. ==================================================
.. FOR YOUR INFORMATION
.. --------------------------------------------------
.. -*- coding: utf-8 -*- with BOM.

.. include:: ../../../../Includes.txt


.. _users_plugins_main_relatedtables:


Related Tables
==============


Tab [Bridge]
------------

You can use upto four related tables out of the box:

* Category

* Group

* Section

* Tag

The xBlog will display the data in the frontend.


Setup
-----

You can configure these properties by the Constant Editor:

* firstResult: first record (0 is the first). Like first part of SQL LIMIT 

* maxResults: amount of records. Like second part of SQL LIMIT

* andWhere: Clause for the an andWhere statement. Example: my_news.date > UNIX_TIMESTAMP(NOW())

* orderBy: ORDER BY clause. BEWARE OF THE SYNTAX: field1|ASC||field2|DESC||field3|ASC

Constant Editor

* categories [XBLOG - MAIN - DATAPROCESSOR - * ]