Announcing Ext JS 3.3 Beta – PivotGrids, Calendars and More
We are pleased to announce the availability of Ext JS 3.3 beta 1 for immediate download. This release introduces great new components and over 160 enhancements and bug fixes.
Download Ext JS 3.3 beta
Introducing the PivotGrid
The first component we’d like to introduce is the PivotGrid. PivotGrids are a data summarization tool that are great for breaking large datasets down into an understandable format.
PivotGrids allow you and your users to summarize data by any number of fields; easily breaking down sales data by city, for example, or by year and quarter. Check out an
example of PivotGrid in action where we summarize sales data.
PivotGrids fit in with your existing Stores and take just a few lines of code to create. We have created a
series of examples demonstrating their varying configurations. Here’s just a quick example of how code to create the above pivot table looks.
var pivotGrid = new Ext.grid.PivotGrid({
title : 'PivotGrid example',
store : myStore,
aggregator: 'sum',
measure : 'value',
leftAxis: [
{dataIndex: 'person', width: 80},
{dataIndex: 'product', width: 90}
],
topAxis: [
{dataIndex: 'year'},
{dataIndex: 'city'}
]
});
Calendar Components
Many in the community have asked for officially supported Calendar components. Calendars are an open-ended problem: there are many ways to implement them and many features that could be added. In Ext JS 3.3 we present new components for displaying events by day, week and month, all combined into a sample application.
As with PivotGrid,
the new Calendar components are powered by the existing data package, which means they fit right in with existing code. We’re not including the calendar components in ext-all.js just yet but include a built version of the components in the examples/calendar directory in the SDK.
Everything Else
In addition to the components above the grid has received a new column type:
ActionColumn. This column type enables you to easily add action icons with a handler function into any grid.
As with every release, backwards-compatibility is a high priority for us; upgrading from 3.1 or 3.2 should be straightforward. To enable PivotGrid a few changes were made to GridView which are known to cause incorrect behavior in certain situations, though these will be addressed before 3.3 final.
We hope you enjoy testing this beta release and look forward to your feedback. Ext JS 3.3 will be the final big release before 4.0 so we wanted to make this one special. We’ll use a slightly longer release schedule than usual to ensure any wrinkles are ironed out for Ext JS 3.3 final.
This entry was posted
on Wednesday, July 28th, 2010 at 1:21 pm and is filed under Ext JS.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Nice! Especially love the ActionColumn!
Excellent! Happy birthday, Ed!
That’s great. Calendar looks pretty sexy
Congratulations guys. That Calendar is a great job!
I know you all worked hard on this!
Waw, two components I was waiting for: the calendar and actionColumn.
thanks guys!
Calendar looks really good!
Thanks for your hard work.
Great work guys!
These new features are fantastic!
Makes me feel bad for using gxt, =]
Thank you!
Action column is just awesome!
Excellent job as usually!
Wow.., it’s great…
Pivot Grid, that’s i’m looking for..
Thanks…
cool, really cool. enjoy it.
Good stuff! One thing that catched my eye though is that there’s no cursor style on actionColumn icons. This should get implemented.
I need Canlendar now, cool.
I’ve been waiting for the action column, really great improvement
Great work guys. Especially the calendar component. I’ve a client torturing me at the moment to include a calendar component and other that writing one from scratch the only viable alternative was the Feyasoft one. Problem is Feyasoft’s one is way too slow and the code is a mess. Good that this has been solved by people who know what they’re doing. (Sorry about the slight slate Feyasoft – your other stuff is great by btw ;-) )
On another note, I was just thing yesterday about how much activity there has been recently RE Sencha Touch, all the HTML 5 blog posts etc. I was kinda getting the feeling that ExtJS was taking a back seat. Possibly exacerbated by the news that Jack was leaving/taking a more backward role. The new beta shows that this in not the case.
Keep up the good work guys. We’ll show those jQuery guys!!!!
Good stuff !! keep up the good work :) i love the calendar and actionColumn
You can read minds. Great work!
Nice one on the PivotGrid. I’m going to test implement it in a reporting tool I was working on. Now the reporting tool generates sql statements with ‘group by’ for row labeling and ‘sum(case when field=value then 1 else 0 end), etc’ for column labeling and to let the server side (mssql) do the hard work. I wonder how the wire and the browser is going to perform making a pivot from let’s say 50.000 records…
@Christiaan
Ouch! You’d better only try that on Chrome!
I’m with @Christiaan
PivotGrid should have a “remote” option so the number crunching is done in the backend for large datasets, specially since sometimes you might want to give only summarized info to the user and keep the full data set private in the server, with the current implementation you have to give all the dataset to the browser.
I just complained but forgot to congratulate the team for the awesome work!!
Congrats! keep up the good work
@Ivan a remote option is a definite possibility for a 4.x release. PivotGrid is fairly computation-heavy so mileage will vary between browsers.
Newer browsers have fast JS engines that can do the math quickly but the overhead could be in sending the unprocessed data over the wire. In one of the examples we have 800 rows of data reduced to just 8 cells – this would be a good candidate for remote execution.
Very nice additions! I really like the PivotGrid and the Calendar. Any chance that a quarterly view might be available soon?
that`s great!!
Great updates, thanks a lot!
Outstanding! Congrats on getting this out. I’ve been looking forward to the pivot grid for a long time and for me it’s a critical component for any real report generation. I think the local data-source restriction is unfortunate for those who need to deal with 100k + records. Hopefully we’ll be seeing a remote version with _some_ type of MDX type querying abilities at some point. Features like baked-in drag-drop for row/column headers and drill-down/drill-up/drill-through would be awesome as well, really taking it ‘to the next level’ allowing us to replace other ‘enterprise’ reporting toolkits.
How will the pivot grid deal with aggregating rates/ratios?
@dreas great suggestion, this has been added and will feature in the next beta release
@Tyson no immediate plans for a quarterly or yearly view
@Leonard we’re assessing the various ways of transporting calculated data over the wire for PivotGrid – stay tuned
@Jacky you can pass a custom aggregation function to the pivot grid and output anything you like. Perhaps you’re referring to calculating all values of all cells and then making the ratio between them available? This isn’t supported yet, but would be great for creating heatmap-like grids
I tried the Pivot Grid component from 3.3 beta release but probably there are some problems with the rows heigth.
If you change the grid height, the rows doesn’t change their height.
@Leonard “allowing us to replace other ‘enterprise’ reporting toolkits.”
YES!
Very well done!
Good News
Fantastic!! When those new features will be avaliable in Ext GWT?? It´s possible to use a mix of GWT and pure Ext??
The ActionColumn finally solves the rowclick vs. rowdblclick problem quickly and elegantly and provides for further expansion of functions called on items in a data grid. It is not dependent upon the OS/Browser click timing. AND we got it just in time to meet an urgent need in my application!
Making the move away from ActiveWidgets was the best thing I’ve done this year!
Fantastic changes…. I love these changes. Calendar component is awesome and Action Column also good…
calendar… awesome..
gotta try fast…
Thank you!
I love Ext and i will use ActionColumn alot because i allready use a simulated ActionColumn nearly in every Ext Project!
God! I love you guys! I can’t wait to add these to my app!
Will PivotGrid allow you to edit the values in the grid? Is there some way to do that?
Good News…
thanks
The calendar really look great. Good job team! Is the beta version fully localized?
Calender and Pivot Grid is looks like pretty cool. Really great job. Thanks all team
“I’ve a client torturing me at the moment to include a calendar component and other that writing one from scratch the only viable alternative was the Feyasoft one. Problem is Feyasoft’s one is way too slow and the code is a mess. Good that this has been solved by people who know what they’re doing. (Sorry about the slight slate Feyasoft – your other stuff is great by btw ;-) )”
There is also the issue of recurrence – I have not seen any support for recurrence in the calendar and this is a must – I guess a lot of it is done on the server, but there are a few things for the ext layer like spanning days and such.
Anyways great work and I hope recurrence is being thought on.
@Kevin: Edit aggregated data???
The CalendarPicker needs a little polishing .
When switching between day/week/month views the selected date is not passed to the new view.
@Dan we just released 3.3 beta 2 with updated Calendar controls – check it out at http://www.sencha.com/blog/2010/08/12/ext-js-3-3-beta-2-released/
I would like to thanks ExtJS team for this great work.
Rally I like calender component and action column.
Thanks a lot.
Keep it up. Thanks
@Christiaan: The data in my case won’t actually be aggregated- there will be only one value for each row/column intersection but I need to use PivotGrid’s ability to have multiple row headers and column headers that can be reconfigured on the fly. I haven’t found any other grid type that can do that.
Pivot Grid are excelent, Do they have plans to incorporate it in GXT?