Question

How can I create a Custom Event to trigger error when the attribute that triggers this event is a NVL

  • 14 February 2022
  • 1 reply
  • 188 views
O
Rank
Userlevel 2
Badge +4
  • Ola
  • Do Gooder (Customer)
  • 13 replies

My Custom Event is not working. Can anyone help with this issue please?

I have the custom attribute ‘Date’ to be:

NVL(lora1app.PROJECT_MISC_PROCUREMENT_API.Calculate_Required_Date(lora1app.ACTIVITY_API.Get_Early_Finish(lora1app.ACTIVITY_API.Get_Early_Finish(&PROJECT_ID), ACTIVITY_SEQ,OFFSET)))

and I want it to trigger an error when a past date is entered in the date field. I currently have this in the Event and I set the Event Action but it is not triggering the error.

Event.

 

Event Action

Main Screen where the Error is to display.

 

This topic has been closed for comments

1 reply

T
Rank
Userlevel 3
Badge +8

I would try having the check process in the Event Action code, instead of embedding it in the Custom Attribute. I’m not sure if the NVL is the correct format, but anyways you want to compare whatever value was entered into the specific Required Date field.

IF (value) < sysdate THEN

Error_sys…

ELSE

NULL;

END IF;

Terms & ConditionsCookie settings