OracleSiteMapProvider sorts based on insert order

OracleSiteMapProvider sorts based on insert order

Postby rcuirle » Wed 29 Jul 2009 15:26

It appears that there is no control over the order in which sitemap nodes are displayed. It always orders (within a parentnodeid) based on the order in which the records were inserted. This isn't optimal. Every time the sitemap nodes change, I have to modify a sql script to trunc the table and reinsert the nodes in the correct order.

Please add an OrderID column (or something) that allows user control over the return result set.

Example insert sets:
Code: Select all
truncate table aspnet_sitemap;
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (1, '/EPIC', 'Default.aspx', 'Main',  'Home Page', NULL, NULL);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (25, '/EPIC', 'Dashboards/Default.aspx', 'Dashboards', 'Summary Pages for various roles.', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (50, '/EPIC', 'Wizards/Default.aspx', 'Wizards', 'Wizards Menu Top Level', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (100, '/EPIC', 'Help/Default.aspx', 'Help', 'Help Main Menu', NULL, 1);
COMMIT;


vs.

Code: Select all
truncate table aspnet_sitemap;
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (1, '/EPIC', 'Default.aspx', 'Main',  'Home Page', NULL, NULL);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (25, '/EPIC', 'Dashboards/Default.aspx', 'Dashboards', 'Summary Pages for various roles.', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (100, '/EPIC', 'Help/Default.aspx', 'Help', 'Help Main Menu', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (50, '/EPIC', 'Wizards/Default.aspx', 'Wizards', 'Wizards Menu Top Level', NULL, 1);
COMMIT;
rcuirle
 
Posts: 1
Joined: Wed 29 Jul 2009 13:29
Location: Akron, OH

Postby Shalex » Fri 31 Jul 2009 09:26

We will fix this issue. Look forward to the next build of dotConnect for Oracle.
Shalex
Devart Team
 
Posts: 7713
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Mon 16 Nov 2009 16:20

We have added the orderid column for the Site Map provider for custom map node ordering. Look forward to the next build of dotConnect for Oracle. I will post here when it is available for download.
Shalex
Devart Team
 
Posts: 7713
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Fri 20 Nov 2009 16:22

dotConnect for Oracle v 5.35 is released.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=16436.
Shalex
Devart Team
 
Posts: 7713
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle