EntityFiles
List the attached files to an entity.
View Specific Information
Use this view as a helper in case you need the file unique identifiers, for the DownloadFile.
Except the pseudo columns, no filters are handled server-side on this view. EntityType and EntityId must be specified to query from this view.
SELECT * FROM EntityFiles WHERE EntityType = 'Candidate' AND EntityId = '110011'
Columns
| Name | Type | Description |
| Id [KEY] | Int | The unique identifier of the file. |
| Name | String | The name of the file. |
| DateAdded | Datetime | Datetime the file was added. |
| FileType | String | The type of the file. |
| Type | String | The type of the file. |
| FileExtension | String | The type of the file. |
| Description | String | A brief description of the file. |
| IsDeleted | Boolean | Whether or not the file is deleted. |
| IsPrivate | Boolean | Whether or not the file is private. |
| IsExternal | Boolean | Whether or not the file is external. |
| ContentType | String | The ContentType of the EntityFiles. |
| ContentSubType | String | The ContentSubType of the EntityFiles. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| EntityType | String | The entity type you want to list the attached files for. The available values are Candidate, ClientContact, ClientCorporation, JobOrder, Opportunity, Placement.
使用できる値は次のとおりです。Candidate, ClientContact, ClientCorporation, JobOrder, Opportunity, Placement |
| EntityId | String | The unique identifier of the entity you want to list attached files from. |