Ask Your Question

I need status change activity by day

asked 2020-04-03 13:21:07 -0600

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 retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-04-06 13:05:06 -0600

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 delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-03 13:21:07 -0600

Seen: 549 times

Last updated: Apr 06 '20