Reset Value

We have created a group in factory sql and table in mysql for the corrosponding group. In factory pmi i have textbox,
for the textbox i have written a sql query to calculate the sum of column and display the value in the text box. I need to reset the textbox value based on the date and time for every day (at 12.00 pm).


If you are using MySQL, change your query to read

SELECT IFNULL(SUM(some_column),0) FROM some_table where date(t_stamp) = date(now())

I dont know the corresponding query in MSSQL though.

How do i reset the value using factory pmi and not using sql.

I believe that the answer above was referring to a query you’d use in a FactoryPMI query binding to calculate the display value for the text box.