I am back again with another question.
I have created a ‘namedQuery’ to do some pallet information look up from the db.
I have numerous racking locations and I created a pallet template to represent these locations in our warehouse (first pic).
I have also created a popup for the ‘namedQuery’ (third pic) that needs to reference the individual pallet’s location. So if I click on the green pallet a popup comes up with that specific bin information.
QUESTION - Is it possible to bind the value in the query binding so that when I click on a location it will use that BinLocation to look up the pallet information?
SELECT Clemens.pallets.lpn, Clemens.pallets.location, Clemens.pallets.sku, Clemens.pallets.lot_number, Clemens.pallets.qc_status, Clemens.pallets.timestamp, Clemens.pallets.inducted, Clemens.pallets.quantity, Clemens.pallets.sub_status, Clemens.pallets.status, Clemens.pallets.reason_code FROM Clemens.pallets WHERE Clemens.pallets.location = :palLoc ; [details="Summary"] This text will be hidden [/details]