How to retrieve data from external database using hash variable?

Confluence User - 02 Jan, 2023

Hi, I am new at joget, really appreciate all the advise!


So I am currently making some simple case project.

I have form to update Vendor Name and Vendor Description, I connect the form and the datalist to my local host Oracle with JDBC Binder.

Here is my userview,

I place hyperlink action mapping to redirect to detailed form, so after I clicked the Vendor name I hope I can retrieve some database value related to the clicked ID or name.

Here is the form after I clicked the hyperlink in Vendor Name, I just try to get simple value of description value with hash method but it didn't work. If I try with Joget database it seems work, is it because #form methods only read ID that generated by Joget database like [b30bce20-c0a82095-14976e70-fded1735].


So my main question is how to retrieve value, example if I clicked vendor one then redirected form will display the description one, how to call or parse that value? Is my hash method wrong or What kind method can I used or find the documentation?


Thank you very much, been all week seeking this but still has no clue.

datalists;forms;hash-variables;database

2


05 Jan, 2023
confluenceUser
confluenceUser

Hi, it appears that the Vendor Description holds the ID of the vendor. In that case, you could try using a readonly selectbox with a JDBC Options Binder that will retrieve the appropriate label based on that ID.

05 Jan, 2023
confluenceUser
confluenceUser

Thank you so much, it helps me, currently I found out I can use #requestParam.parameter#.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print