How to use CA SDM Maileater to set an integer field to zero, not NULL?
Article ID: 130531
SUPPORT AUTOMATION- SERVER
CA Service Desk Manager - Unified Self Service
CA Service Management - Asset Portfolio Management
CA Service Management - Service Desk Manager
How to use CA SDM Maileater to set a value of an integer attribute to zero ("0")?
It appears to ignore the input and leave the attribute as "NULL".
Want to enter a value of "0" and not "NULL" or a blank entry.
Change Order Example:
Should set the Affected Cost field on the Change Order to a value of "0" instead of "NULL."
CA Service Desk Manager, any version.
Use double-quotes with nothing between them to get a "0" value.
This will produce a value of "0" in the database and in the CA SDM web client.
CHANGE ORDER EXAMPLE
This gives a value in the database (and on screen) for the actual_cost field of "0".
%SUMMARY=Test 10. Has empty double-quotes.
%DESCRIPTION=Actual cost. Test 10 Using empty quotes.
This gives a value of "NULL."
%SUMMARY=Test 09. Has a figure of 0.
%DESCRIPTION=Actual cost. Test 10. Has literally 0.