Skip to main content
Question

Pop-up message in Time registration

  • August 23, 2024
  • 1 reply
  • 128 views

Forum|alt.badge.img+3
  • Sidekick (Customer)
  • 8 replies

Hey community,

we are trying to improve the Time registration process for our users and want to add pop-up information message to remind users to confirm their hours entered when week is completed.

I have set up a Custom Event to LU TimmanJobTrans and table TIMMAN_JOB_TRANS_TAB. It fires upon new records created and records changed. So far it’s working.
I have also added two Event Actions to this event: 

  1. Type: E-Mail - which works just fine but was considered only for testing reasons (check if the event is fired etc.)
  2. Type: Execute Online SQL - which seems to be not firing or at least the pop-up message doesn’t show up.

Can anyone assist on making the Online SQL Event action work?

DECLARE
msg_de VARCHAR2(200) := 'DE';
msg_en VARCHAR2(200) := 'EN';
msq_output VARCHAR2(200);

job_status_ VARCHAR2(50);

BEGIN

IF '#USER_LANGUAGE#' = 'de' THEN
msq_output := msg_de;
ELSE
msq_output := msg_en;
END IF;

job_status_ := IFSAPP.Project_Pers_Diary_API.Date_Intervall_Confirm_Status('&NEW:COMPANY_ID', '&NEW:EMP_NO', TO_DATE('&NEW:ACCOUNT_DATE', 'YYYY-MM-DD'), TO_DATE('&NEW:ACCOUNT_DATE', 'YYYY-MM-DD')+6);

--IF job_status_ = 'PARTLY CONFIRMED' THEN
Client_SYS.Add_Info('CompanyPerson', msq_output);
--END IF;

END;

The If statement at the end should not actually be commented out, but I have commented it out for testing purposes. Nevertheless, no message appears.

1 reply

Forum|alt.badge.img+3
  • Author
  • Sidekick (Customer)
  • 8 replies
  • October 14, 2024

Any suggestions on this?