Get Field Translation in DME Query

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
I'm building a DME query against the LOGAN WFWORKUNIT table. I want to include the description of the WF-STATUS field values (which are setup in dbdef), but I can't figure out how to do it.

Is there some trick to including the descriptions in the query?

/servlet/Router/Data/Erp?PROD=LOGAN&FILE=WFWORKUNIT&FIELD=WORKUNIT;WORK-TITLE;PROCESS-NAME;WF-STATUS;WF-RM-ID;&OUT=XML

Thanks! Kelly
Kelly Meade
J. R. Simplot Company
Boise, ID
Deleted User
New Member Send Private Message
Posts: 0
New Member
Hi Woozy,

Which description do you need? Example if you inquire on the work unit in process flow admistrator which form and field.
Please send me an e-mail, I would like your help on getting a dme working. joanna.bledsoe@jhsmh.org Go Broncos!!
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
Hi Joanna,

In PFlow Admin, if you go to "WorkUnit" and inquire on a specific WU, I'm trying to get the Status Description. On the WorkUnit screen this appears as something like "4 - Processing Completed", but in the table it only stores "4". I really would like to include the translation in my DME.

I checked dbdef LOGAN WF WFWORKUNIT and the WF-STATUS field has translations - i just don't know how to pull them out in a DME.

Thanks!

Kelly
Kelly Meade
J. R. Simplot Company
Boise, ID
John Henley
Send Private Message
Posts: 3351
Use
WF-STATUS,xlt
instead of
WF-STATUS
and it will return the translation
Thanks for using the LawsonGuru.com forums!
John
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
UGH! I knew it was something simple. Thanks John!
Kelly Meade
J. R. Simplot Company
Boise, ID