API GetDownloadFiles: Porovnání verzí

Aktuální verze z 26. 7. 2017, 07:15

Method gives You overview of existing download file in system.

API_GetDownloadFiles

Standard view.

Column	Data type	Description
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

SELECT TOP 1000 * FROM [API_GetDownloadFiles]

None.

@@ Řádek 1: / Řádek 1: @@
-ss
+====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.