Shared Files default sort order

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
11/2/2009 9:47:56 AM
kevinD
Gravatar
Total Posts 51
View Posts

Shared Files default sort order

Running mojo v2.3.1.9, MSSQL 05

Wondering if there is an easy way to configure the default sort column on the Shared Files feature.  I was poking around in the ShareFilesModule.ascx page, but found no default sort setting (other than the allowsorting setting, but that's not what I need.)  Went back to the DB itself and it looks like it's displaying files by ItemID by default.

Does anyone have a way to set the default to the Friendly name?

11/4/2009 3:43:12 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Shared Files default sort order

Hi Kevin,

I've fixed this for the next release so that it sorts by file or folder name as is true in file systems.

This bug actually only affected MS SQL, the other databases already had the correct sort.

Thanks,

Joe

3/22/2010 10:58:23 AM
dvandenh
Gravatar
Total Posts 55
View Posts

Re: Shared Files default sort order

Joe,

Using 2.3.3.6 MSSQL

I see the sort order default setting, but now files are all sorted by filename. I thought prior to this, files were sorted by orginal upload date. Could that still be an option in the future?

Thanks

Derek

3/23/2010 7:10:43 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Shared Files default sort order

Hi Derek,

Actually the problem was that the MS SQL procedure previously had no ORDER BY clause at all, so if it was sorting by upload date that was just happenstance. The feature was intended to sort like a file system and all other db layers had the correct ORDER BY.

Since we are listing folders and files in the same grid, I don't see an easy way to make it sort by upload date since folders don't have upload dates.

My recommendation is to name the files in a way that makes them sort as you would like, ie somefile-2010-03-23.pdf, somefile-2010-03-22.pdf, etc.

Hope it helps,

Joe

5/20/2010 9:06:35 AM
MongooseNX
Gravatar
Total Posts 6
View Posts

Re: Shared Files default sort order

Is there a way to get the sub folders to end up at the top of the grid like a file system?

Thanks

Robert

5/20/2010 9:55:15 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Shared Files default sort order

I've put it on my TODO list to look into implementing a separate sort for folders vs files

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.