How do you control the “0” or “null” value in date fields?


How can I change the display format of a date or date-and-time field? When retrieving data using the Database Query Tool, some values show “zero” and some are “null”. See the following sample steps for reproducing the issue in an out-of-the-box application… (1) From this query, you will see where either some or all of the entries are set to “0”. This should not be the case. (2) When creating a facility project with a bad work task entry, you will see “0” versus the correct “null”.

There is a property in TRIRIGAWEB.properties that can control the format display for fields such as date or date-and-time:

# This property is used at record runtime to determine whether number fields render 0 for null value or show empty field.
# When the value is Y, a number field renders zero in a form when the value in the database is null.
# When the value is N, a number field renders empty in a form when the value in the database is null.
# The default value of this property is Y.
SHOW_ZEROS_IN_NUMBER_FIELDS=Y

This property will allow you to show “null” or “0”. The platform data can be stored as “null” or “0” in the back-end database. When the query is run in TRIRIGA, the platform will format it accordingly.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s