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:
Can someone show me how to do so?
Thank you.
Solved! Go to Solution.
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%'
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%'
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.