Mapping EDC database fields (columns) to Vocabulary Attributes
- Last Updated: July 2, 2019
- 1 minute read
- Corticon
- Documentation
Automatic mapping of attributes works the same as entities. If an automatic match is not made by the system, then select the appropriate field name from the drop-down in field:column property, as shown:
CHAR database column
The database column type CHAR has a
constant length. When a Corticon
string attribute is mapped to such a column, the string retrieved from the database
always has the length that is specified in the database definition. When a string
shorter than the specified length is assigned to the attribute, the database adds
spaces at the end of the string before storing it in the database. When the
attribute is retrieved from the database, the value returns with the padded spaces
at the end of the string.
If this is not the intended behavior, change the database type for
the column from CHAR to variable-length character
data type. If the database schema cannot be changed, either use a trimSpace operator to strip the trailing spaces from
the returned attribute value or redefine the query string to allow for its full
length including added spaces.