Sigma Php Ajax framework, Ajax Components, GUI Builder
May 16, 2012, 11:54:59 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Column Aggregate functions in version 2.2  (Read 741 times)
PENDRAGON
Jr. Member
**
Posts: 5


View Profile
« on: July 09, 2009, 05:35:11 PM »

I've scoured the forums and docs for the 'sum' aggregate function that was available in version 1.7.  I saw the post that said it was missing from version 2.0 but would be back in future versions.   Is it present in 2.2 in a way that functions like the version 1.7 example ( http://www.sigmawidgets.com/products/sigma_grid/demos/example_aggregate.html ).

I load data in dynamically (PHP) and use var gridOption and var colsOption to define variables so I'm not sure if I add a "var context" as in the 1.7 example where I call it. I assume I put it as a key : value pair under gridOption but not sure.

My colsOption variable defines columns with an "id:" tag and not a "name:" tag as referenced in the 1.7 Aggregate example.  I assume I could just add a "name:" identifier for each column that I wanted to reference for aggregation.

Here's how I call the grid now:
var mygrid=new Sigma.Grid( gridOption );

Any help to get to the exact functionality of the 1.7 demo above would be great.
Logged
pkariuki
Newbie
*
Posts: 1


View Profile
« Reply #1 on: August 14, 2009, 12:24:16 AM »

I'm face with a similar problem and I would wan to find out whether there was a solution, I wound want to aggregate columns and I do not seam to find out how.

Logged
cucux
Newbie
*
Posts: 1


View Profile
« Reply #2 on: January 20, 2012, 05:49:19 AM »

I am sorry for this response so late.
I tried your grid and its look nice.
Today I just figure out how to make my subtotals.

Perhaps a lot of people want the aggregate function in grid.
I found a way that i can make a lot of subtotals and i can show them in the bottom of grid or in the top o the grid.
Basicaly I create 2 arrays from my database.
First is with actualy data that I need to show in grid and seccond with my subtotals.

The arrays must be the same in order to concatenate them.



An example is in picture below.

[IMG=http://img543.imageshack.us/img543/6400/69288158.jpg][/IMG]

Uploaded with ImageShack.us
« Last Edit: January 20, 2012, 05:56:01 AM by cucux » Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!