Unfortunately, it's on a user account page with protected data. Here's the image from the screen though.
Also, here's the code used in the query:
| Code: |
SELECT itemcode as 'Item Number', itemdescription as 'Item Name', Quantity as 'Qty Ordered', Price as 'Unit Price', CONCAT( '<a target="_blank" href="http://www.fedex.com/Tracking?language=english&cntry_code=us&tracknumbers=', `TrackingNumber`,'">', `TrackingNumber` , '</a>' ) AS 'FedEx Tracking', CONCAT( '<a target="_blank" href="http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1=', `TrackingNumber`,'">', `TrackingNumber` , '</a>' ) AS 'Alt Tracking'
FROM `thisnameisbeinghidden`
WHERE docnum = {$REQUEST:currentPo}
AND UserID = {$UserLogin}
|
Just need to get a dynamic hyperlink from the button, using data from the TrackingNumber field.
