I'm committed to realizing a not-for-profit project for a vocational school. I'm here again, that is with nuBuilder option after having tried to look for an already existing solution after having realized that just a customized application may fit the project. My previous project with nuBuilder (2.0) was for a genetic research.
I have soon noticed the huge improvements, the main one is the manual in pdf.
Following it I have created a browse form for displaying the records of the table of the courses; it worked fine.
When I tried to display in the form just the academic years available from the same table by adding a SELECT DISTINCT in the SQL field of the General tab: I have got a wrong result even if the statement works well in Phpmyadmin.
Here the images of what I mean:
Wrong results:
Setting:
After having deep studied the PDF user guide, I have found a clue that in some way may let understand that not all of the SQL code is possible to run in the SQL field of the General tab of a form.
Thatis in the page number: 27 in the table when it is explained the SQL field: ""The following SQL would have automatically appeared after you tabbed out of the above table field SELECT * FROM course_ organization".
I have searched thorough all threads of the forum to look for further information; at the end of my walk I have found that there is a "need" in many users of an easy way to display not all of the records of a table in a screen or browse form but just a filter or custom generated selection of them.
You may detect that need in these threads:
criteria Form for a Browselist? (v 3.0)
http://forums.nubuilder.cloud/viewtopic.p ... iew#p14943
advanced search - browse table and filter (v 3.0)
http://forums.nubuilder.cloud/viewtopic.p ... earch+form
Filter a browse screen from a button (v 2.0)
http://forums.nubuilder.cloud/viewtopic.p ... view#p3924
How to display query results on a form? (v 2.0)
http://forums.nubuilder.cloud/viewtopic.p ... view#p9849
I have taken into consideration all of the pieces of information available in the User guide, in the demo application; I have come at the conclusion that
the way to do that is to create a table with the result of the SELECT DISTINCT from the table course then the browse form on it
With this thread, I'm open to any tip or just to understand that I'm missing something for better options of the one I have got.
Thank you.