Query Alert to be triggered if Logged in User = User in Query

[former_member698435]

Experts,

We use (SAP B1 Hana 9.3) Projects and I have created a UDF on the Stage lines to be populated with an Alert person's User Name.

I want to use this UDF Alert Person as a trigger for an Alert, but Alerts in B1 do not have a variable trigger..... Is there a way that you can write that into the Query?

I was thinking if the logged in user = User on the Stage Line, it should work.

SELECT T0."AbsEntry", T0."NAME", T2."Name", T3."Name", T1."U_PersonAlert", T1."U_AlertText"
FROM OPMG T0  INNER JOIN PMG1 T1 ON T0."AbsEntry" = T1."AbsEntry" 
INNER JOIN PMC2 T2 ON T1."StageID" = T2."StageID", 
PMC6 T3 
WHERE  T1."FINISH" = 'N'

Any advise would be super helpful.

Regards,

Marli Schutte

[msundararaja_perumal · Accepted solution]

Hello,

B1's alert management is tied to user id, the logged in user can be used only for validation like transaction notification.

In your case, you have to create alert by stage and tag them to respective use and lower the alert frequency to 1 hour or less, according to the need.

Thanks.

[Abdul]

Please deploy alert with frequency based on seconds or minutes as per below example

SELECT T0."DocNum", T0."DocDate", T0."CardCode", T0."CardName", T0."NumAtCard",T0."Project", T0."DocTotal" FROM OPCH T0 INNER JOIN OUSR T1 ON T0."UserSign" = T1."USERID" INNER JOIN PCH1 on PCH1."DocEntry" = T0."DocEntry" WHERE and DAYS_BETWEEN(TO_DATE(CAST (T0."CreateDate" AS DATE), 'YYYY-MM-DD'), TO_DATE(CURRENT_DATE, 'YYYY-MM-DD'))=0 AND SECONDS_BETWEEN (CAST (CONCAT(CONCAT((LEFT(RIGHT(CONCAT('0000' ,CAST(T0."DocTime" AS VARCHAR)),4 ),2)),':') , (RIGHT(RIGHT(CONCAT('0000' ,CAST(T0."DocTime" AS VARCHAR)),4 ),2)) ) AS TIME),CURRENT_TIME)<120