Certain methods require that you pass the internal ID for specific
field values. For example, the input for the SetValue method for the
Field object requires must be the internal database value.
The following list describes the internal
value format for most SBM
field types:
- Binary/Trinary: Internal values are 0, 1, and 2,
representing the first, second, and third values.
- Date/Time: Internal value is a number representing
seconds since Jan 1 1970 in GMT or just elapsed seconds for
elapsed time.
- Folder: The TS_ID for the folder specified in the
TS_FOLDERS table.
- Multi-Group: Comma-separated list (with leading and
trailing commas) of TS_IDs from the TS_GROUPS table.
- Multi-Relational: Comma-separated list (with leading and
trailing commas) of TS_IDs from the relational table.
- Multi-Selection: Comma-separated list (with leading and
trailing commas) of TS_IDs from the TS_SELECTIONS table.
-
Multi-User: Comma-separated list (with leading and
trailing commas) of TS_IDs from the TS_USERS table.
Important: If the Groups and
Users selection mode is enabled for the field, the
value can also include group identifiers (TS_IDs from the
TS_GROUPS table), which are in the form G1,
G2, and so forth.
- Numeric: Same as display value.
- Single Relational: The TS_ID of the item in the
relational table.
- Single Selection: The TS_ID of the selection from the
TS_SELECTIONS table.
- Summation: Same as display value.
- Text: Same as display value.
- User: The TS_ID of value from the TS_USERS table.
Copyright © 2007–2016 Serena Software, Inc. All rights reserved.