CA Service Management

Hi Team,

I am using CA SDM 14.1.03 with SQL Server 2008 R2. There is a requirement of a custom field on incident detail page that can take values 0 or 1 or Null. The value that needed to be saved in call_req table custom column should be same as well (0 for 0, 1 for 1 and Null for Null) . For this purpose, I created a customized table and added a column (enum) of Integer data type. I published this table and inserted two records in this table as follows:

id      enum

0        0

1         1

After this, I created a customized column which is SREL to the above table and added this field in the detail incident form (with default value as 0 in detail_in form).

Now when I am creating a new incident, the value 0 is not reflecting on front end (although it is updated in the database and reflecting on list_in form as well). Value 1 is reflected on the front end and backend as well.

Kindly suggest why the value 0 is not reflecting on the detail_in form.

Attaching the screenshots for your reference:

Value 0 appearing in list form:

Value 0 not appearing in detail form (saving in database successfully):

Value 1 appearing in list form:

Value 1 also appearing in detail form:

Thanks & Regards,

Balram Singh Deswal

I would recomend instead of SREL custom table to use default actbool, so all you need to do is create SREL attribute to actbool table.

Hi Gutis,

As per the requirement, the value to be saved in the call_req custom column should be 0/1/Null only. If I use SREL to actbool, it will probably save the id of the record in the call_req table instead of the required 0/1. When we use SREL to actbool, it probably shows the True/False value in the dropdown, instead of 1/0 (as per the requirement).

Kindly suggest.

Thanks for your response!

Regards,

Balram Singh Deswal

Yes you are right. Then You need to update your custom table to include sym attribute and mark this attribute as common name. Sym attribute will have two values 1 and 0

e.g. in wsp mods it should look similar to this

OBJECT zbool {
  ATTRIBUTES zbool {
    delete_flag SREL actbool;
    description STRING 60;
    enum INTEGER;
    sym STRING 60
      REQUIRED;
    last_mod_dt DATE { ON_CI SET NOW; };
    last_mod_by SREL cnt { ON_CI SET USER;
                           ON_NEW DEFAULT USER; };
  };

  FACTORY zbool {
    STANDARD_LISTS {
      MLIST OFF;
      RLIST OFF;
    };
    REL_ATTR enum;
    COMMON_NAME sym;
  };
};