Page 1 of 4

Browse screen and pagination

Posted: Wed Mar 09, 2022 10:55 am
by BDemeuse
Hi,

With the new version
DB Version: V.4.5-2022.01.30.00
Files Version: V.4.5-2022.02.02.00
I have the screen (browse and browse&Edit) bottom bar with the correct information: nb of records and nb of pages only for globeadmin and always limited to first page :-(

Thanks

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 4:30 pm
by kev1n
Inspect the generated SQL by executing nuCurrentProperties().browse_sql in the developer console. Then run it in phpMyAdmin to see if you get any results back.

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 5:06 pm
by BDemeuse
Sorry what is the developer console ?

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 5:11 pm
by kev1n
Google "how to open the developer console"

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 5:30 pm
by BDemeuse
Here below what I have got :-(
Thanks in advance for your support.

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 5:44 pm
by kev1n
You need to run it on the browse form to retrieve its sql.

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 5:52 pm
by BDemeuse
here is the result

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 6:10 pm
by kev1n
Remove the \n

Re: Browse screen and pagination

Posted: Wed Mar 09, 2022 6:34 pm
by BDemeuse
I executed in phpMyAdmin but I should remove in the generated SQL but how can I do ?
And to do it for all the browse forms ...
Is there a bug fix ? The issue is with the last version :-(
Thanks

Re: Browse screen and pagination

Posted: Thu Mar 10, 2022 8:00 am
by kev1n
These \n ( new line) are only output in the console so that is not the issue. Do you get rows back after removing them in phpMyAdmin?