2. PHPRunner General questions
  3. Sort by job number
This topic is locked

Sort by job number

 		1/19/2008 9:46:39 AM
PHPRunner General questions
S
 swanside author

Hello.

When I open my database main page and look at the jobs which are in the job table, they are displayed by Job_No but it tarts with the first one which is 10000000.

We are up to 10033489, and is on the last page, but every time we start a new job, it inserts it into the end of the page. Is there a way to display the jobs by the last insert, so the first one to see will be 10033489 and not 10000000?
Cheers
E
 		ewold 1/19/2008

Hello.

When I open my database main page and look at the jobs which are in the job table, they are displayed by Job_No but it tarts with the first one which is 10000000.

We are up to 10033489, and is on the last page, but every time we start a new job, it inserts it into the end of the page. Is there a way to display the jobs by the last insert, so the first one to see will be 10033489 and not 10000000?
Cheers


Set this in the "Edit SQL Query" tab in the field "Order by on the list page" or click on change... to make your own.

Even in the list page you can click on the Job_No field and normally il will be sorted asc or desc marked with an arrow.

ORDER BY `Job_No` DESC
S
 		swanside author 1/19/2008

Cheers

I did ORDER BY `Job_No` DESC as they are in vertical layout.
Thanks