Fix Sorting of Notes/History tab in SalesLogix 6.2

I received an e-mail this morning from Richard Weck of Harris Technology regarding a fix to the Notes/History tab in SalesLogix 6.2 Gold Release. Basically the sorting is broken. Below is the e-mail from Richard and the steps to fix the problem.

The released 6.2 Notes-History tabs have a defect in them (1-35550) in which all history is sorted by TYPE.  The sort should be by COMPLETEDDATE.  This was discovered in RC3 but NOT fixed before release.  Tim Montgomery reported that you could change the sort property under the COLUMNS property of the grid and it should work.  Well, I can report that this will not make the sort work properly.

I have discovered a line in the code that is turning the column sorts off right after the order by clause is established.  It can be found in the CommonCheckBoxChange method in the “Notes-History Common” script.  See the line commented out below.

For i = 0 To grdHistory.Columns.Count - 1
    Set col = grdHistory.Columns.Item(i)
    If col.Sorted <> 0 Then
        If col.Sorted = 1 Then
            strGridSQL = strGridSQL & " Order By " & col.FieldName & " Desc"
        Else
            strGridSQL = strGridSQL & " Order By " & col.FieldName & " Asc"
        End If
        'col.Sorted = 0 'This line was commented out by Harris Technology
        Exit For
    End If
Next

Anyway, I have created a bundle that is free for your use, at your own risk, etc.  No warranties, implied or expressed, are provided.  Included are the
above mentioned script and the A/C/O Notes history tabs with the sort set for COMPLETEDDATE DESC. Thanks Richard!

Download the fixed tab in a bundle

ABOUT THE AUTHOR

Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix, now Infor CRM, since 2001 and believes in sharing with the community. His new passion for CRM is Creatio, formerly bpm'online. He loves C#, Javascript, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

1 Comment

  1. That was a great help, had users complaining about this and could not wait for SP1.

    Thanks,

    Lawrence Smith

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!