These chemicals that are in the tanks - they have their own database table? Upload the images of the chemcals to the gateway. Then you have a few options.
One thing I’ve seen is to store the paths of images in the database tables. So you would query for
SELECT imgPath FROM chemicals WHERE idx = %i in a image path property binding. This does require you to update the databsae if you end up moving images around on your gateway image management though.
Similarly, if you only have a handful images it could ever possible, you can again bind a image property binding to something like
if(CONDITION, 'imagepath1.jpg', if(CONDITION2, 'imagepath2.jpg', 'imagepath3.jpg')).
Again with both these methods keeping the path consistent is important, so if you move a image from one folder to another on the gateway youre expression or database field will have to change.
I know you can store images on a database as a
Blob type, but I am not sure how you would load that up to an ignition component. Maybe someone else could speak on that, but it would eliminate any path issues.