Skip to Content
0
Jul 14, 2020 at 06:42 PM

SAP Business one 9.3 OPMG "Golden arrow"

123 Views Last edit Jul 17, 2020 at 06:50 AM 2 rev

Hi,

I'm having a small issue with a query that I have created for our project managment, the querry itself works as intended and the golden arrow apears in the query manager but the golden arrow disappears once I put the query in the count widget.

SELECT T0."AbsEntry", T0."DocNum" AS "Project number", T0."NAME" AS "Project name", T0."REASON" AS "Project description",T4."Name" AS "Step", T3."Name" AS "Task" ,T1."DSCRIPTION" AS "Task description", T1."START" AS "Starting date", T1."CLOSE" AS "Due date" , T2."firstName" AS "Name"

FROM OPMG T0 INNER JOIN PMG1 T1 ON T0."AbsEntry" = T1."AbsEntry" INNER JOIN

(SELECT T1."AbsEntry", MIN (T1."LineID") LINEID FROM PMG1 T1 WHERE T1."FINISH" = 'N' Group BY T1."AbsEntry") MINLINEID ON T1."AbsEntry" = MINLINEID."AbsEntry" AND T1."LineID" = LINEID LEFT OUTER JOIN OHEM T2 ON T1."OWNER" = T2."empID" LEFT OUTER JOIN PMC6 T3 ON T1."Task" = T3."TaskID" LEFT OUTER JOIN PMC2 T4 ON T1."StageID" = T4."StageID"

ORDER BY T0."AbsEntry" ASC

Is this a mistake from my side or an SAP bug?

Thank you in advance