Since upgrading to 9.0r2, I noticed that it is no longer possible to filter transactions by a custom date range. It makes checking a range of transactions past 28 days impossible.
The newer control it looks is not very intuitive. You can select a date in the month grid, then hold the shift key and select another day in the same month. I'm not finding a way to select multiple days across multiple months though. :\
Which version did you last do this in?
You can use the Pharos Reports application to run a report on Transaction between to dates.
Which would be the reason I had totally forgotten you could list transactions while in Administrator. I've always been using Reports which has the added benefit of easily outputting the data to a file.
- Paul L.
Jeff, since you were wondering about versions, the last version to have the older and more flexible date selection was 8.3 SP1.
I am on version 9.0r2 but before that we were on 8.x. The earlier version allows a custom date range as large as you want but not 9.0r2. That loses a lot of functionality. Our library uses Sign-Up for our public guest computers and expire the accounts on a rolling calendar year. Difficult to do now. Would also be nice if I could see when a user account was created without having to do a SQL query.
Yes, to all of the above, but if I am trying to find a group to archive by date range, that is no longer possible. Our database has gotten very large for a small organization and we are trying to archive the users who haven't been active for over 2 years. With the change in how transactions are viewed in Administration, it is now close to impossible to do this efficiently. And the information links to too many tables to try to do a SQL delete. Thanks for the feedback.
I was hoping you'd receive an answer to the question about archiving users who haven't been active for over 2 years. I'd like to do the same.
I remember a few years back when we were doing significant upgrades to our systems there was a step we did that effectively removed the usernames that had not seen any activity for more than a specific time... but I can't seem to find my notes on that.
I hope you get the desired info. I'd like to get the same. It's a very good housekeeping thing to do periodically.
My "two bits" on the subject.
I ultimately had to go into the transactions menu and archive and remove all transactions prior to a certain date. Had to do multiple times as Pharos for some reason did not "catch" everything. Then did a SQL delete to remove the users with no activity prior to that date (which is where I realized the archive and remove didn't work as predicted). Thankfully, SQL 2016 won't let you break integrity between the tables. so it was easier than it might have been. But I ended up with a nice clean database.
Retrieving data ...