in the page builder in admin panel pages are not alphabetical

When you are editing pages in the builder section of the admin panel, the pages are not listed in alpha order, this makes it easier for ME to find them.

in the file inc/classes/BxDolPageViewAdmin.php

around line 416 find

function getPages() {

$sPagesQuery = "SELECT `Name`, `Title` FROM `{$this -> sDBTable}_pages` ORDER BY `Order`";

CHANGE THE $sPagesQuery TO READ

$sPagesQuery = "SELECT `Name`, `Title` FROM `{$this -> sDBTable}_pages` ORDER BY `Title` ASC";

Thank you for making it easier

Thanks for sharing

This doesn't work in 7.0.9 does anyone know how to fix this?

 verified as working:

 good work steve, you posted this hack nearly a year ago, and its still working. 

Sometimes I do good things with dolphin.  LOL!

Do you think it would be safe to edit the  Title  column in sys_page_compose_pages ?

Some of the titles are ambiguous... for example, I have a title simply stating "Search" when it should be "Docs Search" (for the document module).

Okay I tried this again and yes it does work.

Would something similar be applicable to displaying Groups?

The newest->oldest is weird.

Alpha makes better sense.

Of course, the best would be drag-drop arrange, but...

I have actually gone thru quite of a bit of the database stuff and add the ORDER BY parameter to a LOT of things.

I've even gone so far as to order your friends list in the mail application by alpha.

One of the things I've been playing with is sorting by avatar 1st, then alpha.

Or even sorting by last visit alpha per visit date.

I am just a logical orderly person and need things in an order to make sense. 

Just run down any code that reads from the database and make sure you modify the ORDER BY.

Thanks Steve.. it is avery helpful hack :-)

I tried doing an Ordering for the Inactive and Sample items, but it didn't quite work out ....

 function loadInactiveBlocks() {
  //get inactive blocks and samples
  $sQueryInactive = "
   SELECT
    `ID`,
    `Caption`
   FROM `{$this -> oParent -> sDBTable}`
   WHERE
    `Page` = '{$this -> sName_db}' AND
    `Column` = 0
    ORDER BY 'Caption'
  ";
  
  $sQuerySamples = "
   SELECT
    `ID`,
    `Caption`
   FROM `{$this -> oParent -> sDBTable}`
   WHERE
    `Func` = 'Sample'
    ORDER BY 'Caption'
  ";

the Navigation Menu area in the Admin gets very cluttered and takes a while for one to search through the Items.... and the same in the Page Blocks too..

Any modfications you have done in these areas ? If so, pls share... Much Thanks :-)

Works perfectly for 7.1.2 - thanks again for posting a solution.