We have a table with a column called 'result' and a column called 'resultOORIndicator'. Because of the latter, LK automatically appends the OOR indicator (ie. < or >) to the result when displaying it. In general, when you have a query that SELECTs from this source table, if you also include resultOORIndicator in that select, then LK will preserve the magic behavior. The table in question is an assay results domain, fwiw.

I'd like to make a PIVOT query based on this raw table. The pivot query has a GROUP BY on this table. When I do this, LK no longer automatically append the OOR indicator. I can manually do this in my SQL, but that's a little awkward and doesnt preserve the datatype (need to cast to varchar). Is there any way to preserve OOR indicator behaior when grouping data? Thanks in advance.