× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

filtered select list - Extended SQL form filed type

5 Jahre 11 Monate her #1802 von Lukáš Nový
filtered select list - Extended SQL form filed type wurde erstellt von Lukáš Nový
Hi,

I am facing a problem with "filtered select list". To demonstrate it I prepared simple component to manage vehicles.

Logic: We have
1. vehicle types - moto, car, truck
2. manufacturers - each defined by name and type, e.g.
Aprilia - moto
KTM - moto
Audi - car
BMW - car
3. finally items - each item = car defined by name, type, manufacturer
And here comes problem in form view.
If "my first car" item is type of "car" I would like to have select box with manufacturers limited to (Audi, BMW).

It should be possible using J_SQL_EXTENDED, (docs.joomla.org/SQL_form_field_type) and sql_filter parameter.

Well, I think I configured it correctly, but it does not work. The list still contains both motos and cars.

Could somebody help?

Demo component is shared with code: fbbd6aea28ff550b7246a1f8cf831707

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

2 Jahre 4 Monate her #9937 von Alberto Nakali

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Ladezeit der Seite: 0.166 Sekunden
Powered by Kunena Forum

Wir verwenden eigene Cookies und Cookies von Drittanbietern, um Ihr Nutzererlebnis zu verbessern und Ihnen einen optimalen Service zu bieten. Wenn Sie die Website weiter nutzen, gehen wir davon aus, dass Sie mit unserer Cookie-Politik einverstanden sind.