Skip to main content
Question

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

  • February 14, 2022
  • 1 reply
  • 218 views
O
Do Gooder (Customer)
Forum|alt.badge.img+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.

 

Yasas Kasthuriarachchi
7 people like this
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi
  • A
This topic has been closed for replies.

1 reply

T
Sidekick (Partner)
Forum|alt.badge.img+8
  • Tuukka
  • Sidekick (Partner)
  • 34 replies
  • February 15, 2022

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;

Charith Epitawatta
1 person likes this
  • Charith Epitawatta
    Charith Epitawatta
Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings