(SOLVED) I can't get the "time-context List" to sort alphabetically

[aniruddha]

I don't know whether this is an bug or a feature  , but somehow the "time-context List" doesn't sort automatically like the "Space contexts" do. How can I fix this?

[Andrew]

Hi aniruddha,

is this on the page editCat.php?field=time-context ? (menu option configure -> Time contexts)

In config.php, the value of $sort['timecontextselectbox'] is used for sorting:
e.g. ORDER BY timeframe,description

And, of course, in most tables you can just click on a column header to sort by that column.

[aniruddha]

Hi aniruddha,

is this on the page editCat.php?field=time-context ? (menu option configure -> Time contexts)

Yep.

Code:

In config.php, the value of [tt]$sort['timecontextselectbox'][/tt] is used for sorting:
e.g. [tt]ORDER BY timeframe,description[/tt]

And, of course, in most tables you can just click on a column header to sort by that column.

Clicking the column header fixed it. I feel like such a n00b ^^

[Andrew]

And, of course, in most tables you can just click on a column header to sort by that column.

Clicking the column header fixed it. I feel like such a n00b ^^

No worries: I'm much better at programming the features, than documenting their existence

I did try to mention most of the new features in the screencasts on youtube, but I know I didn't cover everything.

For example - here's one more thing I forgot to document.  Say you want to search for actions where you haven't yet assigned a time context.  Go to Process -> Actions.  Tick the 'NOT' box that's just to the right of the Time drop-down box on the top row of the form.  Leave the drop-down on '(any)'.  And press the 'filter' button: and it will show you all the actions that have no time context assigned!

Kind regards,
Andrew

[aniruddha]

Strangely enough when selecting a time option from the dropdown menu in the "Capture  next action" screen it's not in alphabetical order anymore  The context dropdown menu on the other hand is in alphabetical order.

[Andrew]

Strangely enough when selecting a time option from the dropdown menu in the "Capture  next action" screen it's not in alphabetical order anymore 

Sounds like a problem in your config.php file.

Near the bottom of the file there should be a section that looks like this:

Code:

$sort = array(
    "spacecontextselectbox" => "cn.`name` ASC",
...
    "timecontextselectbox"  => "`timeframe` ASC",
...

If the timecontextselectbox line doesn't look like that, please can you change it to that and see if that fixes it?

Andrew

[aniruddha]

Here's the relevant section of my php.config. pPlease note I haven't changed any of these settings:

Code:

$sort = array(
    "spacecontextselectbox" => "cn.`name` ASC",
    "categoryselectbox"     => "c.`category` ASC",
    "checklistselectbox"    => "cl.`title` ASC",
    "listselectbox"         => "l.`title` ASC",
    "parentselectbox"       => "i.`title` ASC",
    "timecontextselectbox"  => "ti.`timeframe` DESC",
    "getlistitems"          => "li.`item` ASC",
    "getitemsandparent"     => "type ASC, ptitle ASC, title ASC, deadline ASC, dateCreated DESC",
    "getorphaneditems"      => "ia.`type` ASC, i.`title` ASC",
    "selectchecklist"       => "cl.`title` ASC",
    "getchecklists"         => "c.`category` ASC",
    "getlists"              => "c.`category` ASC",
    "getchecklistitems"     => "cli.`checked` DESC, cli.`item` ASC",
    "getchildren"           => "its.`dateCompleted` DESC, ia.`deadline` DESC, i.`title` ASC",
    "getitems"              => "i.`title` ASC",
    "getnotes"              => "tk.`date` DESC",
);

[Andrew]

ok .  Is it sorting your time contexts in descending alphabetic order(Z-A)?  If so, then the config value is getting used.  To change it to ascending order (A-Z), just change the line to:

"timecontextselectbox"  => "`timeframe` ASC",

[aniruddha]

I changed the line to:

Code:

"timecontextselectbox"  => "ti.`timeframe` ASC",

And now it' sorting all right. Thanks! What does the DESC parameter mean?

[Andrew]

DESC = descending alphabetic order  (z,y,x,...c,b,a)
ASC = ascending alphabetic order  (a,b,c,...x,y,z)