Skip to main content
Completed

Conditional layout null value comparison

Related products:Software FactoryUniversal GUI
Jeroen van den Belt
Mark Jongeling
Jaap van Beusekom
Geurt
eurban
+12
  • Jeroen van den Belt
    Jeroen van den Belt
  • Mark Jongeling
    Mark Jongeling
  • Jaap van Beusekom
    Jaap van Beusekom
  • Geurt
    Geurt
  • eurban
    eurban
  • Erwin Ekkel
  • mperrott
    mperrott
  • antonn_a
  • dcharalampous
  • Suleyman
  • Marc Ferket
  • Shawn Adrian Diño
  • WarrenM
  • Jason Philip A Mortera
  • Spyros.Neofytou
  • AndreKemmeren
    AndreKemmeren
  • Marius Korff
    Marius Korff

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

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