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

filtered select list - Extended SQL form filed type

5 jaren 11 maanden geleden #1802 door Lukáš Nový
filtered select list - Extended SQL form filed type werd gestart door 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

Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.

2 jaren 4 maanden geleden #9937 door Alberto Nakali

Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.

Tijd voor maken pagina: 0.186 seconden
Gemaakt door Kunena

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.