Content Types
SQL Content Item
An SQL content item holds the data of one result record of a query. The values of the columns of a record are mapped to metadata fields based on the agent’s configuration. The following metadata fields can be mapped:
| Metadata Field | Remark |
|---|---|
Content |
|
Title |
|
Item Type |
|
Mime Type |
|
File Extension |
|
Preview URL |
It is expected that the column’s values are strings in proper URL format. |
Click URL |
It is expected that the column’s values are strings in proper URL format. |
Keywords |
It is expected that the column’s values are a comma separated list of strings. |
Languages |
It is expected that the column’s values are a comma separated list of strings. |
Author |
|
Contributors |
It is expected that the column’s values are a comma separated list of strings. |
Created Date |
It is expected that the column’s values are timestamps with time zones. |
Last-Modified Date |
It is expected that the column’s values are timestamps with time zones. |
Breadcrumbs |
It is expected that the column’s values are a comma separated list of strings in proper URL format. |