Skip to main content
Answer

Domain constraint - what to expect

  • February 14, 2023
  • 3 replies
  • 118 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: 

 

This topic has been closed for replies.

3 replies

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Anne Buit
  • Community Manager
  • 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
  • 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
Blommetje
Forum|alt.badge.img+13
  • Blommetje
  • Author
  • Partner
  • February 16, 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: 

 

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 settingsAccessibility statement