Sorting a portal

[dailo]

I have a portal setup and I thought it was sorting correctly, but I guess not. Its probably an error on my part so maybe there is something wrong with my logic.

Right now this is the order:

1. sort prioirty by custom values

2. sort by assigned (created) date by ascending order

3. sort by modified time by by ascending order

Basically its a queue for things that need to be done and priority is working fine, when set to high it goes right to the top. However for some reason it doesn't sort it correctly by modified time. I want the most recently modified item to be sorted to the bottom for that day. Currently everythign is sorted correctly by date and priority, but for some reason when I modify an item it doesn't move to the bottom of the queue for that day, instead it just moves to the middle. Any ideas why this may be happening? I checked the modified times and they are correct. Does assigned date have a time value stored as well? any help would be appreciated.

[Ugo DI LUCA]

Nope. Not on my side.

sorting.zip

[dailo]

Does indexing effect it at all? I noticed that my modified time field is indexed. I don't understand why it would sort would have the following order with my order. I checked the fields and it is sorting 3:23PM, 9:42AM, 2:21PM doesn't make any sense at all!

Does it not look at the AM and PM?!

[Ugo DI LUCA]

Indexing shouldn't be a problem at all.

Is it possible that you post a cloned copy of your files. It may be a relationship problem or that the field in the portal doesn't come from this same relationship.

[dailo]

I am working remotely so I don't have access to save a copy of it, but I pretty much just took this database and added a bunch of customized things to it.

http://www.bigabytes.net/ITJournalLite/index.php

All the relationships should be the same, except for him he just set it to that open tickets sourts by ticket number, while I'm sorting by priority, modified date, and modified time. Thanks for your help!

[Ugo DI LUCA]

Oh Oh....may be

You defined the sort into the portal box as we did when in version 6.

Try opening the Relationship Graph view, double click into the square in between the tables and use the Sort options there to see if this changes.

At least check for both settings to see if they both match and if something is wrong in there.

[dailo]

Thanks a lot that fixed it, didn't know I could sort in the tables themselves. Thanks a lot!!