Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query editor errors when referencing previous cells #56

Open
AbelVM opened this issue Nov 6, 2017 · 0 comments
Open

Query editor errors when referencing previous cells #56

AbelVM opened this issue Nov 6, 2017 · 0 comments

Comments

@AbelVM
Copy link

AbelVM commented Nov 6, 2017

Looks like you're not allowed to use aliases. This code fails

SELECT
   b.myvalue
FROM 
    {{myquery}} as b

Wrapping the cell reference within parentheses doesn't work either:

SELECT
   b.myvalue
FROM 
    ({{myquery}}) b

And when you want to reference more than one cell with same columns and need to specify the table name, also fails (circular reference https://github.com/HVF/franchise/blob/master/src/db/generic.js#L98 )

SELECT
   {{myquery1}}.id
   {{myquery1}}.myvalue as val1, 
   {{myquery2}}.myvalue as val2
FROM 
    {{myquery_1}} ,
    {{myquery_2}}
USING (id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant