Search Join for SEBLOD (Joomla)

Search Join for SEBLOD (Joomla)

The, User, Join, Table, Field, Group, Search, Left, Specific, Query, Let, This, Name, Order, Users, Common, All, List, From, Created, Usergroup, Right

Joomla extension Search Join for SEBLOD (Joomla). Search Join for SEBLOD is a field that let you apply a specific LEFT JOIN between 2 or more tables in order to tweak the

Search Join for SEBLOD is a field that let you apply a specific LEFT JOIN between 2 or more tables in order to tweak the search query.

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:


userusergroupmap 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
userusergroupmap 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..


Zdroj: Joomla Rozšírenia

2015-07-28 10:29:31 21508 5988Facebook | Twitter | Google+ | LinkedIn
Web PHP developer Milan Jankovec

<Milan Jankovec> Full Stack Web Developer

Vytváram webové stránky a aplikácie na mieru. Čistý a validný HTML5 kód na každej platforme, moderné animované CSS3 štýly a neuveriteľné JavaScript kúzla. Bezpečný a rýchly PHP kód bez obmedzení s geniálnou architektúrou databáz.

Najčítanejšie články

What's New in MySQL 5.6 Release Candidate

The MySQL 5.6 Release Candidate is an aggregation of the previous MySQL 5.6 Development Milestone Releases (DMR) and provides a true functio... čítať viac

MySQL 5.6: Improvements in Thread Pool

MySQL Thread Pool has now been updated for the MySQL 5.6 version. Obviously, with the much higher concurrency of the MySQL Server in 5.6 its... čítať viac

DBA and Developer Guide to MySQL 5.6

MySQL is the most trusted and depended-on open source database platform in use today. As such, 9 out of the top 10 most popular and highly-t... čítať viac

MySQL Cluster 7.3 GA: Increasing Developer Flexibility and Simplicity

The MySQL team at Oracle are excited to announce the immediate availability of the MySQL Cluster 7.3 Development Milestone Release GA releas... čítať viac

MySQL Applier for Hadoop

To support the growing emphasis on real-time operations, MySQL is releasing a new MySQL Applier for Hadoop to enable the replication of even... čítať viac

MySQL Cluster Auto-Installer: Video Tutorial

Learn how easy it is to deploy a MySQL Cluster database that has been configured to best meet your applications needs within your environmen... čítať viac

MySQL Replication Utilities: Video Tutorial

Learn how to use MySQL 5.6 and the MySQL Utilities to setup, monitor and manage your MySQL replication topology. See how a single command ca... čítať viac

MySQL 5.6 Replication - Enabling the Next Generation of Web & Cloud Services

The new MySQL 5.6.5 Development Milestone Release (DMR) introduces a much anticipated feature - Global Transaction Identifiers (GTIDs) for M... čítať viac

Dnešný výber

First Public Working Draft of Subresource Integrity Published

The Web Application Security Working Group has published a First Public Working Draft of Subresource Integrity. This specification defines a... čítať viac

Ubuntu - Snaps on NAS: IOT apps for your private network

QNAP selects snaps and Ubuntu to bring IOT apps to its NAS On Friday QNAP announced that they were adopting snaps as the... čítať viac

Entry Point Regulation Draft Published

The Web Application Security Working Group has published a Working Draft of Entry Point Regulation. Entry Point Regulation aims to mitigate ... čítať viac

Church Apps (Joomla)

Je dostupné nové rozšírenie pre redakčný systém Joomla pod názvom Church Apps (Joomla). Church Apps is the 1 software component that allows ... čítať viac

Apache Continuum 1.4.2 Released

The Apache Continuum team would like to announce the release of Continuum 1.4.2. This is primarily a security and bug fix release. All users... čítať viac

Groovy Gallery (Joomla)

Je dostupné nové rozšírenie pre redakčný systém Joomla pod názvom Groovy Gallery (Joomla). A Photo Gallery to admire Looking for something t... čítať viac

Marketplace Developer Diaries: BelVG

Why social is the future of commerceZdroj: Magento... čítať viac

SME Facebook Like Box Sidebar (Joomla)

Je dostupné nové rozšírenie pre redakčný systém Joomla pod názvom SME Facebook Like Box Sidebar (Joomla). SME Facebook Like Box Sidebar is F... čítať viac