JP CS Data Query - Dynamic Field Mapping

Dynamic Field Mapping

After configuring the database query, return to the YOOtheme Pro element's Content tab and map the returned database values to the appropriate element fields.

JP CS DataQuery automatically exposes columns from the selected Main Table and enabled joined tables.

Main Table Fields

Columns are available using table-prefixed field names to help avoid conflicts between tables.

For example, when using the Joomla content table:

• content_id
• content_title
• content_introtext
• content_created

Direct Main Table column names are also preserved where applicable, such as:

• title
• introtext
• created

Joined Table Fields

Joined table columns are also exposed using their table names.

For example:

• categories_id
• categories_title
• categories_alias
• users_id
• users_name
• users_email