Have you ever used the Ad Hoc Query Tool to get a list of requests then thought, "I wish this had barcodes so I could use this as a worklist?" Here are a few quick steps that will allow you to use that list in the Request Batch Update screen by adding a simple formula to an Excel spreadsheet.
Create Your Query and Export to Excel
Use the Search > Ad Hoc Query menu option to build the list of requests you need.
Include the Req_ID column.
Export the the output to Excel.
Add the Bar code Formula
1) In the Excel spreadsheet, include a column where the formula is =CONCATENATE("*",C3,"*",CHAR(13)) The C3 gets replaced with the cell value that contains the REQ_ID. The CHAR(13) is a return or enter expected by the bar code scanner.
2) Format the cell to use the 3 of 9 Bar code font. You may want to increase the font size so it scans easily.
Test your list by scanning the bar codes into Notepad.
Use in Request Batch Update
You can now use the printed output from your query to batch update the requests by scanning the bar codes.