versago3:dataview_display
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
versago3:dataview_display [2022/09/14 15:51] dlee |
versago3:dataview_display [2024/03/14 14:16] (current) dlee [Field Display] |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| * **Localization** is used to adjust the formatting of date, datetime, and currency __types__. | * **Localization** is used to adjust the formatting of date, datetime, and currency __types__. | ||
| * **File Name** is only accessible when the data type of the column is binary, blob, or varbinary . See **Note 1** below. | * **File Name** is only accessible when the data type of the column is binary, blob, or varbinary . See **Note 1** below. | ||
| + | |||
| + | <WRAP center round info 80%> | ||
| + | Users will be able to sort by clicking column heading. Multiple column can be sorted by using the CTRL key | ||
| + | </ | ||
| **Note 1** | **Note 1** | ||
| Line 22: | Line 26: | ||
| * **Database Source Files** are identified by reference to specific records in a database. | * **Database Source Files** are identified by reference to specific records in a database. | ||
| * The data is found in a table named " | * The data is found in a table named " | ||
| - | * Two values are required from the record: FileName and FileContent. | + | * Two values are required from the record: FileName and FileContent. |
| - | * When the data type of the column is binary, blob, or varbinary the __File Name__ field for the FileContent row presents a drop-down list of fields from the report query. | + | * The Display Type of __FileContent__ should be set to File |
| - | * It is not necessary to display the __FileName__ value in the report, but showing | + | * It is not necessary to display the __FileName__ value in the report, but showing the name of the file is typically very helpful. |
| The **files in a database** approach does require that the __FileContent__ value is not NULL. As it is very possible that a report row will not have a corresponding report to download, use the following SQ. Setting FileContent to 0 when the database value is NULL allows the report to execute without errors. | The **files in a database** approach does require that the __FileContent__ value is not NULL. As it is very possible that a report row will not have a corresponding report to download, use the following SQ. Setting FileContent to 0 when the database value is NULL allows the report to execute without errors. | ||
| Line 33: | Line 37: | ||
| In both cases, keep in mind that any user that has access to the report can download any file listed in the report. If certain files should be available to certain group(s) of users, different reports may be needed. | In both cases, keep in mind that any user that has access to the report can download any file listed in the report. If certain files should be available to certain group(s) of users, different reports may be needed. | ||
| + | |||
| + | <WRAP center round info 80%> | ||
| + | Video regarding files and Data Views | ||
| + | </ | ||
| ====Highlights==== | ====Highlights==== | ||
| Line 68: | Line 76: | ||
| | | ||
| Images are held in the folder C:\Program Files(x86)\TWBS\Versago\WebApp\SiteImages. | Images are held in the folder C:\Program Files(x86)\TWBS\Versago\WebApp\SiteImages. | ||
| - | |||
| - | The images must also be registered in the Versago common database in the versago_image_files table. | ||
| - | |||
| - | ====Sample SQL Using Images==== | ||
| - | This example displays a list of production orders with an image of the finished product. | ||
| - | |||
| - | * The database for " | ||
| - | * " | ||
| - | * Use either " | ||
| - | | ||
| - | <code SQL> | ||
| - | select | ||
| - | t0.ItemCode, | ||
| - | from OWOR t0 | ||
| - | inner join OITM t1 on t0.ItemCode = t1.ItemCode | ||
| - | left join [vgoCommon].dbo.[versago_image_files] t2 on t0.ItemCode = t2.IntersectionID collate database_default | ||
| - | where t0.Status in (' | ||
| - | AND isnull(t2.filepath,' | ||
| - | </ | ||
| - | |||
| - | ===Image Files=== | ||
| - | Four image sizes are required as noted above. | ||
| <WRAP center round info 80%> | <WRAP center round info 80%> | ||
| - | The file name is typically the same value as its associated object. | + | Video regarding |
| </ | </ | ||
versago3/dataview_display.1663185074.txt.gz · Last modified: 2022/09/14 15:51 by dlee
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
