v 2.4.20, 2.4.21 and 2.4.22 release notes

CellarTracker Main Site

v 2.4.20, 2.4.21 and 2.4.22 release notes

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Cellar Talk] >> Release Notes >> v 2.4.20, 2.4.21 and 2.4.22 release notes

Page: [1]

Message

<< Older Topic Newer Topic >>

v 2.4.20, 2.4.21 and 2.4.22 release notes - 11/21/2004 10:29:11 PM

Eric

Posts: 5743
Joined: 10/10/2003
From: Seattle, WA
Status: online

REPORTING v2.4.22
(1) I added pivot reports based on purchase data and switched the two existing purchase reports to use this new facility. I also added a time-based pivot just like the consumption summary. I added new filtering support for purchases to let you filter by year, quarter, month, day and day of the week.
(2) You can now also display pending purchases, delivered purchases, and all purchases. (I better integrated the Pending and Purchase views so there is no longer a real distinction, and now advanced filters work.)
(3) Time-based pivots of tasting notes now properly support filtering, and tasting notes can also be viewed by year, quarter, month, day and day of the week.

REPORTING v2.4.21
The pivot reports now allow to specify a wine name and locale as a pivotable field. And for tasting note pivots the name of the tasting note author can be pivoted. I also fixed a bug that could cause pivots on long strings to get a bit jumbled with bizarre, non-tabular layout.

FIT AND FINISH v2.4.21
(1) If you had no wines in inventory and tried to accept a pending purchase, you would receive an error. I have fixed this by pre-populating the Location dropdown with 'Cellar' and also by providing an edit control for people to create new locations.
(2) When accepting a pending purchase you are now taken to to your bottle-by-bottle inventory showing the most recently added bottles. This makes it easier to split a delivery across multiple bins.

MISCELLANEOUS v2.4.20
(1) I resolved a performance problem with the availability report when running it for a single wine, so I have reenabled this on the wine drilldown page.
(2) I spruced up my list of wine definitions to review by also including a column with the number of vintages of a given wine.

_____________________________

Cheers!
-Eric LeVine

Post #: 1

RE: v 2.4.20, 2.4.21 and 2.4.22 release notes - 11/22/2004 7:49:42 AM

PaulH

Posts: 251
Joined: 11/3/2003
From: San Francisco, CA USA
Status: offline

Eric,

A lot of majorly cool stuff! Databases are so cool.

Of course, the sort order on these pivot reports is something people will want to play with. When you pivot the purchase reports by time bucket, it sorts by the amount of purchasing you did, not by date, making it interesting when trying to compare to the consumption report.

(in reply to Eric)

Post #: 2

RE: v 2.4.20, 2.4.21 and 2.4.22 release notes - 11/22/2004 8:09:09 AM

Eric

Posts: 5743
Joined: 10/10/2003
From: Seattle, WA
Status: online

Yes, I am going to do sorting next. The underlying reports already sort it, but it is easy to make bogus sorts that cause things to go haywire. I am going to lock that down and add UI at each level of the grouped report and offer a choice of sorting (various quantities or the actual field itself, ascending/descending).

I will also do consumption pivots and even let people see combined reports.

_____________________________

Cheers!
-Eric LeVine

(in reply to PaulH)

Post #: 3

RE: v 2.4.20, 2.4.21 and 2.4.22 release notes - 1/24/2005 6:44:46 PM

Eric

Posts: 5743
Joined: 10/10/2003
From: Seattle, WA
Status: online

Just closing the loop on all of these old sorting threads. Now dates sort as dates by default. Plus, there is now sorting UI as well.