0
 Followers
1
 Like

GroupBy Widgets Requirement

Backend
New

Hi Team,


As we know in out systems we didn't required SQL knowledge because we are working with aggregates.


But some times my aggregates is too complex with the no of join and output of all columns....Now if someone don't have knowledge of SQL then its really tough job to apply group by.


What i think if we provide new widgets or server action then its going to be easy task to handle group by.


Expectation:

GroupBy Widget:

1. Take input as a list of data.

2. Group by columns(Take at-least one and max=n no.)

3.Having condition(Optional)

4. In output provide option to choose aggregates function like Sum,Max,Min or Count etc.

Based on above condition my "GroupBy" widget return appropriate result.

Note:Easily doable using extension.

Thanks,

Jitendra




Created on 15 Aug 2018
Comments (3)

Doing a GROUP BY after retrieving the data would be extremely inefficient. You could be pulling hundreds... thousands... even millions of records from the database and then processing them in memory on the app server, which usually has a lot LESS RAM than the DB, won't be able to make use of indexes, and isn't a purpose-built processing engine for this like a DB is.

J.Ja

Hi James! You are absolutely correct...but we need some way to deal with group by.

Changed the category to Backend


views
187
Followers
0