IV89016: Queries with associated objects show 0 in numeric fields

Queries with associated objects will show 0 for numeric fields when the primary record has no associated record. If you have a report that uses an association to a second object and you run the report, the associated record will show 0, even if the TRIRIGAWEB.properties is set to not show 0 for null values.

The SHOW_ZEROS_IN_NUMBER property is used with form-based views. We needed to update the queries to adhere to this property as well. Moving forward, we fixed an issue where empty numeric fields in query reports would show a 0 value, even though the TRIRIGAWEB.properties SHOW_ZEROS_IN_NUMBER_FIELDS property was set to not show zeros and show blanks instead.

Continue reading


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.