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:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5162
People Online:
Visitors:
224
Members:
0
Total:
224
Online Now:
New Topics
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 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.