Derived SQL function from a unbound value?

Hi all,

I am developing some custom reports based on Infor SQL stored procedures. I have created an IDO and added the SP as a method and everything is working fine.

What I want to do is add a derived field to the IDO to use a SQL function to display a nicely formatted address. I added a dervied value with a SQL call that points to my "CustNum" unbound property. However, when I run the report it does not populate.

I have done this with other IDOs, but with bound properties. Is it not supported with unbound properties? Any suggestions on a "best practice" for these types of customizations? Usually we would just copy the SQL stored procedure and name it something custom to our company and leave it at that. But we are trying to move to having mongoose handle all these types of customizations.

Thanks!
Ryan

Find more posts tagged with

Accepted answers

Yao Jiang

Yes, derived properties will not work with unbound properties because there is no sql data behind it.

All comments

Yao Jiang

Yes, derived properties will not work with unbound properties because there is no sql data behind it.

Ryan Pukanski

Thanks for the answer.

acl

CLMs only populate properties specified into CLM's result set

Derived properties work with IDO, not IDO CLM

You can extend the result set in the SP or , if you think it justifies the time/effort - use Event system or Report Form's script to populate unbound property with value return by calling sp FormatAddressSp

Copyright © 2025 Infor. All rights reserved.