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 25200 7012Facebook | 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 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 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 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

Digital Publishing API Mappings First Public Working Draft

The Accessible Rich Internet Applications Working Group has published a First Public Working Draft of Digital Publishing... čítať viac

JOWeather (Joomla)

Joomla extension JOWeather (Joomla). Weather component Joomla Open Weather for Joomla 3. Display the data OpenWeatherMap site.Zdroj: Joomla ... čítať viac

Events Factory (Joomla)

Joomla extension Events Factory (Joomla). Events Factory is the best Joomla! solution for scheduling events and online ticketing.The extensi... čítať viac

W3C Invites Implementations of TTML Profiles for Internet Media Subtitles and Captions 1.1

The Timed Text Working Group invites implementations of an updated Candidate Recommendation of TTML Profiles for Interne... čítať viac

The Apache News Round-up: week ending 27 March 2015

this announcement is available online at http://s.apache.org/Iuu The ASF had a very busy week, and held its 2-day Members meeting (highlight... čítať viac

Apache Qpid Proton 0.14.0 released

The Apache Qpid community is pleased to announce the immediateavailability of Apache Qpid Proton 0.14.0.Qpid Proton is a... čítať viac

Apache Pulsar 2.1.1-incubating released

The Apache Pulsar team is proud to announce Apache Pulsar version2.1.1-incubating.This is a patch release for Apache pul... čítať viac

The Apache News Round-up: week ending 20 February 2015

this announcement is available online at http://s.apache.org/5wG The Apache News Round-up: week ending 20 February 2015 This week we welcome... čítať viac