Prev
Next
Forums Integration / Customization S3 Customization/Development

Sort File for Online Update Form?

 7 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Woozy
Veteran Member
Posts: 709
Veteran Member
2/5/2014 8:30 PM
    We have a customized online update form (copy of BS31 - Web Pending Benefit Enrollments), and the business would like to have this custom form sorted by StartDate/PlanType/PlanCode rather than PlanType/PlanCode/StartDate.  The source table is BNBEN which does not have an index the matches their request.

    Is it possible and reasonable to use a sort file to re-sequence the data for an online update form like this?  I'm thinking "no", but thought I'd ask the question.

    Does anyone have a better suggestion?

    Thanks!

    Kelly
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    jaherb
    Veteran Member
    Posts: 164
    Veteran Member
    2/5/2014 10:01 PM
      Kelly.... typically with on-line forms, it is the index that drives the sort order of the data on the screen. I had a project like this once and we had to add a new index to get the sequence we needed.
      John Henley
      Posts: 3353
      2/5/2014 10:29 PM
        The other option in addition to creating a custom index and using that rather than BNBSET1 would be to use an ISAM work file. While more code-intensive, since it is localized to your custom version of BS32, it does remove a database table customization dependency that needs to be maintained from version to version.
        Thanks for using the LawsonGuru.com forums!
        John
        Woozy
        Veteran Member
        Posts: 709
        Veteran Member
        2/6/2014 2:28 PM
          Thanks Jim and John. I like the idea of a custom index a little better, even though we have to manage it during patching/upgrades. We have a number of other mods we already have to check and retrofit, so I think we can add this to the list of post-patch checks. I'm sure a sort file would work but it would be quite a significant rewrite for a fairly low-value mod (in the greater scheme of things).

          I appreciate the feedback!

          Kelly
          Kelly Meade
          J. R. Simplot Company
          Boise, ID
          jaherb
          Veteran Member
          Posts: 164
          Veteran Member
          2/6/2014 4:50 PM
            Kelly.... If you go with a new Index, be sure to start with a high number to avoid possible issues with future Lawson releases..... such as BNBEN99
            Woozy
            Veteran Member
            Posts: 709
            Veteran Member
            2/6/2014 5:10 PM
              Thanks Jim. That's what I was planning. I remember reading that recommendation somewhere...
              Kelly Meade
              J. R. Simplot Company
              Boise, ID
              John Henley
              Posts: 3353
              2/6/2014 6:06 PM
                Posted By jaherb on 02/06/2014 11:50 AM
                Kelly.... If you go with a new Index, be sure to start with a high number to avoid possible issues with future Lawson releases..... such as BNBEN99


                Actually it would be BNBSET99.

                There is actually some environment code that requires the xxxSETyy naming convention.
                I had a client that used IDX instead of SET and had to change it when they upgraded from v8 to v9 !!
                Thanks for using the LawsonGuru.com forums!
                John
                jaherb
                Veteran Member
                Posts: 164
                Veteran Member
                2/6/2014 6:07 PM
                  Super