CustomerDownloads
Retrieves the permissions required for customer downloads.
Table Specific Information
Select
Only a limited number of columns can be used in the WHERE clause of a SELECT query.
These columns support only the = comparison, unless otherwise specified. The available column for this table is CustomerId. All other columns are processed client-side.
If the 'CustomerId' filter is not specified, the driver fetches a list of all the customers and sends a request for each customer in that list.
SELECT * FROM CustomerDownloads where CustomerId=6
Columns
| Name | Type | References | Description |
| DownloadId | String | Download Id (MD5). | |
| DownloadName | String | Downloadable file name. | |
| DownloadUrl | String | Download file URL. | |
| DownloadsRemaining | String | Number of downloads remaining. | |
| File | String | URL of the file in the downloadable product. | |
| FileName | String | Name of the file in the downloadable product. | |
| OrderId | Long |
Orders.Id | Order Id. |
| OrderKey | String | Order key. | |
| ProductId | Long |
Products.Id | Product Id. |
| ProductName | String | Product name | |
| LinksCollectionAggregate | String | A collection of links for all downloads by this customer. | |
| LinksOrderAggregate | String | A collection of links to fetch the order details. | |
| LinksProductAggregate | String | A collection of links to fetch the product details. | |
| AccessExpires | String | The date when download access expires, in the site's timezone. | |
| AccessExpiresGmt | String | The date when download access expires, as GMT. | |
| CustomerId | Long |
Customers.Id | Unique identifier for the Customer. |