Thu, 24 Sep 2026
Login

Joget 6 Datalist Bug

Confluence User - 16 Sep, 2017

Hi guys,

I think I have found two bugs in the latest v6 beta in regards to datalists.

I get these for two environments on the same Joget version (different MySQL versions).

  1. The datalist source configuration can't retrieve fields when joining another table or even the form in some cases (clicking on the form gives an empty result: 
  2. The datalist filter (options binder) can retrieve the options from the datalist but when pressing "show", no record is shown: 

The first error does not occur in Joget 6 Beta 2.

I also noticed that sometimes the form builder has to be reloaded as the menu gets stuck when trying to select a different source binder, etc. Has anyone else noticed these? Nothing comes up in the logs.

Cheers,

Eric

datalists;forms;jogetv6;filter;filtering

3

Confluence User •
18 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Hi Eric

I wrote a simple app with 2 forms and 2 tables, and joined them using the datalist advance datasource option. It works well in both MySQL and MSSQL. Attached is the app. APP_29032483.jwa

Based on this app, can you simulate the issue?

Or you can give me a sample app with a subset of your whole app (for privacy reasons) containing just the forms and list and userview giving the errors. Do specify which database you are using too.

Would also need more info on the datalist filter errror, and it would be great if you can include this error in yr sample app. 

Thank you.

 

Confluence User •
19 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Hi @Andrew,

I tested your app and yes, the same problem still exists (only in the BETA3 instances I am running though.)
The BETA3 instances are running on MySQL 5.6 - one on Windows 10, one on Ubuntu. BETA2 on Ubuntu and MySQL 5.7 works fine.

I attached the screenshot below for your reference.

For the second error, I added something to your sample app to demonstrate and the following happens when I try to filter f1:

It's weird because in this example, Test F1 comes up as an option but then the result is empty

Cheers,

Eric

APP_29032483-1-20170918230837.jwa

 

Confluence User •
19 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Hi Eric

  1. We will fix the datalist source configuration issue in next v6 beta. Thank you for highlighting.
  2. For datalist filter to work, I removed the "Default Form Options Binder" selection. It works after this.

 

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print