Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
New Idea

Clicking on the caption header of a grid allows the user to sort the grid. SLX does this on the Server using an appended ORDER BY clause to the executed SQL statement. The SLX OLE DB Provider also rechecks for SECCODE and Field Level Security on the records.

 

AGAIN.

 

Yep. When you load the grid SLX checks for SECCODE and Field Level Security on the records.  And when you sort on the server it rechecks the already checked data that has been loaded to the grid previously.

 

This works fine for up to around 1,500 records. After that, sorting takes a very long time for complex ACCOUNTID/PARENTID hierarchy joins, etc for Non ADMIN users.

 Try an 8,000 record grid sort and then come back from lunch for the results.

Instead.....

 

Do a client side recordset  sort.....

Grid.RecordSet.SORT "ACCOUNT Asc"

 

Wickedly fast as compared to the SLX serverside recheck the already checked SECCODE ORDER BY sort.....

And then refresh the grid by recordset (instead of SQL):

SET Grid.RecordSet = Grid.RecordSet

 

Yes, we've got the code to do all of this, but would be much better if it went native in the control itself instead of trapping MouseDown, MouseUp and grid HitType's.

 

 

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels