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

filtered select list - Extended SQL form filed type

5 años 11 meses antes #1802 por 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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

2 años 4 meses antes #9937 por Alberto Nakali

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Tiempo de carga de la página: 1.247 segundos
Gracias a Foro Kunena

Utilizamos cookies propias y de terceros para mejorar nuestros servicios y mostrarle publicidad relacionada con sus preferencias mediante el análisis de sus hábitos de navegación. Si continua navegando, consideramos que acepta su uso.