Who's On?

	Membership:
	Latest: Kezia West
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 5246

	People Online:
	Visitors: 483
	Members: 0
	Total: 483

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

HTML/Javascript DME function for LOGAN

3 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Roger French

Veteran Member Send Private Message

Posts: 549

12/3/2010 3:55 PM

I'm doing some portal customizations where I need to use the DME() function. I've used it OK before with application productlines with no issues, but I need to use it to query some LOGAN tables. I've tried various things within the DME function, but it's not working. It is always bombing out on the data.js function. I've reviewed it several times but haven't figured it out yet. Does anyone have an example of a javascript function where it successfully works by querying LOGAN? Do I need to use the object.logan field? Here is a copy of the function I'm trying to use (hey and no laughing too hard ok?)

Thank you... -R function GetMMDistInfo(workUnit,field,seq) { var logancall = new DMEObject("LOGAN", "WFVARIABLE") logancall.out = "JAVASCRIPT" logancall.field = "workunit;variable-name;wf-seq-nbr;variable-value" logancall.index = "wfvset1" logancall.max = "1" logancall.xida = true logancall.key = workUnit + "=" + field + "=" + seq logancall.func = "FinishMMDist()" DME(logancall, "jsreturn") return FinishMMDist() } function FinishMMDist() { var fieldvalue for(var i=0;i; fieldvalue = pObj.variable_value; } return fieldvalue; }

Will Hoover

New Member Send Private Message

Posts: 1

3/18/2011 12:04 PM

[code] function GetMMDistInfo(workUnit,field,seq) { var logancall = new DMEObject("LOGAN", "WFVARIABLE") logancall.out = "JAVASCRIPT" logancall.field = "workunit;variable-name;wf-seq-nbr;variable-value" logancall.index = "wfvset1" logancall.max = "1" logancall.xida = true logancall.key = workUnit + "=" + field + "=" + seq logancall.func = "FinishMMDist()" DME(logancall, "jsreturn") // you cannot return the results from this function -> return FinishMMDist() } function FinishMMDist() { var record1 = window.jsreturn.record[0]; // do something with the 1st record } [/code]

Jeff Pratte

Basic Member Send Private Message

Posts: 13

12/23/2013 7:00 PM

I tried:

function CheckForDupTwo()

{

var workUnit = 0;

var field = 0;

var seq = 0;

//function GetMMDistInfo(workUnit,field,seq) {

var logancall = new DMEObject("LOGAN", "WFVARIABLE")

logancall.out = "JAVASCRIPT"

logancall.field = "workunit;variable-name;wf-seq-nbr;variable-value"

logancall.index = "wfvset1"

logancall.max = "1"

logancall.xida = true

logancall.key = workUnit + "=" + field + "=" + seq

logancall.func = "FinishMMDist()"

DME(logancall, "jsreturn")

// you cannot return the results from this function -> return FinishMMDist()

return thisDup ;

}

function FinishMMDist() {

var record1 = window.jsreturn.record[0];

// do something with the 1st record

alert('jsreturn=' + jsreturn);

} and I got this error message: SCRIPT5009: 'DMEObject' is undefined Can you point me in the direction I should be looking? Thanks, Jeff

Scott Perrier

Veteran Member Send Private Message

Posts: 39

1/31/2014 4:23 PM

Jeff - the code above only works if you are on LAUA security and using the older dme format prior to environment 8.1. it will need to be tweeked to run the latest DME calls. Out=Javascript is no longer used out=XML or CSV are the 2 choices under the new AGS functions. See the developers guide for AGS calls on the support site. I am going through the very same issue now with my customizations. I have my AGS calls working but need to figure out how to process the xml returned.