×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
SQL Filter in component
Vitor Micillo Junior
New Member
Posts: 3
8 lata 4 miesiąc temu #1415
przez Vitor Micillo Junior
SQL Filter in component was created by Vitor Micillo Junior
Hi team,
English:
What is the possibility of creating a field in the registration form of the component causing it to pull information from the sql based on information from a field above? for example: I have a State field and the other city, both have information in the database, by selecting the State field below pulls only the cities with references in that State or province
Brazilian Portuguese
Qual a possibilidade de criar um campo no formulário de cadastro do componente fazendo com que ele puxe informações do sql com base em informação de um campo acima? por exemplo: tenho um campo Estado e o outro cidade, ambos possuem informações no banco de dados, ao selecionar o estado o campo abaixo puxa apenas as cidades com referencia naquele esta
English:
What is the possibility of creating a field in the registration form of the component causing it to pull information from the sql based on information from a field above? for example: I have a State field and the other city, both have information in the database, by selecting the State field below pulls only the cities with references in that State or province
Brazilian Portuguese
Qual a possibilidade de criar um campo no formulário de cadastro do componente fazendo com que ele puxe informações do sql com base em informação de um campo acima? por exemplo: tenho um campo Estado e o outro cidade, ambos possuem informações no banco de dados, ao selecionar o estado o campo abaixo puxa apenas as cidades com referencia naquele esta
Proszę Zaloguj lub Zarejestruj się, aby dołączyć do konwersacji.
Mekalb
New Member
Posts: 8
8 lata 3 miesiąc temu #1419
przez Mekalb
Replied by Mekalb on topic SQL Filter in component
Hi,
How did you set up the State and City lists? I think you could set up the City field as a foreign key, and use the State as the key, then you can automatically filter the City value by State.
How did you set up the State and City lists? I think you could set up the City field as a foreign key, and use the State as the key, then you can automatically filter the City value by State.
Proszę Zaloguj lub Zarejestruj się, aby dołączyć do konwersacji.
Vitor Micillo Junior
New Member
Posts: 3
8 lata 3 miesiąc temu #1420
przez Vitor Micillo Junior
Replied by Vitor Micillo Junior on topic SQL Filter in component
that's exactly what I do Mekalb, on city table has a column named state_id which is the reference of another State table, when I say I mean State (region with numerous cities, like a province)
But the great doubt is when you do it all the time here in the component creator
Thanks
But the great doubt is when you do it all the time here in the component creator
Thanks
Proszę Zaloguj lub Zarejestruj się, aby dołączyć do konwersacji.
Czas generowania strony: 0.051 s.