Joget 6 Datalist Bug

 
1
0
-1

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

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      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.

       

        CommentAdd your comment...
      1.  
        1
        0
        -1

        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

         

          CommentAdd your comment...
        1.  
          1
          0
          -1

          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.

           

            CommentAdd your comment...