Pulling a report for PO module
We recently migrated over to On Demand from Service desk Plus. My issue is I have a report that I pulled in Service Desk Plus that pulls the PO Number, the PO link and the PO Name - below is my sql statement
SELECT PURCHASEORDER.POCUSTOMID "PO Number", PURCHASEORDER.PONAME "PO Name", ('
http://helpdesk.charmingcharlie.com:8080/PurchaseOrder.do?module=view&poID=' + CAST(PURCHASEORDER.PURCHASEORDERID AS VARCHAR)) "Link" FROM PURCHASEORDER
How do I do this query in On Demand
Thanks
Gunnar
Topic Participants
Gunnar Skielvig
Sriram K.S
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?