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

filtered select list - Extended SQL form filed type

5 года 11 мес. назад #1802 от Lukáš Nový
Lukáš Nový создал тему: filtered select list - Extended SQL form filed type
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

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

2 года 5 мес. назад #9937 от Alberto Nakali

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

Время создания страницы: 0.146 секунд
Работает на 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.