These are chat archives for getredash/redash

17th
Jun 2016
Arik Fraimovich
@arikfr
Jun 17 2016 03:21
@Orange19810_twitter maybe build 1959 didn't have this fix yet? Try updating again to latest build.
Mango Baaz
@Orange19810_twitter
Jun 17 2016 07:41
@arikfr 1968 does not as well. Maybe wait for some next one.
Arik Fraimovich
@arikfr
Jun 17 2016 07:51
@Orange19810_twitter then it's probalby something else. can you share the query results?
Siddartha Sekhar Padhi
@sidd607
Jun 17 2016 11:55
is there a way to customize the mail that are sent as alerts ?
Antoine Augusti
@AntoineAugusti
Jun 17 2016 12:12
@sidd607 Nope, you'll need to edit the code. But a PR would be welcome I think
@sidd607 I've sent a PR yesterday about improving Slack notifications for alerts: getredash/redash#1130
Siddartha Sekhar Padhi
@sidd607
Jun 17 2016 12:18
right now if the query returns more than 1 rows, while creating alerts it takes only the first row ans does the comparisons.
is there any way to run the comparison on each column on every row.....
My use case is I get the number of call every user has made in the last 30 mins. I need to create an alert if any of the user has exceeded a threshold ....
How do I achieve this in re:dash alerts?
Antoine Augusti
@AntoineAugusti
Jun 17 2016 12:22
You can tweak your SQL query to match this. Instead of returning the [user_id, number of calls], just return the number of users who've made more than threshold calls. Then tweak your alert to alert you when you've got something > 0
Feels like a hack, but should work
Siddartha Sekhar Padhi
@sidd607
Jun 17 2016 12:23
if I want to know which users have exceed the threshold? can I send this information in the mail itself?
Antoine Augusti
@AntoineAugusti
Jun 17 2016 12:25
Not at the moment I'm afraid :/ But in the alert you'll have a link to the query to start investigating
Siddartha Sekhar Padhi
@sidd607
Jun 17 2016 12:26
thats one way to do it. but it would have been better if I got the info in the mail itself :worried:
Arik Fraimovich
@arikfr
Jun 17 2016 14:28
+1 to @AntoineAugusti suggestion.
You can always write a simple script that pulls the data (or triggered by the alert's webhook) and send a custom email with all the info you might want.
Siddartha Sekhar Padhi
@sidd607
Jun 17 2016 15:08
But those are just workarounds. My requirements was that the system generated alerts and the customer accounts exceeding thresholds are forwarded to business team to handle what is supposed to be done according to the SLAs. I cant let a bunch of business guys meddle around with sql queries on a production server to get the relevant info
It would have been much simpler if I could get the user info itself......
Do you have any plans of implementing something like this is the near future>
?
Arik Fraimovich
@arikfr
Jun 17 2016 15:10

At no point it was suggested that the end user "meddle around with sql queries".

Anyway, there are some plans for additional features for alerts but I don't give ETAs for features I'm not actively working on.

Mango Baaz
@Orange19810_twitter
Jun 17 2016 18:38
blob
Arik Fraimovich
@arikfr
Jun 17 2016 18:38
Strange. Can you try to clear browser cache and then reload the page and see if it gets resolved?
Mango Baaz
@Orange19810_twitter
Jun 17 2016 18:39
@arikfr . I get the above results. As a workaround i changed the date to a varchar and it groups then
hmm yeah i can
Mango Baaz
@Orange19810_twitter
Jun 17 2016 18:49
No luck. did that and then checked it on a different chrome profile
I am guessing your not able to replicate it on your side?