Thu, 24 Sep 2026
Login

Link 2 tables in one datalist

Confluence User - 21 Oct, 2019

Hi, may I ask,

Is it possible to link 2 tables in one datalist? So the datalist can display list of information from 2 tables?

Currently, I'm using Joget Community Edition. I was been told that I could use jdbc datalist action but unfortunately it is a plugin for Joget enterprise edition. I also heard of Bean shell, but I am not sure on how to use it. 

Is there any other way to solve my problem? Thank you so much for your help.

datalists;table;october;2019;mysql;bean;shell

3

Confluence User •
21 Oct, 2019 •
confluenceUser •
•
confluenceUser •

Hi Siri   I have used the jdbc plugins from the marketplace in the community edition. once you install the plugins you can also create views and store procedures within the database and reference them in your application. I find this easier to architect and test within your sql studio so that you have the desired results.


below is the link to the jdbc plugins.


https://marketplace.joget.org/jw/web/userview/mp/mpp/_/aa?d-2242819-p=1&d-2242819-fn_AppName=jdbc&d-2242819-fn_Category=&d-2242819-fn_Edition=&d-2242819-fn_AppVersion=&d-2242819-fn_AppPayment=&OWASP_CSRFTOKEN=9OR9-U6R0-KVV6-XLDD-3KZ0-6BHW-47D5-OQ9T



Confluence User •
29 Oct, 2019 •
confluenceUser •
•
confluenceUser •

Thanks Anthony

Confluence User •
06 Dec, 2019 •
confluenceUser •
•
confluenceUser •

Anthony Sica I have uploaded the file under the link you gave it, but still I didn't get any option other than connecting datalist into one for although the plugv in is inststalled successgully

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Plugin for PDF Editor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
Create Folder on the Home Page
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print