With the latest groov EPIC firmware update, I have installed the MSSQL-Plus node that allows me to query a MSSQL database that has images. These are easy to display in Node-RED dashboard and I am hoping to do the same in groov View. But I read another post that indicates the image must be hosted in order to be viewable in groov View. We have 10,000+ images in the MSSQL database that I was hoping to display (one at a time, of course) in groov View.
Flow in Node-RED
(enter the work order number, get back the part number and part image)
Off the top off my head, to pull that off you’d need to use Node-RED to write the image out to a known location on the EPIC that can be served up via the built-in web browser, probably somewhere in the Unsecured Files area. Then in groov View configure a Video gadget (not an Image, confusingly) to use the URL to that file. It’d only really work for one user at a time though: anyone changing the work order number would overwrite that one image.
You might be able to have Node-Red make the image available via the HTTP response node, then use the video gadget to get it via localhost - then no need to write the image to storage.
