Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Enterprise Resource Planning & Manufacturing
Lawson S3 Procurement
call a stored procedure and pass the result to recsum
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
181
Members:
0
Total:
181
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
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
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
1351
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 Procurement
call a stored procedure and pass the result to recsum
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Kristi_ANTHC
New Member
Posts: 3
1/11/2019 7:01 PM
I have been tasked with adding a link (which is the result of a SQL stored procedure from a non-lawson database) to our Requisition tasks. I need to use recsum.htm to render the tasks. I can use a SQL node in the Req IPA to call the stored procedure, however I haven't been able to find a way to pass the resulting link as a parameter to recsum.htm. Does anyone know of a way to do this?
I suspect the best option is to call the SQL stored procedure from recsum.htm via a custom cgi or .NET script. Does anyone have experience with this approach in an Infor/Lawson environment?
I thought of maybe calling the stored procedure from the IPA and storing the result in a custom table, then using a DME object in recsum.htm to retrieve it, however I have no idea how to make a custom table accessible to a DME object, or if that is even possible. Does anyone have feedback regarding this approach?
Alternatively I have attempted to pull the HTML and javascript logic out of the recsum.htm file and put it in the Req IPA (putting the HTML in the User Action node and the javascript in an Assign node and then sort of combining them in the User Action node) however after several frustrating days I get the feeling this is not a viable option. Does anyone have experience with this approach?
Any ideas are welcome, and I sincerely Thank You for your time!
Tags:
recsum custom DME parameter stored procedure
You are not authorized to post a reply.