API GetDownloadFiles: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „ss“) |
|||
| Řádka 1: | Řádka 1: | ||
| − | + | ====Description==== | |
| + | Method gives You overview of existing download file in system. | ||
| + | ====Exact name==== | ||
| + | <code>API_GetDownloadFiles</code> | ||
| + | ====Type==== | ||
| + | Standard view. | ||
| + | ====Specification==== | ||
| + | {| class="wikitable" | ||
| + | !Column | ||
| + | !Data type | ||
| + | !Description | ||
| + | !Relation | ||
| + | |- | ||
| + | |ID | ||
| + | |int | ||
| + | |Internal system id | ||
| + | | | ||
| + | |- | ||
| + | |ValidFromDate | ||
| + | |datetime | ||
| + | |Valid from date | ||
| + | | | ||
| + | |- | ||
| + | |ValidToDate | ||
| + | |datetime | ||
| + | |Valid to date | ||
| + | | | ||
| + | |- | ||
| + | |GroupName | ||
| + | |nvarchar(200) | ||
| + | |Group name | ||
| + | | | ||
| + | |- | ||
| + | |Title | ||
| + | |nvarchar(200) | ||
| + | |Title | ||
| + | | | ||
| + | |- | ||
| + | |Description | ||
| + | |nvarchar(2000) | ||
| + | |Description | ||
| + | | | ||
| + | |- | ||
| + | |FileName | ||
| + | |nvarchar(255) | ||
| + | |File name | ||
| + | | | ||
| + | |- | ||
| + | |SortIndex | ||
| + | |int | ||
| + | |Sort index | ||
| + | | | ||
| + | |- | ||
| + | |InsertedDate | ||
| + | |datetime | ||
| + | |Inserted date | ||
| + | | | ||
| + | |- | ||
| + | |UpdatedDate | ||
| + | |datetime | ||
| + | |Updated date | ||
| + | | | ||
| + | |- | ||
| + | |FILEDATA | ||
| + | |varbinary(max) | ||
| + | |File data | ||
| + | | | ||
| + | |} | ||
| + | ====Example==== | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | SELECT TOP 1000 * FROM [API_GetDownloadFiles] | ||
| + | </syntaxhighlight> | ||
| + | ====Notices==== | ||
| + | None. | ||
Aktuální verze z 26. 7. 2017, 08:15
Description
Method gives You overview of existing download file in system.
Exact name
API_GetDownloadFiles
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| ValidFromDate | datetime | Valid from date | |
| ValidToDate | datetime | Valid to date | |
| GroupName | nvarchar(200) | Group name | |
| Title | nvarchar(200) | Title | |
| Description | nvarchar(2000) | Description | |
| FileName | nvarchar(255) | File name | |
| SortIndex | int | Sort index | |
| InsertedDate | datetime | Inserted date | |
| UpdatedDate | datetime | Updated date | |
| FILEDATA | varbinary(max) | File data |
Example
SELECT TOP 1000 * FROM [API_GetDownloadFiles]
Notices
None.
