Widget Dashboard - Prevent Multiple Object Navigation
Hello.
I have created a dashboard widget for the service call object. I have a column for the service call DocNum and a substring column of the service call's equipment card item code. Before adding the equipment card column, double clicking the row opens the service call. After, I am presented with the option to open the Item Master data. I don't need the option for the Item Master data.
How do I build my query to prevent the multiple objects option?
Thank you for any assistance you can provide.
-
Can you post your current code?
-
Hi Geoff.
Certainly.
SELECT CRD1.State AS 'State',ISNULL(OSCL.queue,OSCS.Name) AS Queue, OSCL.CustmrName AS 'Customer', OSCL.DocNum AS 'ServiceCallNumber', OSCL.createDate AS 'Create Date', OSCL.createTime AS 'Create Time'
, OSCL.BPShipCode AS 'Ship To', OSCL.subject AS 'Subject', ISNULL(OSCL.UpdateDate, OSCL.CreateDate) AS 'Last Activity', COALESCE(CONCAT(OHEM.firstName, ' ' , OHEM.lastName), 'Unassigned') AS 'Owner', OSCS.Name AS 'Status', OSCL.internalSN, LEFT(OINS.itemCode, CHARINDEX(' ', OINS.itemCode)-1) AS 'Make'
FROM OSCL
LEFT JOIN OSCS ON OSCL.status = OSCS.statusID
LEFT JOIN OSCT ON OSCL.callType = OSCT.callTypeID
LEFT JOIN CRD1 ON OSCL.Customer = CRD1.CardCode AND OSCL.BPShipCode = CRD1.Address AND CRD1.AdresType = 'S'
LEFT JOIN OHEM ON OSCL.U_NB_Owner = OHEM.empID
LEFT JOIN OINS ON OSCL.internalSN = OINS.internalSN
WHERE OSCT.Name = 'Thermal' AND OSCS.Name <> 'Closed' -
I have never tried this but try changing your select to:
OSCL.internalSN As 'Equip SN'
Good luck
-
Hi Geoff.
Thank you very much for the quick response. I've gotten it to work. A little bit of operator error in that I my abbreviated query I posted neglected to include the field OSCL.itemCode. Your suggestion to alias the field (which is mentioned in the videos but just didn't sink in) was the key.
Fortunately, the item code and the item name for these records are the same values. I've changed the select to use OSCL.itemName AS 'MakeModel'.
I no longer see the option dialog for multiple objects and the double click opens my service call.
Again, thank you for your help.
Please sign in to leave a comment.
Comments
4 comments