How to show query result(s) on mobile app

Question

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.

HeikoHeijenga · Accepted Answer

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%'