Creating an IDO with a stored procedure as source

Hi all, hope this is the correct group to ask this.

Does anyone know of any tutorials or help docs which clearly show how to use a SQL Stored Procedure as the data source without a base table?

When creating an IDO it requires a Table name.. but there's no base table for the IDO because all data is coming out of the stored procedure..

If I try to "Fake it out" and put a table in, then I can only see the fields from the table and not the output fields from the stored procedure in Properties.

I've looked at some of the base SyteLine IDOs which do this... but I've been able to replicate.. they somehow use a table called ReportDataView which doesn't appear to be an actual table or view.

Thanks for any help I can get!

Matt

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

To do this, you are best to create a SQL table that matches the return values of your SP. Then you need to create a method attached to the IDO that maps the SQL Table/IDO Properties to the return values of the stored procedure.

Lawson User Experience v10.1.pdf

Legacy Contributor

Matt, were you ever able to get this to work? I've been struggling myself to get this to work...I would be interested to connect if you've had better look or have found some relief on getting this to work successfully? This seems like a simple thing and I also see it working Base Syteline IDO/DV but I can't get it to work myself

Glenn

Legacy Contributor

You don't specify it as a table, you select ReportDataView in the Extends box which automatically grays out the table box. You don't check the Replace check box (which effectively makes your IDO a copy of the ReportDataView IDO). Then you have to specify properties for the return columns of your SP as unbound IDO Properties. Then you add your stored procedure as a Custom Load Method IDO Method in your new IDO. You add the properties you created as output properties on IDO Method form.

Copyright © 2025 Infor. All rights reserved.