B1 Dashboard - How to multi object navigation not working
Tried following the video but it seems not to work. Did I not enter something correctly?

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
0
-
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
Iniciar sesión para dejar un comentario.
Comentarios
1 comentario