Expression editor : add "order by" / "group by" and "max()"

Expression editor : add "order by" / "group by" and "max()"

Postby nipil » Fri Oct 22, 2010 3:11 pm

Hello, i've been using WoL and EX for quite a time but i am always been wishing for some sql-like group/order/max switches.

For example (using our wednesday log), i'm analyzing Sindragosas' log using : (spell = "Instabilité" and amount > 1 or spell = "Transi jusqu'aux os" and amount > 4 or spell = "Rafale mystique" and amount > 3) and fullType = SPELL_AURA_APPLIED_DOSE and targetType = "Player"

shortened result follows :

[22:32:18.121] Masay afflicted by Instabilité (2) from Masay
[22:32:18.845] Shandryl afflicted by Transi jusqu'aux os (5) from Shandryl
[22:32:19.138] Masay afflicted by Instabilité (3) from Masay
[22:32:19.966] Geitz afflicted by Instabilité (2) from Geitz
[22:32:20.110] Masay afflicted by Instabilité (4) from Masay
[22:32:21.093] Masay afflicted by Instabilité (5) from Masay
[22:32:21.389] Geitz afflicted by Instabilité (3) from Geitz
[22:32:21.618] Shandryl afflicted by Transi jusqu'aux os (6) from Shandryl
[22:32:21.805] Geitz afflicted by Instabilité (4) from Geitz
[22:36:50.755] Kartov afflicted by Rafale mystique (4) from Sindragosa
[22:36:56.867] Kartov afflicted by Rafale mystique (5) from Sindragosa
[22:37:02.857] Kartov afflicted by Rafale mystique (6) from Sindragosa
[22:37:08.857] Sÿndrøma afflicted by Rafale mystique (8) from Sindragosa
[22:37:08.857] Shaynï afflicted by Rafale mystique (4) from Sindragosa
[22:37:08.857] Kartov afflicted by Rafale mystique (7) from Sindragosa

While this result above is usable, there's a relative bunch of uninteresting lines i must read through to find what i'm looking for.

I know the "filter" we enter is something like the "WHERE" clause of the sql request, what i would love to get is the ability to add GROUP BY / SORT BY and MAX etc directives in the query.

I know it could be tricky to implement the MAX/GROUP BY mechanism, as it implies using part of the input text as "select" and another as "where" clauses. But the "ORDER BY" clause is located after the where clause so i guess it could be done in an easier way.

Using this idea, i could get the output like this :

First possibility :
- by using somethine like "order by spell,source,amount"
- without "max/group by" clause

[22:32:18.121] Masay afflicted by Instabilité (2) from Masay
[22:32:19.138] Masay afflicted by Instabilité (3) from Masay
[22:32:20.110] Masay afflicted by Instabilité (4) from Masay
[22:32:21.093] Masay afflicted by Instabilité (5) from Masay
[22:32:19.966] Geitz afflicted by Instabilité (2) from Geitz
[22:32:21.389] Geitz afflicted by Instabilité (3) from Geitz
[22:32:21.805] Geitz afflicted by Instabilité (4) from Geitz
[22:32:18.845] Shandryl afflicted by Transi jusqu'aux os (5) from Shandryl
[22:32:21.618] Shandryl afflicted by Transi jusqu'aux os (6) from Shandryl
[22:37:08.857] Shaynï afflicted by Rafale mystique (4) from Sindragosa
[22:36:50.755] Kartov afflicted by Rafale mystique (4) from Sindragosa
[22:36:56.867] Kartov afflicted by Rafale mystique (5) from Sindragosa
[22:37:02.857] Kartov afflicted by Rafale mystique (6) from Sindragosa
[22:37:08.857] Kartov afflicted by Rafale mystique (7) from Sindragosa
[22:37:08.857] Sÿndrøma afflicted by Rafale mystique (8) from Sindragosa

Second possibility :
- by using somethine like "order by spell,source,amount"
- using "max(amount) and "group by spell,source,amount" clause

[22:32:21.093] Masay afflicted by Instabilité (5) from Masay
[22:32:21.805] Geitz afflicted by Instabilité (4) from Geitz
[22:32:21.618] Shandryl afflicted by Transi jusqu'aux os (6) from Shandryl
[22:37:08.857] Shaynï afflicted by Rafale mystique (4) from Sindragosa
[22:37:08.857] Kartov afflicted by Rafale mystique (7) from Sindragosa
[22:37:08.857] Sÿndrøma afflicted by Rafale mystique (8) from Sindragosa

Do you think it would be interesting too ?
What ca i do in helping it being implemented ?
Or better yet, has it already been implemented and i didn't find how to use it ? ^^
nipil
 
Posts: 230
Joined: Fri Oct 22, 2010 2:49 pm

Return to Suggestions & Feature Requests

Who is online

Users browsing this forum: No registered users and 1 guest