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 - * ]