Sorting in V7

[Volker Trapp]

This should be very easy since it was already a basic function in V5.

Just add the fields in the sorting ( order ) dialog and you get the little

sorting arrows in the table headers.

I have started my first V7 project and cannot get ist running.

Database is MSSQL using pymssql. I add the fields and get the arrows.

But by clicking no sorting (nothing) happens. It only sorts on id fields,

if they are visible

since sorting worked before I tried the following:

I am normally using anaconda on windows for testing. 

I have tried different python versions. Actual version is 3.12.8.

I have also tried on a Ubuntu Server 24.04.03 LTS that uses Python verion 3.12.3

It is the same on both systems. Nothing happens when you click on the column header with a sorting symbol.

I have tried with Firefox and Edge.

I am now running out of ideas and hope that one of you can jump in.

any ideas ?

[Dean D. Babic]

I think it is mysql.connector:

https://jampy-docs.readthedocs.io/projects/V7/en/latest/admin/project/database.html

This is mysql on Linux
https://inxczfsg-jampy.hetz-fsn-prod-1.fineupp.com/

[Dean D. Babic]

Oh, sorry, u using MSSQL?
mssql        674       1  3 09:40 ?        00:00:01 /opt/mssql/bin/sqlservr
mssql       1175     674 26 09:40 ?        00:00:06 /opt/mssql/bin/sqlservr

All good on Linux with MSSQL. No idea on Wintel.
MSSQL is way way overkill for such a small app.
Unless u have 1000x users. Even mysql/postgress is overkill.
But thats me.

[Volker Trapp]

Thanks Dean,

I have to use MSSQL since the data from the ERP System is located there.

But still the problem is that nothing happens when you click on a table header that is enabled for sorting ( order )

Any Ideas ?

[Dean D. Babic]

Nope, works just fine. Note the Jam version!

[Dean D. Babic]

Actually, as I see it, I needed to click twice on some columns!

[Volker Trapp]

The Jam Version I am using is 7.0.86.

No matter how I click nothing is happening. 

[Drazen Babic]

Simple.

Install older pymssql, see what happens.

Install older Jam.py, ie 7.0.36 and check.

Etc. 

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/jam-py/bd90fa72-059a-436c-8d9f-9cb1d4da76b8n%40googlegroups.com.

[Tomasz Wrona]

I confirm. Just like you, grid sorting doesn't work for me in MSSQL.

[Tomasz Wrona]

It works though :). I had the sorting specified in the wrong place. The fields to be sorted should be selected in the Sorting field. The sorting should be set in [View Form], not in [Order]

[Volker Trapp]

I have tried 7.0.36 ( actual 7.0.86 ) and pymssql 2.3.0 (actual 2.3.11).

It is the same...

What is the actual recommended python version ? I am using 3.12.3 

[Volker Trapp]

You are right Tomasz.

I have specified the sorting in the wrong place.

Thanks a lot

[Dean D. Babic]

Reminds me of this :)

https://groups.google.com/g/jam-py/c/Nh_3Ptoy-NY/m/YVe4bv_6BAAJ