Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 52
	Members: 0
	Total: 52

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

Get Field Translation in DME Query

4 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Woozy

Veteran Member

Posts: 709

7/7/2010 6:53 PM

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

jrbledsoe001

Veteran Member

Posts: 91

7/8/2010 12:45 PM

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

Posts: 709

7/8/2010 1:13 PM

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

John Henley

Posts: 3353

7/8/2010 1:26 PM

Use
WF-STATUS,xlt
instead of
WF-STATUS
and it will return the translation

Woozy

Veteran Member

Posts: 709

7/8/2010 1:30 PM

UGH! I knew it was something simple. Thanks John!