Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Business one 9.3 OPMG "Golden arrow"

former_member954570
Discoverer
0 Kudos

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

  • SAP Managed Tags:
3 REPLIES 3

jerryjanda
Community Manager
Community Manager
0 Kudos

Hi, Faycal:

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. (Note that there is also an "insert code" button in the questions tool that makes these questions easier for members to read.)

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Kind regards,

--Jerry

Make sure to subscribe to What's New!
  • SAP Managed Tags:

former_member954570
Discoverer
0 Kudos

Hi Jerry,

Thank you for your message and explanation, I will use the guide for my next posts, as for my question I can not modify as you have already answered.

I will add a picture to my profile later on.

Best regards

Faycal

  • SAP Managed Tags:

jerryjanda
Community Manager
Community Manager
0 Kudos

I apologize. I meant to leave that as a comment, not as an answer. You're now free to modify if you wish.

--Jerry

Make sure to subscribe to What's New!
  • SAP Managed Tags: