Select distinct doesn't work in browse screen form!

Select distinct doesn't work in browse screen form!

Postby cypherinfo » Sat Aug 05, 2017 4:28 am

Hello,
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:
Image
Setting:
Image

Image

Image

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.com/viewtopic.php?f=13&t=9089&p=14943&hilit=view#p14943

advanced search - browse table and filter (v 3.0)
http://forums.nubuilder.com/viewtopic.php?f=13&t=8443&hilit=search+form

Filter a browse screen from a button (v 2.0)
http://forums.nubuilder.com/viewtopic.php?f=4&t=2660&p=3924&hilit=view#p3924

How to display query results on a form? (v 2.0)
http://forums.nubuilder.com/viewtopic.php?f=4&t=7859&p=9849&hilit=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.
cypherinfo
 
Posts: 124
Joined: Fri Feb 19, 2010 2:12 am

Re: Select distinct doesn't work in browse screen form!

Postby admin » Sat Aug 05, 2017 7:05 am

cypherinfo,

nuBuilder 4 is just around the corner, I'd wait for that.

Steven
admin
Site Admin
 
Posts: 3215
Joined: Mon Jun 15, 2009 9:53 am

Re: Select distinct doesn't work in browse screen form!

Postby cypherinfo » Sat Aug 05, 2017 7:26 am

admin wrote:cypherinfo,

nuBuilder 4 is just around the corner, I'd wait for that.

Steven


I wonder if you imply that that issue will be overcomed with the next version; if it isn't so my question make sense yet; I would use the time till the availability of the next version and tips I may receive to fix it.

Thank you.
Last edited by cypherinfo on Wed Aug 09, 2017 6:52 pm, edited 1 time in total.
cypherinfo
 
Posts: 124
Joined: Fri Feb 19, 2010 2:12 am

Re: Select distinct doesn't work in browse screen form!

Postby cypherinfo » Sun Aug 06, 2017 1:41 am

Bump
cypherinfo
 
Posts: 124
Joined: Fri Feb 19, 2010 2:12 am


Return to General



cron