Search Query for SEBLOD

Introduction

SEBLOD extensions

Search Query for SEBLOD construct an SQL query in your search form so that you can retrieve a list of items from any table in your database.


• Construct powerful custom SQL queries
• Return a list of non-SEBLOD items from your database

This plugin allows you to construct an SQL query in your search form so that you can retrieve a list of items from any table in your database. Please note that this plugin requires a working knowledge of how to construct an SQL query. While we have provided some worked examples below, please be confident in your ability to construct SQL queries before purchasing this plugin. There are resources for learning SQL available online at W3Schools.

View the tutorial "Using the SEBLOD Search Query Field Plugin" to see how to use this plugin : http://www.seblod.com/resources/tutorials/using-the-search-query-field-plugin

SQL QUERY EXAMPLES

Example 1 - return items from 1 table, where the Search Query field is the only filter in your Search Form. In this example we are specifically returning a list of Joomla menu items. The "AND access IN ($user->getAuthorisedViewLevels())" line is ensuring that only the menu items that the user is authorised to view, based on their Joomla Access Level, are returned.

SELECT title, id, level, link, menutype, note, params, type FROM #__menu
WHERE type IN ("alias","component","url")
AND published = 1
AND access IN ($user->getAuthorisedViewLevels())
AND menutype = "mainmenu"
ORDER BY menutype ASC, lft ASC

Example 2 - return a list of items from 1 table, where you have the Search Query field and other filters in your Search Form. In this example we letting the user enter some key words (using a SEBLOD field), and select a menu (also using a SEBLOD field), and then returning all the Joomla menu items that meet all of the criteria.

SELECT title, id, level, link, menutype, note, params, type FROM #__menu
WHERE type IN ("alias","component","url")
AND published = 1
AND access IN ($user->getAuthorisedViewLevels())
AND [MATCH]title||$uri->getValue('sebkeywords')[/MATCH]
AND [MATCH]menutype||$uri->getValue('seb
menu')[/MATCH]
ORDER BY menutype ASC, lft ASC

Example 3 - return items from 2 different tables. In this example we are returning Kuena Forum posts and some Joomla article content.

SELECT a.id AS myid, a.title AS mytitle, a.alias AS myalias,
b.long
desc AS mysnippet, c.title AS mycategory, "Content" AS mytype
FROM #content AS a
LEFT JOIN #
cck
storeitemcontent AS b ON b.id = a.id
LEFT JOIN #categories AS c ON c.id = a.catid
WHERE a.state = 1
AND a.access IN ($user->getAuthorisedViewLevels())
AND [MATCH]b.longdesc||$uri->getValue('sebgenericsearchkeyword')[/MATCH]
UNION ALL
SELECT a.thread AS myid, a.subject AS mytitle, c.alias AS myalias,
b.message AS my
snippet, c.name AS mycategory, "Forum" AS mytype
FROM #
kunenamessages AS a
LEFT JOIN #kunenamessagestext AS b ON b.mesid = a.id
LEFT JOIN #
kunena
categories AS c ON c.id = a.catid
WHERE a.hold = 0
AND [MATCH]b.message||$uri->getValue('sebgenericsearchkeyword')[/MATCH]
ORDER BY my
id DESC

Search Query for SEBLOD construit une requête dans votre formulaire de recherche de sorte que vous pouvez récupérer une liste d’éléments de n’importe quelle table de votre base de données.

• Construit de puissantes requêtes SQL personnalisées
• Restitue une liste des éléments non-SEBLOD à partir de votre base de données

Ce plugin vous permet de construire une requête SQL dans votre formulaire de recherche de sorte que vous pouvez récupérer une liste d’éléments de n’importe quelle table de votre base de données. Veuillez noter que ce plugin nécessite une connaissance pratique de la façon de construire une requête SQL. Alors que nous avons fourni quelques exemples de travail ci-dessous, veuillez vous assurer de votre capacité à construire des requêtes SQL avant d'acheter ce plugin. Il y a des ressources pour l'apprentissage SQL disponible en ligne à W3Schools.

Regardez le tutoriel "Using the SEBLOD Search Query Field Plugin" pour comprendre comment utiliser ce plugin : http://www.seblod.com/resources/tutorials/using-the-search-query-field-plugin

SEBLOD
Free

SEBLOD

By Octopoos
Content Construction
SEBLOD is an Application Builder and a Content Construction Kit (CCK). It helps to create/manage custom online applications & full-featured websites. The first CCK in Joomla history, first version in 2008. Joomla 4 compatible. Highly flexible Joomla! component, for content construction and web development. Build high-end websites with Joomla! Fit your clients' needs has never been so easy. Main...
Developer Add-on for SEBLOD
Free

Developer Add-on for SEBLOD

By Octopoos
SEBLOD extensions
Developer Add-on for SEBLOD exports a zip archive including all files/folders to speed up the development of plug-ins for SEBLOD. It offers considerable time savings by automatically creating the whole plugin tree (folders and files). It will export a downloadable archive that when decompressed, saves time and allows the developer to get started very quickly. Create any kind of plug-ins in a few...
Tabs Template for SEBLOD
Paid download

Tabs Template for SEBLOD

By Octopoos
SEBLOD extensions
Tabs Template for SEBLOD displays any list of items (Articles, Categories, Users..) with a Bootstrap tabs/pills style. Ease of use: Easy Installation: Ready to use, after install through the Joomla! Extension Manager. Requirements: Latest release of SEBLOD 3.x Target: Builders, Integrators...
Accordion Template for SEBLOD
Paid download

Accordion Template for SEBLOD

By Octopoos
SEBLOD extensions
Accordion Template for SEBLOD displays any list of items (Articles, Categories, Users..) with a Bootstrap accordion style. Ease of use: Easy Installation: Ready to use, after install through the Joomla! Extension Manager. Requirements: Latest release of SEBLOD 3.x Target: Builders, Integrators...
Select Dynamic Cascade for SEBLOD
Paid download

Select Dynamic Cascade for SEBLOD

By Octopoos
SEBLOD extensions
Select Dynamic Cascade for SEBLOD displays an AJAX Cascading Drop-down list. Each drop-down is filled dynamically depending on the value of the previous one. Example: a drop-down of cities dynamically populated after the selection of a country. Ease of use: Easy Requirements: Latest release of SEBLOD 3.x Target: Builders, Integrators...
Cloud Template for SEBLOD
Paid download

Cloud Template for SEBLOD

By Octopoos
SEBLOD extensions
Cloud Template for SEBLOD displays any list of items with an interactive tag cloud, based on HTML5 canvas....
Masonry Template for SEBLOD
Paid download

Masonry Template for SEBLOD

By Octopoos
SEBLOD extensions
Masonry Template for SEBLOD displays any list of items with a dynamic, responsive grid layout style....
Exporter Add-on for SEBLOD
Paid download

Exporter Add-on for SEBLOD

By Octopoos
SEBLOD extensions
Exporter Add-on for SEBLOD export data from Joomla and SEBLOD, including custom fields. Export Articles, Categories or Users Download or save to a directory Exporter will save your Joomla/SEBLOD data to a csv file, including custom fields. This can be all articles in a content type, a list of categories with their fields, or a list of all users (or users in a certain user group). By default th...
Backstretch Template for SEBLOD
Free

Backstretch Template for SEBLOD

By Octopoos
SEBLOD extensions
Backstretch Template for SEBLOD displays any list of items (ie pictures) as dynamically-resized background images....
Address to Coordinates for SEBLOD
Free

Address to Coordinates for SEBLOD

By Octopoos
SEBLOD extensions
Field which queries the Google Maps API and returns latitude and longitude based on a group of location fields. Automatically get lat/long based on a standard address Stores in the database to limit API queries Free the user from looking up their geolocation Use with SEBLOD Maps or other map plugins Address to Coordinates allows you to assign several location fields like street, city, zip code...
Importer Add-on for SEBLOD
Free

Importer Add-on for SEBLOD

By Octopoos
SEBLOD extensions
Importer Add-on for SEBLOD is the ultimate time saver when you have need to bring in a lot of content! Import Articles, Categories, Users Update Users Import as Standard or Custom storage It is a CSV importer that handles articles, bulk categories and users complete with custom fields. All you need is a spreadsheet with in the right format. Here's the basic spreadsheet setup: For existing fie...
Chart Template for SEBLOD
Paid download

Chart Template for SEBLOD

By Octopoos
SEBLOD extensions
Chart Template for SEBLOD transforms your list of content (i.e. data) in to an interactive graph or chart. The Chart template can transform your list of content (i.e. data) into an interactive graph or chart such as a bar chart, pie graph, geo chart and more. View the live demo see the template in action. Output options include: Area Chart Bar Chart Column Chart Combo Chart Donut Chart Geo Cha...
List Template for SEBLOD
Free

List Template for SEBLOD

By Octopoos
SEBLOD extensions
List Template for SEBLOD is a simple List Template for a List & Search type that uses an unordered list for markup. This template is especially good for a simple "latest articles" list or slideshow without complexities. Each item including all of its fields are wrapped together in a list item < li > tag. Since that is the only formatting this template provides, it is probably ideal for single fi...
Map Template for SEBLOD
Paid download

Map Template for SEBLOD

By Octopoos
SEBLOD extensions
Map Template for SEBLOD displays any list of items (ie locations) with an interactive Google Map. • Great for business directories, events, social maps, Real Estate listings and much more! • Can get coordinates from standard address fields • Custom fields in marker popups • Highly configurable Maps is a special template for a List and Search Type that displays a Google map with a...
Minima Template for SEBLOD
Free

Minima Template for SEBLOD

By Octopoos
SEBLOD extensions
Minima Template for SEBLOD is a simple content / form template with only one position and minimal default markup. It is geared towards those who prefer to write all of their template markup by hand. While there are other similar templates posted on the old forum (Barebones, Simple Simon, etc.), Minima keeps things simple with just a single position for all of your fields while still allowing use...
Checkbox Dynamic Field for SEBLOD
Free

Checkbox Dynamic Field for SEBLOD

By Octopoos
SEBLOD extensions
Checkbox Dynamic Field for SEBLOD creates a set of checkboxes based on information in your website's database. Similar to the Dynamic Select field that comes in the SEBLOD Core, this field pulls text and values dynamically from your database and renders them as checkbox options. For example, if you had a database table of Country Names and Country Codes (France, FR; Australia, AU... etc.) you co...
Canonical Field for SEBLOD
Free

Canonical Field for SEBLOD

By Octopoos
SEBLOD extensions
Canonical Field for SEBLOD specifies a Canonical URL to your content. SEO Canonical URL Tag Useful (and important for SEO!) when you need to access a same article from different menu items on your website. Provides a selection of a specific menu item in order to add the Canonical URL Tag to the page. The purpose of the SEBLOD Canonical field, is to create a single Canonical URL Tag when ther...
ACL Pack for SEBLOD
Paid download

ACL Pack for SEBLOD

By Octopoos
SEBLOD extensions
Joomla ACL Pack for SEBLOD contains 3 different Restriction Plug-ins related to Joomla! ACL that provide the flexibility to hide/display any field....
Letters Validation Pack for SEBLOD
Paid download

Letters Validation Pack for SEBLOD

By Octopoos
SEBLOD extensions
Letters Validation Pack for SEBLOD provides a set of validation plugins to check rules with letters: Lowercase & Space, Letter & Number... Options include entering the message (alert) to display on fail. Once installed, it will appear under the Required/Validation column in Admin and Site views with #3 selected (Form & Content Types) and under Required/Validation in Search Form view with #6 selec...
Numbers Validation Pack for SEBLOD
Paid download

Numbers Validation Pack for SEBLOD

By Octopoos
SEBLOD extensions
Numbers Validation Pack for SEBLOD provides a set of validation plugins to check rules on a Number: Decimal, Integer… Options include entering the message (alert) to display on fail. Once installed, it will appear under the Required/Validation column in Admin and Site views with #3 selected (Form & Content Types) and under Required/Validation in Search Form view with #6 selected (List & Search...
Typography Pack for SEBLOD
Paid download

Typography Pack for SEBLOD

By Octopoos
SEBLOD extensions
Joomla Typography Pack for SEBLOD contains 4 different Typography Plug-ins related to Joomla! features. JText Plug-in Message (message, notice, error) Pathway Prepare Content JText Typography: Useful for multi-language sites. Options include a Language Constant. In your translation string, you should use %s, and it will be automatically replaced by the value of the field....
Search Join for SEBLOD
Paid download

Search Join for SEBLOD

By Octopoos
SEBLOD extensions
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 Joi...
Search Operator for SEBLOD
Paid download

Search Operator for SEBLOD

By Octopoos
SEBLOD extensions
Search Operator for SEBLOD is a field that let you apply AND, and OR operators in order to tweak the search query. AND operator OR operator ( ) parentheses Drag and drop some operators (AND, OR) and parentheses between your fields in your search form, in order to construct an advanced SQL query....
Search Pagination for SEBLOD
Free

Search Pagination for SEBLOD

By Octopoos
SEBLOD extensions
Search Pagination for SEBLOD displays a link to go to the Previous or the Next page of your list. list text hereGo to Previous page Go to Next page This field allows you to display a minimalist pagination (only Previous / Next links)... which is perfect for a blog. Once installed, the Search Pagination field(s) can be created and added to the Search Form view of a List & Search Type. Note: s...
Search Total for SEBLOD
Free

Search Total for SEBLOD

By Octopoos
SEBLOD extensions
Search Total for SEBLOD displays the total of results. This field allows you to display the total of items directly in the Form section of your page. Once installed, the Search Total field can be created and added to the Search Form view of a List & Search Type. It uses a Language String (JText), with the following syntaxes: %1$s is the total number of items. %2$s is the current number of items...
Vimeo Field for SEBLOD
Free

Vimeo Field for SEBLOD

By Octopoos
SEBLOD extensions
Vimeo Field for SEBLOD displays a Vimeo video. Add Vimeo videos to your content No need to add embed codes Vimeo Field for SEBLOD allows you to quickly add a Vimeo video to your content items, without needing to add any embed code....

Search Query for SEBLOD

Version:
1.7.0
Developer:
Octopoos
Last updated:
Jun 06 2023
1 year ago
Date added:
Jul 31 2015
License:
GPLv2 or later
Type:
Paid download
Includes:
p
Compatibility:
J3 J4
Download

Uses Joomla! Update System