First time here? Check out the FAQ!

I need status change activity by day

I need to create a report showing the number of listings that went to any of the statuses on a given day

I can pull history but need a way to determine when a status is changed, since some listings with go back and forth among statuses in a single day

I am loading the history records in a sql database if that helps.

edit flag offensive 0 remove flag close merge delete

Comments

Sort by

I would create a table with listingid, status, previousStatus, datetime, price

when searching for records, check if the status has changed, if it has insert into the new table.

edit flag offensive 0 remove flag delete link

here is how