filter fusion tables

[marc....@gmail.com]

I've tryed to create a filter in a fusion table (following sintax of google) but it doesn't work. Can you help me please?

[SteveJG]

Is this what you are looking for?

https://support.google.com/fusiontables/answer/171203?hl=en&ref_topic=2572108

Your question does not tell us a lot about what you are trying.  Filter in app; filter from the Dropbox?

-- SteveJG

[Taifun]

you might want to provide a screenshot of your relevant blocks

Taifun

---

Trying to push the limits of App Inventor! Snippets and Tutorials from Pura Vida Apps by Taifun.         

[marc....@gmail.com]

I want to filter using the column number

[Taifun]

to find out, if the sql syntax is correct, right click onto the join block and select "Do it"

then provide another screenshot including the Do it result and a screenshot of your error message

did you already do the Pizza Party tutorial?

Pizza Party with Fusion Tables for App Inventor 2

Taifun

[marco telesca]

it says Do It Result: SELECT * FROM 1g1M3fl5pvX99IrBOmDovcSMseWcaR59yBkQgmjAy WHERE Number >= 4 ---

[Taifun]

it says Do It Result: SELECT * FROM 1g1M3fl5pvX99IrBOmDovcSMseWcaR59yBkQgmjAy WHERE Number >= 4 ---

this looks fine... it is important to not forget spaces where necessary, but everyting looks fine...

now what is your error message?

I'm assuming, that the Number columns is defined as number and not text?

A screenshot could help to find the problem easier...

Taifun 

[Taifun]

please keep the discussion in the forum! 

first do the Pizza Party tutorial to learn how everything works!

Pizza Party with Fusion Tables for App Inventor 2

and then if you still have problems, provide

1. a screenshot of your relevant blocks

2. a screenshot of your error message

Thank you.

Taifun

[callum...@gmail.com]

hi i have a similar problem when trying to filter a fusion table in app inventor 2. i get a 400 bad request. Parse error near '&#39 (im sorry i cant get a screenshot of it at the moment). my code is attached.

[Taifun]

to find out, if the sql statement is correct, right click onto the join block of the sql statement and select do it then post a screenshot incl. the Do It result...

however if it works, currently you will get this error: https://groups.google.com/forum/#!category-topic/mitappinventortest/dkEZZJ7PIx0

Taifun

[callum...@gmail.com]

I have done that and this is the result. it gives me a:

400 Bad Request

Invalid query: Parse error near 'of' (line 1, position 66)

the do it result is attached.

[Taifun]

ok, let's understand, what the error message says: parse error near "of"

which means, spaces in column names in queries are not permitted, you have to quotify them like this

... WHERE 'Type of Fixture'='Football'

Taifun

[callum...@gmail.com]

thank you so much it works perfectly now i've been stuck on that for ages