LPA message lines? - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Gary Padgett

Veteran Member

Posts: 90

5/21/2014 4:30 PM

We are recreating a report for Audit Department, showing processflow approvals, etc (now LPA approvals). We used to show messages attached to the workunits as well.
We can find the message header info in the PFIMESSAGE table, but where is the detail info for that message? I have been unable to locate it.
Thanks in advance

Woozy

Veteran Member

Posts: 709

New Poster

5/21/2014 6:48 PM

Hi Gary - I assume you're trying to do this via SQL query of some sort. If PFIMESSAGE.MESSAGE field doesn't exist, then try looking in S$PFIME.MESSAGE. If your Landmark server was set up using the SplitLOBs option, then the large object fields are separated from the main table into tables specifically for the LOB fields. You would join the two tables using the UNIQUEID.

Good Luck!

Kelly

Gary Padgett

Veteran Member

Posts: 90

5/21/2014 7:06 PM

Yes, Woozy, you were spot-on. I do see the lines in S$PFIME as you said. I also see several other tables whose names begin with S$PFI as well. For instance, I had wondered where the workunit logs were located - it's S$PFIWU. Now I know where to start looking. Thanks a bunch!

Woozy

Veteran Member

Posts: 709

New Poster

5/21/2014 7:13 PM

Great!

By the way, it can be difficult to determine which "S$" table is related to a "regular" table. The best way I've found is to look at the indexes of the regular table - usually the indexes start with the table prefix (similar to S3), which matches the right side of the S$ table name.