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:
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:
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
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 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
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
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
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
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
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
The new MySQL 5.6.5 Development Milestone Release (DMR) introduces a much anticipated feature - Global Transaction Identifiers (GTIDs) for M... čítať viac
The Accessible Rich Internet Applications Working Group has published a First Public Working Draft of Digital Publishing... čítať viac
Joomla extension JOWeather (Joomla). Weather component Joomla Open Weather for Joomla 3. Display the data OpenWeatherMap site.Zdroj: Joomla ... čítať viac
Joomla extension Events Factory (Joomla). Events Factory is the best Joomla! solution for scheduling events and online ticketing.The extensi... čítať viac
The Timed Text Working Group invites implementations of an updated Candidate Recommendation of TTML Profiles for Interne... čítať viac
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
The Apache Qpid community is pleased to announce the immediateavailability of Apache Qpid Proton 0.14.0.Qpid Proton is a... čítať viac
The Apache Pulsar team is proud to announce Apache Pulsar version2.1.1-incubating.This is a patch release for Apache pul... čítať viac
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