CODEWITHSUNDEEP
javajavascriptjqueryhtml
glenn
glenn

Reputation: 143

jQuery datatables grouping return values

I need to display values on a table which are grouped. Currently I do it manually via two SQL scripts.

Instead of applying these scripts into my dao, can I do it client-side somehow?

Table contents would look like this

fruit name, fruit bought, fruit sold
apple,        1, 0        
apple,        0, 1
orange,       1, 0
orange,       1, 0

Desired result on html table would be.

Fruit name - Fruit bought - Fruits not bought
apples    -   9           -        20
oranges   -  10           -        10

I'm currently using jQuery with datatables.

Upvotes: 1

Views: 446

Answers (1)

Marc B
Marc B

Reputation: 360572

It would be easier to do this at the database level to begin with:

SELECT fruitname, SUM(fruit_bought), SUM(fruit_sold)
FROM table
GROUP BY fruitname
ORDER BY fruitname

Of course, you'd need somewhere to get the original inventory level to calculate your "not sold" value, but this query would give you the sum of the bought/sold values.

Upvotes: 2

Related Questions