How to get value from select query in a html grid

 
1
0
-1

Hi Team,

I am creating a data display page based on the joget form and that form is a very complex design that is only possible to HTML design.

But I don't know how to retrieve the data from the select query and bind the HTML tag.

The query like select * from the advancedetails where created_by='currentUser.username# 

Based on the current user multiple line item records and need to show the different format.

I was trying to use spreadsheet, form grid, advance grid but only show the line item wise. 

Is it possible to show like python script or PHP or .net  any database query run and display into the HTML grid same like want to the Joget form using custom HTML?.

Single document how to display I know use hash variable but multiple records fetch from select query how to do. 

Appreciate it if anyone can help.


Thanks & Regards

Ajeet

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Anders, 

      Thanks for the suggestion,  FYI, as a sample wants to bind into the HTML page, Please advise me how to do it like. All the computed values are coming from the different-different table and no link between any table only by filter using the select query get the sum of value and want to display. If this format did any complex will do it.


      Kindly suggest how to bind the data in HTML Tag

      Action Taken:

      On the Joget form took the sections and use the fields, but the problem is section data is not displaying the tabular format, in a single section multiple select queries are not working, and many problems. 

      The data is not open based on the document by default needs to show on the page.


      Format: 

      1. Anders

        Hi, if you are populating a grid like in the image, you could try Load & Store Form Grid Data Using Bean Shell Form Binder? Otherwise, as suggested in the other answer you might want to develop a custom plugin.

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

      Hi, what kind of data display page do you have in mind? Perhaps it is possible to just use CSS and/or JavaScript to customize your form design. That would be a much simpler way to do it, since modern CSS and JS can accomplish a lot. If that is really not possible, you could try developing your own plugin. For example, the How to develop a Gantt Chart Userview Menu example shows a very different type of design. 

        CommentAdd your comment...