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
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
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
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