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 23302 6500Facebook | 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

POWr Twitter Feed (Joomla)

Je dostupné nové rozšírenie pre redakčný systém Joomla pod názvom POWr Twitter Feed (Joomla). Want to show off your Twitter Feed? POWr Twitt... čítať viac

W3C responds to UNESCO concerns about Encrypted Media Extensions

UNESCO recently published a letter and an article about Encrypted Media Extensions. Since we didnt have an opportunity t... čítať viac

Cinergy makes significant digital signage savings using Ubuntu Core

Based in Dallas, Texas, Cinergy operates a chain of three cinema entertainment centres (CECs) with ambitious expansion p... čítať viac

CSS Fragmentation Module Level 3 Draft Published

The Cascading Style Sheets (CSS) Working Group has published a Working Draft of CSS Fragmentation Module Level 3. This module describes the ... čítať viac

MoWebSo Products Anywhere for VirtueMart 2 (Joomla)

Je dostupné nové rozšírenie pre redakčný systém Joomla pod názvom MoWebSo Products Anywhere for VirtueMart 2 (Joomla). This plugin allows yo... čítať viac

JUX Social Counter (Joomla)

Joomla extension JUX Social Counter (Joomla). JUX Social Counter Extension is a statistical module that helps you track the number of page l... čítať viac

D-Mack Cool QR Code (Joomla)

Je dostupné nové rozšírenie pre redakčný systém Joomla pod názvom D-Mack Cool QR Code (Joomla). D-Mack Cool QR is a flexible module that can... čítať viac

Seven Group Notes Published by the CSS Working Group

The Cascading Style Sheets (CSS) Working Group has published seven Group Notes today, on specifications that at this time, the group does no... čítať viac