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

filtered select list - Extended SQL form filed type

6 years 1 month ago #1802 by Lukáš Nový

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

Please Log in or Create an account to join the conversation.

2 years 6 months ago #9937 by Alberto Nakali

Please Log in or Create an account to join the conversation.

Time to create page: 0.118 seconds
Powered by Kunena Forum

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.