Derived fields - Using an IDO Method vs SQL/SQL Function

Stephen Cena

We are currently on CSI 9.01.01, and have a bunch of Derived fields that use SQL Functions. Is there any way (currently) to use an IDO Method for the Derived field value, or are we limited to just SQL/SQL Functions? I'm trying to avoid creating more SQL Functions but if that's the only way to do it, then that's what I'll do.

Or maybe the actualy problem could be solved. In this instance, I have three Derived fields in our Location IDO. They hold the pieces of our Location names. Ex: If the Location is 53 GAMMA 42, then the fields will contain 53,GAMMA and 42 respectively. Is there any way to make the fields in the Location IDO appear in the Item Location IDO other than re-creating the Derived fields & calling the proper SQL Functions to calculate the value?

0911060553270289.pdf

unknown

You could add a subbcollection pointed to SLLocations to your SLItemLocs IDO linked on Loc=Loc and then you would have access to all of your SLLocations properties from the form without having to recreate the properties.  Or add a secondary collection to the form and add events to refresh the secondary colelction anytime the primary collection is refreshed