The following image formats are supported.

• PNG (preferred)
• JPG
• GIF
• BMP (not recommended)

Each image must be provided in four (4) sizes.

• 45 x 45 for thumbnail image
• 65 x 65 for thumbnail image
• 250 x 250 for mouse-over (hover) image
• 1024 x 1024 for on-click (large) image

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. A Bizweaver workflow is available to assist with this process. Images can also be registered manually as described elsewhere in this page.

This example displays a list of production orders with an image of the finished product.

• The database for “vgoCommon” may need to be changed for your installation.
• “isnull(t1.filepath,'\SiteImages\NoImage_45.png')” assumes you have an image to be displayed when an actual image is not available.
• Use either “45” or “65” in the selection. 45 is used in this example. The other sizes (for the other thumbnail, image rollover and image click) are determined automatically by Versago.

SELECT
t0.ItemCode, t1.ItemName, isnull(t2.filepath,'\SiteImages\NoImage_45.png') AS [ImagePath], t0.DueDate, t0.Status, t0.DocEntry, t0.DocNum
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 ('R','P')
AND isnull(t2.filepath,'\SiteImages\NoImage_45.png') LIKE '%45%'