Skip to main content

I am trying to get a file id associated with an image for a stock item. I found this information on stack overflow that states that you can link these tables for the entity table and the UploadFile table through the NoteID field. However, I am not having success with this. I think this may be because Stock Items don’t have an associated note id and those are only for screens with associated documents like a sales order, but I’m not sure. I am linking these tables in this way:

I’ve been able to have partial success with this, but it’s very slow and only successful for around 60% of the results. Does anyone know if there is a field that can link between PX.Objects.IN.InventoryItem and PX.SM.UploadFile?

You will need to join Inventory with NoteDoc on Inventory.NoteID = NoteDoc.NoteID and NoteDoc with UploadFile on NoteDoc.FileID = UploadFile.FileID. 
The revisions of Files are kept in UploadFileRevision table and can be joins on FileID to UploadFile


Reply