Modifying vendor defined custom load IDO methods that return record sets.

Has anyone successfully modified the number of fields that are returned by a Mongoose Custom Load IDO method that returns a record set that is displayed on a form or dataview or report? For instance in Syteline there is a form called "Compnent Shortages APS". The collection for that form is SLShortages. In that IDO there is a stored procedure that returns the record set to the unbound fields on that form. I want more fields to be returned from that stored procedure. Is there a way to do that without modifying Infor's stored procedure or replicating and replacing the stored procedure?

Find more posts tagged with

Accepted answers

Legacy Contributor

I don't see any way around modifying the SP if you want the SP to return more fields However, if its not necessary that the SP return those fields you could always make a derived field on the IDO. SLShortages is a base syteline IDO so you would need to extend and replace it. Then add the derived field to your new IDO. Out of curiosity what are you trying to add?

All comments

Legacy Contributor

You are correct that I had to modify the stored procedure to add fields from various tables, like operation #, Vendor, work center, etc. Derived fields wouldn't work because I need the results returned as a record set for the form. Thank you for confirming that the SP must be modified.

Stephen Cena

If you're looking to avoid modifying the SP directly, you *could* do it but it's not going to be clean:

You could write an IDO Extension Class method & swap the Custom Load method out for that. Inside the IDO Ext Class, you could make a direct call to the original SP & pull the data back that way & then add onto the columns you want to return.

Again; it's not a pretty solution but it would work.

Legacy Contributor

That would work also. Thank you for the suggestion.

Legacy Contributor

See video #5 in this series

www.youtube.com/playlist

Legacy Contributor

Thank you for the link.

Copyright © 2025 Infor. All rights reserved.