Thu, 24 Sep 2026
Login

When I populate a select box, the sql query half work. Do you understrand why?

Confluence User - 15 Mar, 2017

Here's my query:

Here's the 10 results of the query in joget:

Here's the results of the same query from sql management:

Thank you very much, dear expert!
Jonatan Nadeau

 



 

selectbox;jdbc

4

Confluence User •
15 Mar, 2017 •
confluenceUser •
1 •
confluenceUser •

Hi Jonatan nadeau

The sql should be "select * from app_fd_Machine". Joget will append "app_fd_" to each table name and "c_" to each column name.

Confluence User •
16 Mar, 2017 •
confluenceUser •
•
confluenceUser •

Hi Matthew, since it's a table I have create from sql management, the name of it won't be app_fd_Machine. should I rename the table to app_fd_Machine ? Thank you very much.

Confluence User •
16 Mar, 2017 •
confluenceUser •
•
confluenceUser •

Hi Jonatan nadeau, if it is your own created db table, you don't need to rename it. Your SQL syntax would be correct then. To populate selectbox using JDBC, just pass 2 column values, example "select idmachine, description from Machine".

Confluence User •
16 Mar, 2017 •
confluenceUser •
•
confluenceUser •

Hi, thank you, it is now working. I just don't understand why using two value of column values work but not with *... Thank you again!

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
How to retrieve "Grouping" value from Select Box option in Joget?
Syntax Error on Popup Select Box
SQLI ERROR
is possible to add search on select box search data list ?
select box value
Loaded data from Javascript/jQuery in Multi Select Box is not saved into database
still issue multi page set read only . my load binder is using jdbc binder custom datasource
How to Update Environment Variable of Other Application in Same Environment
apply a filter in a dropdown list located in a Spreadsheet based in a value in the form
Popup select box is not auto selecting the previous selection
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print