KLK
June 20, 2018, 8:58am
1
Hey guys,
I am quite new to Metabase, but already am using category widgets on multiple occasions with no problems. Lately I had to create a question in standard SQL with three joined tables.
Unfortunately the category field filter fails with this questions as I try to search for a specific value (for example a specific University). Any ideas why?
EvaS
June 20, 2018, 9:03am
2
Hi,
it maybe has to do with this issue - as you seem to use aliases as well:
Hi, I’ve this query:
SELECT c.business_name,b.lastname, b.firstname,(a.tot_time*b.costo_orario_ordi) as Costo FROM db_summary_syn a
LEFT join users b ON a.codfis=b.codfis
LEFT join db_companies c ON a.idcompany=c.id
WHERE b.onoff=1
[[ AND {{v_lastname}}]]
[[ AND {{v_firstname}}]]
[[ AND a.dataora={{v_dataora}}]]
ORDER BY c.business_name,b.lastname, a.dataora
v_lastname and v_firstname are linked to users.firstname and users.lastname.
When I select a value from this two value and run qu…
Let me know if it works without aliases!
Cheers, Eva
KLK
June 20, 2018, 9:49am
3
Hi EvaS,
Thank you for a quick reply!
As I am using at the begging:
WITH
all_products AS (
SELECT
it just seems that aliases are inevitable. Any idea if this bug is on the pipeline for future realises?
Thanks!
EvaS
June 20, 2018, 9:59am
4
Hi,
I guess then you have to rebuild your sql code to avoid that … but you should vote on the github issue to push it forward:
Cheers, Eva
1 Like