Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

$4.95 Windows Hosting at Webhost4life.com
  Ads  
 


  Sponsors  

Meet Our Sponsors

The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Documents Modul...  Sort Order not working... apparently.
Previous Previous
 
Next Next
New Post 4/14/2008 6:06 AM
User is offline Duncan Ion
12 posts
10th Ranked


Sort Order not working... apparently. 

Hi,

I have a Doc module [4.0.0] installed with a number of documents in it.

Each Document has a Sort index [100,200,300 etc.. - the gaps to allow for intermediary files to be inserted at a leter time....]

I have added a sort index [ascending] to the module.

 

It doesn't work.......

 

Any suggestions?

[Installed DNN: 4.8.2]

 
New Post 4/14/2008 12:58 PM
User is offline Mitch Sellers
5719 posts
www.mitchelsellers.com
3rd Ranked




Re: Sort Order not working... apparently. 

Duncan,

I'm sorry but this is an issue that was introducted with the new version of the module.

At the current time I am unaware of an ETA for resolution.


-Mitchel Sellers
MCITP, MCPD, MCTS
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Consulting Quotes, and DNN Technical Support Services

I reccomend 3Essentials for shared hosting and BaseCamp for project management
 
New Post 4/23/2008 7:45 AM
User is offline JHughes
30 posts
10th Ranked


Re: Sort Order not working... apparently. 

Thanks for the update Mitch.  Hopefully whle that  issue is resolved, the ability to change the precendence or the sorts will be added.

Duncan,  I really needed to control this as well.  There is a work around if your willing to hack the stored procedure.

Goto: <databasename>\Programmability\Stored Procedures
Modify: GetDocument

The last line states 'Order by Documents.Title'

Change that to 'Order by Documents.SortOrderIndex'

This should resolve your issue.

You can modify the Order By to fit your sort needs.  For Example 'ORDER by Documents.Category asc, Documents.Title asc'

-Jeff

 
New Post 6/4/2008 1:14 PM
User is offline JHughes
30 posts
10th Ranked


Re: Sort Order not working... apparently. 

The Stored Procedure for this is actually: Modify: GetDocuments

 JHughes wrote

Thanks for the update Mitch.  Hopefully whle that  issue is resolved, the ability to change the precendence or the sorts will be added.

Duncan,  I really needed to control this as well.  There is a work around if your willing to hack the stored procedure.

Goto: \Programmability\Stored Procedures
Modify: GetDocument

The last line states 'Order by Documents.Title'

Change that to 'Order by Documents.SortOrderIndex'

This should resolve your issue.

You can modify the Order By to fit your sort needs.  For Example 'ORDER by Documents.Category asc, Documents.Title asc'

-Jeff

 
New Post 6/15/2008 5:16 AM
User is offline Duncan Ion
12 posts
10th Ranked


Re: Sort Order not working... apparently. 

Jeff,

Did that - works - Thanks!

 

One small point - [for others who read this]..... the Stored Procedure is GetDocuments

 

regards,
Duncan.

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Documents Modul...  Sort Order not working... apparently.
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Lucede Systems Group
Providing a full range of IT services for large and medium sized companies
www.lucede.com
Adaptive InfoSystems, Inc.
We provide custom programming and various levels of support for DotNetNuke and the .Net framework.
www.aisysweb.com
Multipartner Virtual Data Rooms
The Virtual Data Rooms (VDR) provided by an expert advisor, far from any ordinary software company!, supporting the sellers and their consultants. Multipartner builds and services higly professional Virtual Data Rooms (VDR) specifically tailored to M&A, Real Estate and NPL deals.
www.multipartner.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP