#207 show training barometer status in grid

[plaursen]

Show colored indicator with pilot name in grid. Color as TrainingBarometer.

[plaursen]

mht performance: den gør nogenlunde hvad jeg havde forventet, en explicit WHERE x IN (). Det ser da ret rimeligt ud (men hold nu kaje for nogle queries vi skyder af...)

SELECT [Extent1].[FlightId] AS [FlightId], [Extent1].[Date] AS [Date], [Extent1].[Departure] AS [Departure], [Extent1].[Landing] AS [Landing], [Extent1].[LandingCount] AS [LandingCount], [Extent1].[PlaneId] AS [PlaneId], [Extent1].[PilotId] AS [PilotId], [Extent1].[PilotBackseatId] AS [PilotBackseatId], [Extent1].[StartTypeId] AS [StartTypeId], [Extent1].[StartedFromId] AS [StartedFromId], [Extent1].[LandedOnId] AS [LandedOnId], [Extent1].[TachoDeparture] AS [TachoDeparture], [Extent1].[TachoLanding] AS [TachoLanding], [Extent1].[TaskDistance] AS [TaskDistance], [Extent1].[Description] AS [Description], [Extent1].[BetalerId] AS [BetalerId], [Extent1].[StartCost] AS [StartCost], [Extent1].[FlightCost] AS [FlightCost], [Extent1].[TachoCost] AS [TachoCost], [Extent1].[Deleted] AS [Deleted], [Extent1].[LastUpdated] AS [LastUpdated], [Extent1].[LastUpdatedBy] AS [LastUpdatedBy], [Extent1].[RecordKey] AS [RecordKey], [Extent1].[HasTrainingData] AS [HasTrainingData] FROM [dbo].[Flights] AS [Extent1] WHERE ([Extent1].[Deleted] IS NULL) AND ([Extent1].[PilotId] IN (11, 9, 10)) AND ([Extent1].[Date] >= @plinq0) AND ([Extent1].[Date] < @plinq1) Parameters: plinq0 = 24-03-2021 13:39:07 plinq1 = 24-03-2022 00:00:00