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

[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