2. PHPRunner General questions
  3. 51_B1406 Query order not respect in the display
This topic is locked

51_B1406 Query order not respect in the display

 		3/26/2009 19:12:21
PHPRunner General questions
K
 kjp author

Bonjour
I 'd just imported a "5.0" project (working and online) in the last 5.1_b1406
I do a lot of builds, with a complete reset for all pages, deleting the output / temp/visual dir

and clean memory with ccleaner to be sure:
a table with some sorts on columns: (2 minimum)


phpr flow the good display in the query results page:


in my sample, the table is sort:

  1. on the "cumul" column (9e column in the table structure)

    then
  2. on the "concurrent" column (4e in the structure)
  3. on the "num_lic" column (the 2nd in the structure)
    After the build, the arrows are in the good place and in the good direction


BUT the table is sorted with THE FIRST request in the table's struture build...

In my case my 3rd request, which is (unfortunately) the first read by the builder i think...

The 3rd sort's request is only added for the test.
Kjp
K
 		kjp author 3/27/2009

Bonjour
I'd just build a test with only one table...
demo account:

"p51_2"
Table is sorted

  1. cumul (desc)
  2. conc--- (asc)
  3. num_lic (desc)
    PS

    "multiple sorting" works.
    Kjp
J
 		Jane 3/27/2009

Hi,
thank you for pointing me to this bug.

We'll fix it in the next update.
M
 		mlapl1 3/27/2009

Hi,

thank you for pointing me to this bug.

We'll fix it in the next update.


Thank you - when is the next update? I have had the same kind of problem too. The sorting was not carried over properly from 5.0 - when I reset all the sorting it seemed to work but not consistently (at least not that I could discover - I am sure it is consistent but... under what conditions).
I think I will have to revert to PHPRunner 5.0 although I am also keen to contribute to its improvement by testing the beta.
best to everyone

Andrew
K
 		kjp author 4/1/2009

1496 built

is now correct for that point
Thx
K
 		kjp author 4/1/2009

SORRY!
there's still a "displaying problem":
The "original table" has a good dsiplay, (good sorting order and arrows)
BUT NOT the custom's views builded from it:

the table is displayed with no "arrows" indcators, and no sorting
Kjp
J
 		Jane 4/1/2009

Hi,
please make sure you've set up Order By clause for your custom view on the Edit SQL query tab.