How to use CA SDM Maileater to set an integer field to zero, not NULL?

book

Article ID: 130531

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction



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:

%affected_cost=0

Should set the Affected Cost field on the Change Order to a value of "0" instead of "NULL."

Environment

CA Service Desk Manager, any version.

Resolution

Use double-quotes with nothing between them to get a "0" value.

For example:
%affected_cost=""

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. 
%PRIORITY=3 
%CATEGORY=Email 
%actual_cost="" 
%DESCRIPTION=Actual cost. Test 10 Using empty quotes. 

This gives a value of "NULL." 

%SUMMARY=Test 09. Has a figure of 0. 
%PRIORITY=3 
%CATEGORY=Email 
%actual_cost=0 
%DESCRIPTION=Actual cost. Test 10. Has literally 0.