I have a transaction group pulling information into a table and a report that generates after the process has been completed. The issue that i have is the report has the same data in the report every day and i know the data is changing i can see it in the PLC. Here is what i have I’m also not great at SQL I’m just learning ignition as well.
SELECT Line3CIP.Step_Number AS [Step Number],
Avg(Line3CIP.[Return Temp]) AS [Avg_Return Temp],
Avg(Line3CIP.Conductivity) AS Avg_Conductivity,
Avg(Line3CIP.[Flow Rate]) AS [Avg_Flow Rate],
Min(Line3CIP.Conductivity) AS Min_Conductivity,
Min(Line3CIP.[Flow Rate]) AS [Min_Flow Rate],
Max(Line3CIP.Conductivity) AS Max_Conductivity,
Max(Line3CIP.[Flow Rate]) AS [Max_Flow Rate],
Max(Line3CIP.[STEP Timer]) AS [Max_STEP Timer]
FROM Line3CIP
GROUP BY Line3CIP.Step_Number
ORDER BY [Step Number]