Forum | Appery.io

getting different results on appery than on android. my app works using the appery test function but not in the android tester nor as an apk uploaded to my android. Where in appery the results of a database query print to screen, these results don't appear in the android app nor the tester.

Also, assuming i do get this working on both platforms how do you tell the query service that if a data field is empty to not print anything?

Hello William,

Can you show how you implement the output to the screen from the service? Some code examples.

[quote:]
Also, assuming i do get this working on both platforms how do you tell the query service that if a data field is empty to not print anything?
[/quote]
You can make it using JavaScript.

using query service - "edit Js" - return '{"sample_id":{"$regex":"^'+value+'", "$options":"i"} }'; Also my source is an input

Separately...

my csv file has this format:
A B C
1 2 3
4 5
so naturally I'm getting "undefined" under the 3rd col second row on C.. but is there a way to list results in a way so as to not print when query finds an empty value? It seems like a simple if statement should do but I'm not familiar with jscript.

First image (jpg) is the appery tester.

Second Image (png) is an android screenshot.

Using the same example from above.. how do I extract headings from the csv file and locate them as headers .

TYPE 1 TYPE 2 TYPE 3

Using the same example from above.. how do I extract headings from the csv file and locate them as headers so it looks like this...

TYPE I TYPE 2 TYPE 3
approach socal aaa
approach socal bbb
...

Hello William!

[quote:]

but is there a way to list results in a way so as to not print when query finds an empty value?

[/quote]
Do you mean skip it and print on its place the next value?

As a workaround you can make two rows of headings:
the first will be heading for Database,
the second - data which you can extract.

Hi Alena.. ok at least I have the db reading out on my android now. Solution = don't use button groups like radio / select / check etc. I put 3 individual buttons in a grid with 1 row 3 cols and that seems to work.

Answering your question: Skip would be fine or print an empty value - anything as long as I don't get "undefined" printing out when it encounters a field in the database without a value in it.

Come to think of it I guess I could load the alt-255 null character in the csv file.. but is there another way?

Solved the first part of this problem:

don't use button groups like radio / select / check etc. I put 3 individual buttons in a grid with 1 row 3 cols and that seems to work.

Now to figure out how to insert headings above the database readout.

ill try that.. thanks