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.
Add Account timeline (currently in Web client) to Windows/Lan client.
Embed in web control in Account tab.. ? also handle error if portal not deployed.. e.g. this is not avialable please contact your system admin who can deploy your web portals for this to work..
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