Prev
Next
Forums Integration / Customization IPA/ProcessFlow

MSGBuilder not returning Query value

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
TracyO
Veteran Member
Posts: 97
Veteran Member
4/30/2008 6:10 PM

    It has been a long time since I have created a new processflow and am having a problem with my MSGBuilder.

    I have a query against ICACTIVITY with a realtationship to ICTRANS ( I need this table to get the operator id).

    I am then sending my MSGBUilder in ane email but am getting a blank where the Operator Id should be populated.

    I have tried this 2 ways and still get blanks:

    The following IC24 records are not released.  Please research:
    User -  Store- Document# -

    and I tried

    The following IC24 records are not released.  Please research:
    User -  Store- Document# -

     

    All the fields except the operator id are being populated on my email.  I am sure this is really basic, I just can not get it figured out.

    Can anyone out

    TracyO
    Veteran Member
    Posts: 97
    Veteran Member
    4/30/2008 6:12 PM

      Here is my query

      My query name is Q1

      PROD=DEV81&FILE=ICACTIVITY&FIELD=COMPANY;LOCATION;DOCUMENT;TRANS-DATE;LINE-NBR;ICTRANS.OPERATOR-ID&OUT=CSV&DELIM=~

      John Henley
      Posts: 3353
      5/1/2008 12:37 PM
        I just tested your query via DME as well as ProcessFlow (LSF9 against 8.0.3 apps), and it works for me (returns the operator ID in the results).
        Try looking at the database via SQL and make sure that 1) you have valid data in ICTRANS for ICACTIVITY records, and 2) the OPERATOR_ID field is populated in ICTRANS for those records.
        Thanks for using the LawsonGuru.com forums!
        John
        TracyO
        Veteran Member
        Posts: 97
        Veteran Member
        5/1/2008 12:42 PM

          John

          Thanks for your help.  It was showing in my query it just was not displaying in my messge builder.  I did figure out late last night my problem was that I have:

          ICTRANS.OPERATOR_ID

          and it should have been

          ICTRANS_OPERATOR_ID

          it was one of those simple stupid mistakes

          Thanks again

          Tracy

          John Henley
          Posts: 3353
          5/1/2008 12:51 PM
            Ah yes. The wacky syntax of ProcessFlow is definitely challenging when going from JavaScript, DME, COBOL, etc. etc. !
            Thanks for using the LawsonGuru.com forums!
            John