B1 Dashboard - How to multi object navigation not working

Jonathan Brotto

• January 31, 2022 18:55

Tried following the video but it seems not to work. Did I not enter something correctly?

https://youtu.be/ZVFa8w2ZnIE

 

SELECT TOP 10 DOCNUM AS 'MULTI_DocEntry_ObjType_DocTypeName', DocEntry, objType, 'Invoice' AS DocTypeName, CardName
FROM OINV

UNION ALL

SELECT TOP 10 DOCNUM AS 'MULTI_DocEntry_ObjType_DocTypeName', DocEntry, objType, 'Credit Note' AS DocTypeName, CardName
FROM ORIN

Vote

0

• 

  Rasmus Jensen

  • January 31, 2022 19:14

  In you multi string you write ObjType with capital O while your column with it is objType with lowercase o... Please try the correct casing

Please sign in to leave a comment.