11-01-2016 2:33 PM - edited 02-03-2024 7:56 PM
We have a query at Query Manager, which is query 1, and when we use it, it appear us the golden arrow. But, when we use the query 2, it does not appear us the golden arrow,as you can see below.
Could you advice us, how can we solve this issue?
King Regards,
Alexandros Karadimitropoulos
query 1:SELECT * FROM OOPR
query 2: SELECT OOPR.OpprId ,T0.Descript ,N'Reminder' ,CAST(T1.OpenDate AS DATE) ,T1.Step_Id ,T4.UserID ,T4.U_Name FROM OOPR INNER JOIN OPR1 T1 ON T1.OpprId = OOPR.OpprId INNER JOIN OOST T0 ON T0.[Num] = T1.[Step_Id] INNER JOIN OHEM T3 ON T1.[Owner] = T3.empID INNER JOIN OUSR T4 ON T4.UserID = T3.UserID WHERE DATEDIFF(DAY,CONVERT(VARCHAR(10),T1.OpenDate,10),CONVERT(VARCHAR(10),GETDATE(),10)) >= '3' AND T1.Step_Id = '7' AND T4.UserID = '1' ORDER BY OOPR.[OpprId] FOR BROWSE
Hi Alexandros,
I ran an alert with this query:
SELECT
T0.OpprId,
T2.Descript,
N'Reminder',
CAST(T1.OpenDate AS DATE),
T1.Step_Id,
T4.UserID,
T4.U_Name
FROM
OOPR T0
INNER JOIN OPR1 T1 ON T1.OpprId = T0.OpprId
INNER JOIN OOST T2 ON T2.Num = T1.Step_Id
INNER JOIN OHEM T3 ON T1.Owner = T3.empID
INNER JOIN OUSR T4 ON T4.UserID = T3.UserID
WHERE
DATEDIFF(DAY, T1.OpenDate, GETDATE()) >= 3
AND T1.Step_Id = 7
AND T4.UserID = 1
ORDER BY T0.OpprId FOR BROWSE
In my test, I have changed step id to 1 in the where clause for return some values.
The result of my test was this. It worked fine.
I have tested on SAP 9.1 PL 12.
Hope the query above helps you.
Kind Regards,
Diego Lother
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Diego Lother,
I used your advice and I changed my query as you can see below. But, after that, golden arrow does not appear.
Could you give us any other advices?
King Regards,
Alexandros Karadimitropoulos
query: SELECT T5.OpprId ,T0.Descript ,N'Reminder ,CAST(T1.OpenDate AS DATE) ,T1.Step_Id ,T4.UserID ,T4.U_Name FROM OOPR AS T5 INNER JOIN OPR1 T1 ON T1.OpprId = T5.OpprId INNER JOIN OOST T0 ON T0.[Num] = T1.[Step_Id] INNER JOIN OHEM T3 ON T1.[Owner] = T3.empID INNER JOIN OUSR T4 ON T4.UserID = T3.UserID WHERE DATEDIFF(DAY,CONVERT(VARCHAR(10),T1.OpenDate,10),CONVERT(VARCHAR(10),GETDATE(),10)) >= '3' AND T1.Step_Id = '7' AND T4.UserID = '1' ORDER BY T5.[OpprId] FOR BROWSE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
14 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.