Widget Dashboard - Prevent Multiple Object Navigation

Jennifer Fink

• 4 de agosto de 2023 16:59

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.

Vote

1

• 

  Geoff Booth

  • 4 de agosto de 2023 17:05

  Can you post your current code?
• 

  Jennifer Fink

  • 4 de agosto de 2023 17:09

  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'
• 

  Geoff Booth

  • 4 de agosto de 2023 17:21

  I have never tried this but try changing your select to:

  OSCL.internalSN As 'Equip SN'

   

  Good luck

   
• 

  Jennifer Fink

  • 4 de agosto de 2023 17:55

  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.

Iniciar sesión para dejar un comentario.