These are chat archives for getredash/redash

4th
Aug 2015
marcobu
@marcobu
Aug 04 2015 08:43
@arikfr is there a way to make any filter optional in a query with filters? e.g. if the filter is empty, list all the possible values for that filter.
rm420
@rm420
Aug 04 2015 08:43
@arikfr Hey man, do you know if the filters/parameters feature works with BigQuery? Seem to be getting some strange errors
Arik Fraimovich
@arikfr
Aug 04 2015 08:45
@rm420 filters can't work because BigQuery doesn't support "::" in field names, but I'm going to fix this later this week (by switching to different convention). But parameters should work -- what error are you getting?
@marcobu hmm... need to think about it. meanwhile, what I saw people are doing is just "merge" two queries using UNION ALL, where one is filtered and the other has all values
rm420
@rm420
Aug 04 2015 08:52
@arikfr It's just saying I'm missing values for parameter
Arik Fraimovich
@arikfr
Aug 04 2015 08:52
@rm420 and you're passing them in the URL?
Arik Fraimovich
@arikfr
Aug 04 2015 08:53
@rm420 you need to prefix with "p_" so it becomes: http://redashurl.com/queries/13?p_sNumber=sdf434rds3
rm420
@rm420
Aug 04 2015 08:54
Cheers mate, my bad!
Arik Fraimovich
@arikfr
Aug 04 2015 08:54
np