Skip to main content
Completed

Conditional layout null value comparison

Related products:Software FactoryUniversal GUI
Bart Metselaar
Dennis van Leeuwen
Freddy
Arie V
C. Lousberg
+2
  • Bart Metselaar
    Bart Metselaar
  • Dennis van Leeuwen
    Dennis van Leeuwen
  • Freddy
    Freddy
  • Arie V
    Arie V
  • C. Lousberg
    C. Lousberg
  • Marius Korff
    Marius Korff
  • Ionut
    Ionut

I have made a Conditional layout rule that highlights values in the (nullable) Year end and Year end old columns if they are different, the condition being specified as such:

This produces the following result in the application. 

I think it is unintuitive that the two null values get marked as Not equal to each other. I understand this is how sql works, and I think it would be useful to allow tsf users to specify that null values should be marked as not equal to each other.

This could be done with a manual null check:

t1.year_end = t1.year_end_old or (t1.year_end is null and t1.year_end_old is null)

for Equal to, or simply something like 

isnull(t1.year_end, '') = isnull(t1.year_end_old, '')

This option to enable Null value comparison in this way would be toggleable with a checkbox.

Did this topic help you find an answer to your question?

4 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Alternatively you could create an expression field that has the value 1 is this condition is met or else return 0. Then in the Conditional layout condition use that field. Not the prettiest of solutions but it is one:wink:


Mark Jongeling
Administrator
Forum|alt.badge.img+23
Updated idea statusNewOpen

Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • November 27, 2024

This is fixed since the 2024.3.11.0 release of the Universal GUI.


Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • November 27, 2024
OpenCompleted

Reply


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