by Octopoos

Field Octopoos Paid

Adds an AJAX Cascading Drop-down list. Each drop-down is filled dynamically depending on the value of the previous one.

* excl. VAT
  • AJAX-powered
  • Unlimited number of drop-downs
  • Works with any table
  • Joomla! 3.x
  • Joomla! 4.x

Implement a series of fields "dynamic selection list" each dynamically (Ajax) filled based on the previous. The options for each drop-down list are generated from a SQL query against any table of Joomla database (#__content, #__categories , #__my_table ...).

The options list is composed of two types of information in the form of a couple "Text = Value"
• Text: displayed in the list
• Value: stored in database

Params

  1. Selection Title : Text of the first option , generally in the form, an invitation to the selection. The value of this option is an empty string. With the select on the right you can choose if the select label is displayed when there is only one option.
  2. Query: choice of construction for SQL query to fill the selection list :
    1. Construction: Wizard SQL query. It is built with the following options (5, 6, 7, 8, 9, 10).
    2. Free : you must write the request manually. Extensive knowledge in SQL is required for this construction.
  3. Group Identifier: Each select in the same cascade must have the same Group name.
  4. Behavior: to define where the select is positionned in the cascade.
  5. Table : Table of Joomla database on which the query will be performed ( FROM clause ).
  6. Name Option : name of the column in the table, used to fill the text options of the list selection part .
  7. Value Options : name of the column in the table, used to fill the value options of the list selection part.
  8. Clause WHERE: clause WHERE of the query.
  9. Parent: name of the column in the table on which the clause WHERE will be apply with the result of the previous select in the cascade. Only available on middle and last selects of the cascade.
  10. Order By : to define how results will be order in the select.
  11. Languege code: define define available languages in the select.
  12. Language detection: define how to detect the language to use in the select.
  13. Methode: the methode used by Ajax Query. Only available in the last select.


Create a cascade


For example, when you want to be able, in a form, to select a city depending on county, which county depending on region.

Assume that i have 3 tables in my joomla database:

  1. #__regions
    • id
    • name_region
  2. #__counties
    • id
    • name_county
    • region_id
  3. #__cities
    1. id_city
    2. name_city
    3. county_id
    4. population


The first select "Select a region" will be like that:


For the second "Select a county":


and for the third "Select a city":


EDIT [November 23th]:
Version 1.3.5 should fix the issue while using Dynamic Cascade fields as "Filters" in a Search Form.
Meaning: no more infinite loop now. Be sure to apply the "Filter" variation only on the 2nd field.


Remarks:

  • It's not mandatory to have selects in Middle position. A cascade can be only with two selects.
  • By cons, "Start" and "End" positions are mandatory.

Note for everyone who has already purchased the plug-in (before the public release):

  • Please send us an email (reply from the previous email we sent to you), and after verification, we will assign the product to your account.

Business Clubs:

  • Lifetime License
  • Unlimited Domains

Single purchase:

  • Free Updates
  • Lifetime License
  • Unlimited Domains

Details:

2431
31878
GNU GPLv2
2013-10-11
2023-10-02
2022-09-30

Requires:

Latest SEBLOD

Downloads

ChangelogFileVersionDate

! PHP 8.x ready
! SEBLOD 4 ready

(use 1.6.2 for SEBLOD 3)

Sign In1.7.12022-09-30

! PHP 8.x ready

Sign In1.6.22022-09-30

! SEBLOD 4 ready
(use 1.6.1 for SEBLOD 3)

Sign In1.7.02022-07-25

# Fix Ajax Url on multisites

Sign In1.6.12021-10-13

# Fix javascript

Sign In1.6.02021-08-18

# Fix "LIKE" query.

Sign In1.5.32019-12-26

# Fix notices.

Sign In1.5.22019-03-29

Preparing stuff for SEBLOD 4.

Sign In1.5.12019-02-21

^ Namespace (JS) updated.
# Unterminated statements.

Sign In1.5.02018-12-03

# [lang] issue fixed.

Sign In1.4.12018-07-03

! SEBLOD 3.16 ready.
# Export fixed.
^ Copyright updated.

Sign In1.4.02018-06-27

! Cleaning performed.

Sign In1.3.72017-06-09

^ Copyright updated.

Sign In1.3.62017-05-17

# "Change" event fixed.
# Syntax (Free Query).

Sign In1.3.52016-11-23

# Translation issue fixed.

Sign In1.3.42016-11-10

# Missing jQuery

Sign In1.3.32016-10-04

! Extensive cleaning performed.

Sign In1.3.22016-08-26

# Fix static variations.

Sign In1.3.12016-05-25

^ Copyright updated.
* Security Release.
>> Variables protected.
# Fix scripts for tmpl=raw

Sign In1.3.02016-05-04

# Missing XML update.

Sign In1.2.12015-08-19

+ "has-value" class added.
- size="1" removed.
# regexp issue tweaked.

Sign In1.2.02015-05-09

# Non-numeric issue fixed.

Sign In1.1.42014-12-07

+ Replace Live syntax added.

Sign In1.1.32014-10-17

# JUri::base() issue fixed.

Sign In1.1.22014-05-13

Initial Release.

Sign In1.1.02013-10-11

Rating & Reviews

free SQL query example please

10 years ago
A great plugin but lacks a good free SQL query with the PArent parameter please. thanks!
5
5
3