Skip to main content

Database Source for
YOOtheme Pro

Feed YOOtheme Pro layouts with MySQL tables from local or external Databases, supporting relations and dynamic filtering/ordering.

Subscribe
Documentation

Sources Manager

Create a source upfront and map it to any element as a true core source. Edit, duplicate, or delete the instances within the Essentials Source Manager.

Dynamic Filtering

Filter and Order table records based on its fields with support for Dynamic Values, a concept that relies on the YOOtheme Pro Dynamic Content.

What is a Content Source

A YOOtheme Pro content source allows you to load dynamic content into your layouts. Whenever that content changes, it will be automatically updated across your entire website.

Learn more about YTP Dynamic Content
The Source Configuration

Create as many sources instances as needed with different configurations each.

Versatile Connection

Connect to the Site database, to a different database using the Site connection, or override it completely to connect to an external one.

Table Relations

Use multiple One to One and One to Many table relation types to form a more advanced source. Map records of the main table or the related ones.

Database Source Configuration
The source name
It distinguish a particular instance from the rest.
The name of the database to which to connect to.
Defaults to the Site Database.
Override defaults and connect to any local or external database.
Relate the main table with one or multiple tables to create a more advanced source.
Relate the main table with one or multiple tables to create a more advanced source.

Did You Know...

...that with a Database Source you can create a source for almost any 3rd party component, e.g HikaShop? Within its limitations is a great workaround if there is not a dedicated source. Give it a try!
The Source Mapping

Map the table single record or a list of records with dynamic filtering, ordering, and caching.

Database Source Configuration
Two Query Types, Single Record and a List of Records.

Compose filter conditions based on the records fields with AND/OR or custom evaluation logic.

Optional cache to optimize the loading times of complex queries.

Filtering

Filter the records by adding multiple filter conditions based on the value of the records. Combine the conditions with AND/OR logic or set your own.

Ordering

Order the records by adding multiple order conditions based on the value of the records and ASC/DESC direction.

Database Source Configuration

Set a name for easier identification, it status for temporal disabling it, and a source which fields to use as Dynamic Values.

Map any rule setting with a dynamic value from the chosen source.

Set the comparison condition that has to be met as Is/Not Empty, Is/Not Equal to, Does/Not Contains, Less/Greater Than, Does/Not Starts With, Does/Not End With.

Database Source is part of Sources,
an Essential Addon for YOOtheme Pro
Subscribe Now
and get access to all Essentials