Currently database row fields can only have their value read with SIL, not set. Retrieving the value of a row field works the same way for any other field.
Example 1
Given the field above, the following SIL code would be used to obtain the fields value;
return customfield_11100;
Result - 1323|2011|Nissan|Sentra
The formatting (pipe delimited) of these results tell us that the returned value is an array. Using a pipe delimited string is a shortcut for reading and writing values to an array. SIL will automatically convert the string to an array.
Example 2
To retrieve a specific rows value for a issue and field we can use an array like below. In this example we will retrieve the cars make.
string [] values = customfield_11100; return values[2];
Result - Nissan
The ‘make’ value is at position 2 of the array and not position 3 because when counting the positions within an array you must always start with 0.