Good Morning,
I need to create a new function to use as a derived field on an IDO.
Has anyone come up a with a way to accomplish this in the MT Cloud?
Thanks
Jeff
Capability doesn't exist yet. Derived properties are still based on SQL statements and you can't add a SQL function in MT Cloud. Closest thing would be an unbound property that you then fill in on the form with a global function, IDO Method, or Form Script.
Hi Tim,
That was my initial approach as well. The issue I ran into is that unbound property, when displayed in the Grid panel, only shows the data after the method/formscript has been run on the object select. Trying to avoid blowing through the collection every time it is refreshed to run the method per record.
Another way would be to use an IDO Event Handler. Extend and Replace the IDO, create an IDO Extension Class that executes a PostLoadCollectionHandler, in the handler, fill in the unbound property with the value for each row. To the form, it would act as if you did a derived property. See the chapter IDO Events in the Infor Mongoose IDO Development Guide for examples. You can do something similar using AES Events by creating a handler under the IdoPostLoadCollection event on the Events form.
Tim,
Great thought. Thanks for the nudge in that direction.