Drill Around Customization

 12 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Jay Riddle
Veteran Member
Posts: 191
Veteran Member

     

    We would like to customize the search functionality in a drill around.  As an example when you:

    1. Go into HR11

    2.  Click on the drill for employees

    3.  Click on Search ...

    We would like the Case sensitive check box to default to unchecked and the keyboard focus to be set to the criteria box. 

    John Henley
    Posts: 3353
      That would be a customization to Portal ($WEBDIR/lawson/portal/drilll/AdvSearchTab.js I think); and should be fairly easy to accomplish. Keep in mind that you would need to retrofit it any time you install a Portal update. And that, of course, modifications wouldn't be supported by Lawson. This type of modification would then be used by any form, not just HR11 (although I guess you could code it to just work for HR11...)
      Thanks for using the LawsonGuru.com forums!
      John
      Jay Riddle
      Veteran Member
      Posts: 191
      Veteran Member

        Is there documentation somewhere or information on how to modifiy a .or file in Lawson?

        John Henley
        Posts: 3353
          The syntax is documented in the workbench standards manual.
          Thanks for using the LawsonGuru.com forums!
          John
          Shane Jones
          Veteran Member
          Posts: 460
          Veteran Member
            I looked through the documents in the Drill folder and am not really seeing anything that lists the search default. I thought last time I ask about this someone responded that the default search or search list order was in a "scr" file... I was never able to figure it out before and I still am having difficulty with this.

            I just dont't like that "Last Name" is the default search and it is case sensitive and that it must be complete or I have to enter an asterick as a wild card. (It is just STUPID lawson programming - I swear sometimes the programmers don't think about how a program is used.)

            {{I entered an enhancement request about 2 years ago for easier search and was told that it was enhanced in LSF 9.0. However, we have just implemented our LSF 9.0 in test and I counted the number of clicks in portal and it ACTUALLY TAKES MORE CLICKS TO INQUIRE.... My suggestion was to make the employee number field allow for a "name" or "number" - If I enter an associate number then just open the record; if I enter a name then open a list of the names so I can select from them. Searching for the record you want should be programmed as EASILY as possible "for the user" since we do it over and over all day. Sorry about this - I am just very frustrated with Lawson right now and this topic pushed a button.}}
            Shane Jones
            Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
            Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
            ** Teach others to fish...
            John Henley
            Posts: 3353
              Is there a question in there, or just a vent? :)
              Thanks for using the LawsonGuru.com forums!
              John
              Jay Riddle
              Veteran Member
              Posts: 191
              Veteran Member

                How is the default search set?

                John Henley
                Posts: 3353
                  "Default" meaning what?
                  Thanks for using the LawsonGuru.com forums!
                  John
                  ridjayc
                  Veteran Member
                  Posts: 191
                  Veteran Member
                    Default meaning the first item listed. The default search in HR11 on employees is
                    "* Last Name"

                    I would like to change the default to "Name"
                    Sam Simpson
                    Veteran Member
                    Posts: 239
                    Veteran Member
                      What "Name" are you referring to? LAST-NAME, FIRST-NAME,SHORT-NAME or FULL-NAME?
                      unfortunately the EMPLOYEE table has very limited index file that you can use for drill around.
                      HR11 uses empset6 to drill on "NAME" which is sorted by LAST-NAME, FIRST-NAME,MIDDLE-INIT and EMPLOYEE. If you want to drill on FIRST-NAME as the first sort order then you're out of luck! You will need to create a new index, use that index in the HR.sr file, do srgen then recompile HR11.
                      ridjayc
                      Veteran Member
                      Posts: 191
                      Veteran Member
                        Sorry for the confusion. The name field is already searchable I just want it to be the default search. For instance right now the search dropdown has listed in it
                        * Last Name
                        Name
                        Employee
                        Social Nbr
                        ...

                        I just want it to default to Name instead of * Last Name
                        Sam Simpson
                        Veteran Member
                        Posts: 239
                        Veteran Member
                          The Name you are referring to is actually FIRST-NAME field from Employee table. As mentioned before, you're out of luck. You will have to create a new index for employee table then use that in HR.sr file
                          (the .sr id is HR-EMP-S-0056. You will notice this at the top of your drill screen).
                          John Henley
                          Posts: 3353
                            Jay,
                            What you would need to do is change HR.sr (and PR.sr, PA.sr, BN.sr, etc.) for each desired drill rule.
                            Change the order of the DSPFLDS & FNDFLDS to your liking.

                            In this example, I'm swapping 'Name' and 'Employee' so that 'Employee' shows first.
                            Old:


                            New:


                            Then run srgen and IOSCacheRefresh.

                            Realize that this is version-specific--like Sam, I don't see that particular order (* Last Name, Name, Employee ...) in either 8.0.x apps or 9.0.x apps.
                            But in any event, this is how you would change it...

                            Now, the normal warning about modifications applies...these changes will need to be retrofitted when MSPs (and possibly CTPs) are installed.
                            Thanks for using the LawsonGuru.com forums!
                            John