PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/28/2016 1:21 PM by  brainet
Application Links
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Robby
Sr. Technology Consultant
Avaap
Veteran Member
(209 points)
Veteran Member
Posts:87


Send Message:

--
02/06/2012 4:54 PM
    Do you have some time to help a 'rookie'? I've built lots of Smart Notes, but have never incorporated an application link. Let's say I build a simple notification based on HR11 information and I want the Details link to take the recipient to HR11, already inquired on the company/employee in the row from the infoset. When I build the infoset, and get to step 3 adding an application link, there are 4 items to add, Name (just create a name for the link?), Class (URL?), Tag -this is the major part I don't understand....and lastly Class (Cell, Range or Both)

    I think I could get this if I really understood the parts of the tag statement.....can someone give me a simple example, and where I get the info from?

    This is to be a link to Portal, and I don't have access to a Lawson Web Integration tool as suggested in the Lawson SN User Guide.
    ajn
    Private
    Private
    Basic Member
    (28 points)
    Basic Member
    Posts:10


    Send Message:

    --
    01/12/2016 4:32 PM
    I understand this is an old post but I have the same questions and don't see them answered anywhere. Robby did you figure out how to accomplish your task? Details would be appreciated as I am trying to do the same thing and am not sure what to plug into all the boxes. Thanks.
    Robby
    Sr. Technology Consultant
    Avaap
    Veteran Member
    (209 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    01/13/2016 2:28 PM
    I did find a way to make this happen, but I know there must be a better way. I've documented below the detailed instructions, but caution you that this way does have its issues, like---moving an InfoSet with these links from DEV to PROD, you basically have to rebuild the link from scratch. I know there has to be a way to code the URL so that it will dynamically find the correct server...
    To create the link, click on the words “Application Link”



    Name: Use a unique name for each infoset-link.
    Class: Always “URL”
    Tag:

    https://<<databaseURL>>/lawson/portal/index.htm?TKN=PA02.1&_HK=[COMPANY][POSITION]
    Note: replace 'PA02.1' with whatever form you want to go to-some forms are tougher to get to and might not "inquire" fully.

    The section “[COMPANY][EMPLOYEE]” indicates the fields in the InfoSet to use to ‘Inquire’ on the Lawson form.
    When building an InfoSet to use with a link to the Lawson form, the data which will be used to inquire on the form must be formatted correctly,

    Example: The field ‘Company’ is not just the numbers ‘99’, it is really a 4 place character, and is actually treated as text by the form, so the InfoSet ‘output’ must be ‘0099’, which in SQL is
    LPAD((TO_CHAR(T1.COMPANY,'FM0000')),4,'0') "COMPANY"

    Employee would be represented as:
    LPAD((TO_CHAR(T1.EMPLOYEE,'FM000000000')),9,'0') "EMPLOYEE"

    Another note: While training this last section to some folks, I think we were able to make it work without being too specific with the formatting, use a little trial and error here.

    Hope this helps!
    Robby
    ajn
    Private
    Private
    Basic Member
    (28 points)
    Basic Member
    Posts:10


    Send Message:

    --
    01/14/2016 10:23 AM
    Robby, Thanks for the quick reply and detailed instructions. I will revisit my smartnote soon to try out your instructions.
    brainet
    Private
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:18


    Send Message:

    --
    04/28/2016 1:21 PM
    I was trying to do the same thing with a smart note but the form AP52 need four fields passed to it and made it hard to get the key right. I built the key in the SQL statement and had to pass one field from the info set.
    https://<<databaseURL>>/lawson/portal/index.htm?_PDL=PROD&_TKN=AP52.1&_HK=[HKEY]
    You are not authorized to post a reply.