How to show query result(s) on mobile app

1319
2
Jump to solution
12-09-2014 10:26 AM
MayJeff
Occasional Contributor

I try to populate a lists to show query result(s) on mobile app but not able to do so like the one similar to datagrid.  Here is my JSFiddle:

Edit fiddle - JSFiddle

Can someone show me how to do so?

Thank you.

0 Kudos
1 Solution

Accepted Solutions
HeikoHeijenga
Esri Contributor

The query you send doesn't return any results because the 'where' clause is wrong. You send:

(OWNERNME1) = upper('Katz') OR (OWNERNME1) LIKE upper('Katz%') OR (OWNERNME1) LIKE upper('%Katz%')

it should be:

upper(OWNERNME1) LIKE '%KATZ%'

View solution in original post

0 Kudos
2 Replies
HeikoHeijenga
Esri Contributor

The query you send doesn't return any results because the 'where' clause is wrong. You send:

(OWNERNME1) = upper('Katz') OR (OWNERNME1) LIKE upper('Katz%') OR (OWNERNME1) LIKE upper('%Katz%')

it should be:

upper(OWNERNME1) LIKE '%KATZ%'

0 Kudos
MayJeff
Occasional Contributor

I update the JSfiddle : Edit fiddle - JSFiddle

Now I can see query returns for 15 records.  Here is my problem, I don't know how to make a list to show all the results.  Can you give me some ideas how to do it?  Thank you.

error.gif

0 Kudos