Skip to main content
Solved

Domain constraint - what to expect

  • February 14, 2023
  • 3 replies
  • 117 views
Blommetje
Forum|alt.badge.img+13

Hi, 

I have a table; with a start_date and a end_date column. 
Both are a DATE domain. 

The end_date column has a domain with a constraint on it; start_date < end_date. 

However, I don't see anything happening in the gui. What should it do? 

I assume you know what I want here.. and I would like to display a custom message, explaining what's going on. 

Any advice on this? 

Thanks! 

Alex

Best answer by Arie V

@Blommetje the functionality I would recommend to use for this particular scenario is not mentioned by @Anne Buit: Check constraints! See this great blog, which uses the same scenario as example: 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

3 replies

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Anne Buit
  • Community Manager
  • 653 replies
  • February 14, 2023

Domain input constraints can only perform checks on the input value provided by the user for a field or parameter that uses this domain.

For more dynamic constraints based on interdependency between fields, you’ll have to use other logic types such as Default logic, Handlers, Triggers or Task logic.

Arie V
Community Manager
Forum|alt.badge.img+12
  • Arie V
  • Community Manager
  • 1034 replies
  • Answer
  • February 14, 2023

@Blommetje the functionality I would recommend to use for this particular scenario is not mentioned by @Anne Buit: Check constraints! See this great blog, which uses the same scenario as example: 

 

Anne Buit
Renée Evertzen
2 people like this
  • Anne Buit
    Anne Buit
  • Renée Evertzen
    Renée Evertzen
Blommetje
Forum|alt.badge.img+13
  • Blommetje
  • Author
  • Partner
  • 209 replies
  • February 16, 2023
Arie V wrote:

@Blommetje the functionality I would recommend to use for this particular scenario is not mentioned by @Anne Buit: Check constraints! See this great blog, which uses the same scenario as example: 

 

Ah some light reading for an afternoon. Thanks! I’ll look into it.

@Anne Buit  I have a def_proc, works ok. Was fiddling with stuff. 

Terms & ConditionsCookie settings

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