An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.
This plugin allow "LEFT JOIN" query: return all rows from the left table, and the matched rows from the right table.
Options include Left Join (1), Left Join (2), Left Join (3). For each query 4 attributes must be filled:
Left Table: Name of the first Table (ex: #__usergroups)
Field Name of the common field in this first table (ex: id)
Field Name of the common field in the second table (ex: group_id)
Right Table: Name of the second Table (ex: #__user_usergroup_map)
The table on the right side of each Join line (parameter), is assumed to be already known/defined by the query.
Once installed, the Search Join field can be created and added to the Search Form view of a List & Search Type.
Example for a list of Users:
In order to filter all Users assigned to a specific User Group, let's setup a Search Join like this:
#__user_usergroup_map user_id id #__users
#__usergroups id group_id #__user_usergroup_map
Example for a list of Articles:
In order to filter all Articles created by a user assigned to a specific User Group, let's setup a Search Join like that:
#__users id created_by #__content
#__user_usergroup_map user_id id #__users
#__usergroups id group_id #__user_usergroup_map
This is not going to display anything on the Search Form.... but it will alter the SQL query.
In order to let the user select a specific User Group, you will need a 2nd field.. let's say a dynamic dropdown.
The storage of the field must be: Standard | User Group | id
Of course this is not specific to User Group, you can join the #__categories table or anything else..
How to install Joomla Search Join For SEBLOD Extension
You can install Joomla Search Join For SEBLOD Extension via Joomla Installer.
Follow the steps below:
- Download the Joomla Search Join For SEBLOD Extension package from the official website.
- Login to your Joomla website's administrator dashboard.
- Go to the "Extensions" tab and select "Manage" from the drop-down menu.
- Click on the "Upload Package File" tab and select the Joomla Search Join For SEBLOD Extension package that you downloaded.
- Click the "Upload & Install" button to install the extension.
- You will see a confirmation message when the installation is complete.
That's it! You can now use Joomla Search Join For SEBLOD Extension on your Joomla website.
Joomla Search Join For SEBLOD Language Files
Is Joomla Search Join For SEBLOD not available in your language?
We understand that not all extensions come equipped with language files, which can make it difficult for non-English speakers to fully utilize them. That's where our Language File Creation service comes in.
Great news!
ExtensionPlazza has now introduced a new feature to help Joomla users worldwide:
With our Joomla Extension Translation Tool, you no longer have to worry about language barriers preventing you from using the Joomla extensions you need. Our tool allows you to easily translate Joomla Search Join For SEBLOD Language Files to any language you require, making it easier than ever before to use Joomla extensions in your preferred language.
Joomla Search Join For SEBLOD Extension Customization
Do you need Joomla Search Join For SEBLOD to do more than what it currently offers? Our expert team can help you extend or customize Joomla Search Join For SEBLOD to meet your specific needs and requirements.
At ExtensionPlazza, we specialize in Joomla extension development and customization, and we are committed to providing exceptional services to our clients. We have extensive experience working with Joomla and related technologies, and we can help you create a solution that is tailored to your unique business requirements.
Whether you need a
- custom integration,
- additional features,
- or a complete overhaul of the extension
Contact us today to learn more about our extension customization and extension development services, and how we can help you take your project to the next level.
You can reach us through the following channels:
Free Extension of September 2024
Each month, ExtensionPlazza brings you a
Premium Joomla Extension developed by ExtensionPlazza exclusively for our valued visitors
Get the download link to your email inbox right now!
Extension Specifications
Current Version
1.7.0
Created on
28 July 2015
Last updated on
06 June 2023
Compatibility
Joomla 3,Joomla 4
Extension Type
Plugin
Free or Premium
Premium Joomla Extension
Listed in
Joomla SEBLOD Extensions Extensions
Developed by
Octopoos
Score
No reviews for this extension yet.
Share on Twitter
