Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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.
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.
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".
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!
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