Contents tagged with Images
today I want to leave a short post on how to display images in grid of Acumatica.
I'll demonstrate it on sample of Sales Orders pages, which is known as SO301000.
End result will look like this:
In order to make it work, I've done the following:
Created extension to SOOrderEntry and added there some kind of reading of url images
Created DAC class for demo purposes
Added few controls and css/js on customized so301000 page.
Now a bit more details. For SOOrderEntry I've created following extension:
public class SOOrderEntryExt : PXGraphExtension<SOOrderEntry>
public PXSelect<SOImageItem> Images;
protected virtual IEnumerable images() … more
today I want to document some information about how images for inventory items are stored in Acumatica.
Database structure (Acumatica)
InventoryItem - A table that contains all InventoryItem data
> ImageURL - A data field where the image file name being saved.
UploadFile - A table that contains attachments data
> Name - A data field where you can use to join with InventoryItem using InventoryItem.ImageURL = UploadFile.Name
NoteDoc - A table that contains all NoteDoc data
> FileID - A data field unique ID where you can use to join with UploadFile using UploadFile.FileID = NoteDoc.FileID
A SQL query that get data necessary to create the imageExternalLink … more