Most CA SDM objects have a field called ‘active’ or ‘delete_flag’. This is actually an SREL pointer to the Active_Boolean_Table object or Boolean_Table object. Consider adding these fields to your queries to filter objects marked as Inactive by the system administrator. For querying purposes, search for ‘delete_flag = 0’ to find active records and ‘delete_flag = 1’ for inactive records. For example, the following pseudo-code demonstrates using doSelect() to retrieve values for all active Request Status objects:
doSelect(SID, "crs", "delete_flag = 0", -1, new String[0]);
To set an object to active or inactive, you need to pass the handle of the Boolean object representing either true or false. These handles do not change, so you can safely hard-code them. These are listed as follows:
|
Active_Boolean_Table |
Boolean_Table |
|---|---|
|
actbool:4551 = ‘Active’ |
bool:200 = ‘False’ |
|
actbool:4552 = ‘Inactive’ |
bool:201 = ‘True’ |
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |