Solved

Domain constraint - what to expect

  • 14 February 2023
  • 3 replies
  • 108 views
Blommetje
Userlevel 5
Badge +12

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

icon

Best answer by Arie V 14 February 2023, 23:50

View original
This topic has been closed for comments

3 replies

Anne Buit
Rank
Userlevel 7
Badge +5

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.

A
Rank
Userlevel 6
Badge +10

@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: 

 

Blommetje
Userlevel 5
Badge +12

@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