Help with simple Pizza Party query please

[Burt Lewis]

Hi,

I completed the Pizza Party sample without any problems and now I wanted to try to query the fusion table by searching for specific items. In this case after I press the Submit button,  I want to see in the webviewer, all items in the Pizza column that have Cheese. When  I run this app from my phone, I get the entire table, not just the rows with Cheese. I know I'm doing something wrong but after quite a bit of time looking for examples and trying things myself, I'm stuck. Appreciate any help or ideas. Thank you.

[Taifun]

1. do not use the DoQuery block, because that block is deprecated

2. you will get the result of your query in the FusiontablesControl.Got result event, to display the result, you could use this example

App Inventor and dynamic table layout with any number of rows and columns

alternatively if you like to display the result in the webviewer directly, you have to modify the URL of the webviewer accordingly

Taifun

---

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

[Taifun]

here is an example of a modified URL, which could be displayed with the webviewer directly

https://fusiontables.googleusercontent.com/fusiontables/embedviz?viz=GVIZ&t=TABLE&q=select+*+from+1Ty90w_LWJEgZHNwEWgoebigLDEXPYLAgJHVHSFkk+WHERE+Pizza+%3D%27Cheese%27&containerId=googft-gviz-canvas

Taifun

[Burt Lewis]

Taifun,

Thank you for your help but my attempt at modifying the code to the example you pointed me to resulted in nothing being displayed in the webviewer. I also don't understand how I apply your example of the modified URl code to my code example. Thank you.

[Taifun]

if you take a closer look at the URL, you will find,out, that there are 3 parts

1. it starts with https://fusiontables.googleusercontent.com/fusiontables/embedviz?viz=GVIZ&t=TABLE&q=

2. followed by an URI encoded select statement, which is in my case select+*+from+1Ty90w_LWJEgZHNwEWgoebigLDEXPYLAgJHVHSFkk+WHERE+Pizza+%3D%27Cheese%27

which is nothing else than the URI encoded select statement you are looking for SELECT * FROM <tableid> WHERE Pizza = 'Cheese'

for the URI encoding you can use the URI encode block of the web component or you can do it manually

3. followed by &containerId=googft-gviz-canvas

just use your table id instead of mine, that's all...

the URL for the webviewer is the complete string, see again the example https://fusiontables.googleusercontent.com/fusiontables/embedviz?viz=GVIZ&t=TABLE&q=select+*+from+1Ty90w_LWJEgZHNwEWgoebigLDEXPYLAgJHVHSFkk+WHERE+Pizza+%3D%27Cheese%27&containerId=googft-gviz-canvas

Taifun

[Burt Lewis]

I thank you again and understand that is the end result url but it doesn't help me modify my block code that I included to indicate why it is not working when I run it on my phone. Are there any other visual code example you can point me to? I have yet to find one example that does a simple search and returns a result to the phone screen. Thank you!

[Taifun]

if you don't understand what I was saying, let me recommend you to first do the tutorials http://appinventor.mit.edu/explore/ai2/tutorials.html to learn the basics of App Inventor, then try something and follow the

 Top 5 Tips: How to learn  App Inventor

also probably it's easier for you to follow the first option using the fuisiontable ocntrols, see also How to INSERT, DELETE and SELECT a Fusiontable by Viktor

[Burt Lewis]

I understand exactly what you are saying but I am not looking for a URL, I am looking for help specific to the code images I included in my posts to understand why it's not working and what I have done wrong. It's like me asking you how to fish and you hand me a fish, that's not what I want. I've gone through every tutorial, I guess I'll have to keep plugging away it. Thanks.

[Taifun]

then you should prepare a new screenshot and add all information I gave you...

I can't see the complete URL in the webviewer.HomeUrl in your screenshot, I only can see the SELECT statement in your variable pizzatable...

Taifun

[Burt Lewis]

OK thank you. Here is the latest screen shot, I hope it helps. I've tried many different combinations.Thanks!

[Taifun]

you are mixing 2 different solutions

1. the fusiontable controls solution according to this example How to INSERT, DELETE and SELECT a Fusiontable by  Viktor and

2. the webviewer URL solution

"here is your fish" for the webviewer URL solution, just add your table id instead

Taifun

https://fusiontables.googleusercontent.com/fusiontables/embedviz?viz=GVIZ&t=TABLE&q=select+*+from+1Ty90w_LWJEgZHNwEWgoebigLDEXPYLAgJHVHSFkk+WHERE+Pizza+%3D%27Cheese%27&containerId=googft-gviz-canvas

[Burt Lewis]

Thank you for all your help. This is exactly what I was looking for.

[Emeka Ezeanya]

Thanks Taifun, I was able to modify the webviewer url and it gave me exactly what I wanted. Thanks!!!!