Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Human Capital Management
Lawson S3 HR/Payroll/Benefits
I need an example of home-made javascript DMEObj for Self-service centers
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
chaoticist
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
342
Members:
0
Total:
342
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 HR/Payroll/Benefits
I need an example of home-made javascript DMEObj for Self-service centers
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Mike Schlenk
Veteran Member
Posts: 71
2/22/2008 3:33 PM
In an attempt to supplement self-service centers, I'm looking to create my own htm files that authenticate, create a DME call and display data.
I'm trying to learn from recsum.htm and paytyear.htm and I'm having problems. The issue is when I make a call that returns multiple records, then I want to display each field in a table.
Can someone please help? I'm so close, I know I'm just not understanding something about the DMEObject and how to use Arrays to store the records.
Any help would be appreciated.
ridjayc
Veteran Member
Posts: 191
2/22/2008 4:40 PM
Here is an example. The XXREQNOTES is a custom view. It lets us view note data in a simple way. There some special javascript call to get the notes but I didn't want to spend several days figuring it out so I did this view and used DME on it.
Oh one other little gotcha, if memory serves me, is that if you do change execs for process flow viewing they for some reason need to have the "...recsum.." in the file name.
On a related topic if you would like to do views and have it availbe in Lawson there is a document on Lawson on how to do it in Oracle. We are on SQL server here but the process is very simular. If your DBAs are very difficult to work with then I would skip the views and just try to work around it. Also view creation can require you to bounce Lawson.
--JayR
//Functions-------------------------------------------------------------------------------------------
/************************************************************
Function: LoadCatcher
Purpose: Driver function called by frameset onLoad event driver
************************************************************/
function LoadCatcher()
{
GetMessages()
clearTimeout(LoadTimer);
}
/************************************************************
Function: GetMessages
Purpose: Get Account Information
************************************************************/
function GetMessages()
{
//alert("GOT HERE")
var logancall = new DMEObject(prodline, "XXREQNOTES")
logancall.out = "JAVASCRIPT"
logancall.field ="note-name;modified-user;create-user;object1;object2;object-type"
logancall.select = "company=" + m_Company + "&req-number=" + m_ReqNumber + "&line-nbr=" + m_LineNbr
logancall.func = "displayNotes()"
DME(logancall, "PRODLINE")
PRODLINEwin = self.PRODLINE
}
/************************************************************
Function: displayNotes
Purpose: Display the Requisition summary info via HTML
************************************************************/
function displayNotes()
{
//alert("START display")
var str = '' + ''
+ ''
var TableBorder = HtmlTableBorder
var TableBgColor = HtmlTableBgColor
var ThBgColor = HtmlThBgColor
str = '
'
+ '
'
+ '
' + 'Note Name' + '
'
+ '
' + 'Note Type' + '
'
+ '
' + 'Created By' + '
'
+ '
' + 'Modified By' + '
'
+ '
' + 'Comments' + '
'
+ '
'
// This next section of code is to group notes that are alike together.
var type_array = new Array();
var i = 0
var max_spin = 0
PRODLINEwin.record.sort(note_sort)
type_array[i] = '[' + strNoteType(PRODLINEwin.record[i].object_type) + ']'
while(i + 1 < PRODLINEwin.NbrRecs && max_spin < 100)
{
max_spin++
type_array[i] = '[' + strNoteType(PRODLINEwin.record[i].object_type) + ']'
type_array[i+1] = '[' + strNoteType(PRODLINEwin.record[i+1].object_type) + ']'
var c1 = PRODLINEwin.record[i].note_name + PRODLINEwin.record[i].create_user + PRODLINEwin.record[i].modified_user + PRODLINEwin.record[i].object1 + PRODLINEwin.record[i].object2
var c2 = PRODLINEwin.record[i+1].note_name + PRODLINEwin.record[i+1].create_user + PRODLINEwin.record[i+1].modified_user + PRODLINEwin.record[i+1].object1 + PRODLINEwin.record[i+1].object2
if(c1 == c2) //Basically if truee then notes are the same and will be grouped
{
type_array[i] += '
' + type_array[i+1]
PRODLINEwin.record.splice(i+1,1)
PRODLINEwin.NbrRecs--
type_array.splice(i+1,1)
continue
}
i++
}
for(var i=0;i< PRODLINEwin.NbrRecs;i++)
{
//logancall.field ="note-name;modified_user;object1;object2;object-type"
var note_name = PRODLINEwin.record[i].note_name
var note_type = type_array[i]
var created_by = strCleanUser(PRODLINEwin.record[i].create_user)
var modified_by = strCleanUser(PRODLINEwin.record[i].modified_user)
var comment = PRODLINEwin.record[i].object1 + PRODLINEwin.record[i].object2
comment = comment.replace(/EOL/g,'
')
str += '
'
+ '
' + PRODLINEwin.record[i].note_name + '
'
+ '
' + note_type + '
'
+ '
' + created_by + '
'
+ '
' + modified_by + '
'
+ '
' + comment + '
'
+ '
'
}
str += '
'
+ '