QueryDefinition
Represents a SQL query activity accessed and performed by the SOAP API. This table does not support updates or inserts.
Table-Specific Information
Select
The driver uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The driver processes other filters client-side within the driver.
For example, the following (but not only) queries are processed server side:
SELECT * FROM QueryDefinition WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM QueryDefinition WHERE ObjectID IN ('nzxcaslkjd-123', 456)
SELECT * FROM QueryDefinition WHERE CreatedDate > '2017/01/25'
Delete
You must specify the ObjectID in the WHERE clause when executing a delete against this table.
DELETE FROM QueryDefinition WHERE ObjectID = 'nzxcaslkjd-123'
Columns
| Name | Type | ReadOnly | Description |
| ObjectID [KEY] | String | False |
System-controlled, text string identifier for object. |
| Client_ID | Int | False |
The Id of the client. |
| Name | String | False |
Name of the object or property. |
| CustomerKey | String | False |
User-supplied unique identifier for an object within an object type. |
| Description | String | False |
Describes and provides information regarding the object. |
| QueryText | String | False |
Specifies text associated with a query definition. |
| TargetType | String | False |
Indicates target type for a query definition. |
| DataExtensionTarget_Name | String | False |
Name of the object or property. |
| DataExtensionTarget_CustomerKey | String | False |
User-supplied unique identifier for an object within an object type |
| DataExtensionTarget_Description | String | False |
Describes and provides information regarding the object. |
| TargetUpdateType | String | False |
Indicates the target update type for a query definition. |
| FileType | String | False |
Specifies column delimiter of a file (CSV, TAB, or Other). |
| FileSpec | String | False |
Defines the file-naming pattern associated with an activity (valid substitutions include%%YEAR%%, %%MONTH%%, and %%DAY%%). |
| Status | String | False |
Defines status of object. |
| CreatedDate | Datetime | False |
Indicated the date and time of the object's creation. |
| ModifiedDate | Datetime | False |
Indicates the last time object information was modified. |
| CategoryID | Int | False |
Specifies the identifier of the folder containing the email. |