by Octopoos

Field Octopoos Paid

Field that let you apply a specific LEFT JOIN between 2 or more tables in order to tweak the search query.

* excl. VAT
  • Joomla! 3.x
  • Joomla! 4.x

The Search Join field gives you the ability to apply a specific LEFT JOIN between 2 or more tables .
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..

Business Clubs:

  • Lifetime License
  • Unlimited Domains

Single purchase:

  • Free Updates
  • Lifetime License
  • Unlimited Domains

Details:

1391
17471
GNU GPLv2
2013-05-25
2022-07-25
2022-07-25

Requires:

Latest SEBLOD

Downloads

ChangelogFileVersionDate

! SEBLOD 4 ready
(use 1.6.0 for SEBLOD 3)

Sign In1.7.02022-07-25

+ Apply "replaceLive" syntax.

Sign In1.6.02019-12-26

^ Copyright updated.

Sign In1.5.22018-06-27

# Remove notice.

Sign In1.5.12017-09-05

^ Copyright updated.
+ Placeholder tables added.

Sign In1.5.02017-05-10

+ Allow syntaxes in sub-query.

Sign In1.4.02016-05-25

^ Copyright updated.
+ INNER/LEFT/RIGHT modes.
# Apply Restrictions.
- Remove useless parameters.

Sign In1.3.02016-05-04

+ Ability to join the same table
more than once added.
+ JOIN/WHERE param added.

Sign In1.2.02015-07-20

# Issue fixed on back-end.

Sign In1.1.12014-07-21

+ Up to 10 joins.

Sign In1.1.02014-06-06

# Fix for Joomla! 3.3.0

Sign In1.0.22014-05-12

! SEBLOD 3.2 ready.

Sign In1.0.12013-12-24

Initial Release.

Sign In1.0.02013-05-31

Rating & Reviews

It should be a core feature !

10 years ago
Great plugin cause it allows you to extend your search with almost infinite filters.
Just be sure to set foreign table on left and table with foreign key on right in the field options !
4
5
4

Very useful this plugin

10 years ago
Now this is well explained!
4
4
4