AutoCompleteTextView with volley with text filter

Question

I'm trying to filter my data from sql table. This in my query.

SELECT TOP 10 ItemCode, ItemName 
    FROM [mytable]
WHERE ItemCode like '".$q."%' order by CreatedDate desc

here is my volley

private void getItem(String s){
    JsonArrayRequest postRequest = new JsonArrayRequest (Request.Method.GET, "http://192.168.3.9/api/welcome/getItem/"+s,null,
            new  Response.Listener<JSONArray>()
            {
                @Override
                public void onResponse(JSONArray  response) {
                    try {
                        if (itemList == null) itemList = new ArrayList<>();
                        itemList.clear();
                        for(int i = 0; i < response.length(); i++){
                            Item_model m_item = new Item_model();
                            List<String> list = new ArrayList<String>();
                            m_item.setItemCode(response.getJSONObject(i).getString("ItemCode"));
                            itemList.add(m_item);
                        }
                         itemcode.setAdapter(adapter);
                        adapter.notifyDataSetChanged();
                    } catch (JSONException e) {
                        e.printStackTrace();
                    }
                }
            },
            new Response.ErrorListener()
            {
                @Override
                public void onErrorResponse(VolleyError error) {
                    Log.d("ErrorResponse", error.toString());
                }
            }
    );
    postRequest.setRetryPolicy(new DefaultRetryPolicy(0, DefaultRetryPolicy.DEFAULT_MAX_RETRIES, DefaultRetryPolicy.DEFAULT_BACKOFF_MULT));
    postRequest.setTag("GetItem");
    queue.add(postRequest);
}

i call the getItem inside onCreateView

 public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) { 
        getItem("");
}

for now my code is working fine, because i want to filtering so i using TextWatcher, Here is what i do.

itemcode.addTextChangedListener(new TextWatcher() {
            @Override
            public void beforeTextChanged(CharSequence s, int start, int count, int after) {

            }
            @Override
            public void onTextChanged(CharSequence s, int start, int before, int count) {

            }
            @Override
            public void afterTextChanged(Editable s) {
                search = s.toString();
                getItem("");
                adapter.getFilter().filter(search);
            }
        });

when i implementing my script above, my autocompletetext view not showing any data, how can i fix it ?

My json

[{"ItemCode":"IT001","ItemName":"Blue Hat"},{"ItemCode":"IT002","ItemName":"Black Hat"}]

i get this error `java.lang.IllegalArgumentException: column 'name' does not exist. Available columns: [_id, ItemCode, ItemName] `, do i need use custom adapter ? — Boby, Nov 30 '18 at 09:32
@MarkusPenguin it happens when i try pskink way, using cursor adapter — Boby, Dec 03 '18 at 08:11

score 0 · Accepted Answer · answered Dec 04 '18 at 05:46

I already fix it with @pskink way. I don't use customadapter.

My Final code for autocomplete is like this

itemcode = v.findViewById(R.id.ItemCodeInput);
        itemcode.setThreshold(1);
        String[] from = { "name", "description" };
        int[] to = { android.R.id.text1, android.R.id.text2 };
        SimpleCursorAdapter a = new SimpleCursorAdapter(getActivity(), android.R.layout.simple_list_item_2, null, from, to, 0);
        a.setStringConversionColumn(1);
        FilterQueryProvider provider = new FilterQueryProvider() {
            @Override
            public Cursor runQuery(CharSequence constraint) {
                if (constraint == null) {
                    return null;
                }
                String[] columnNames = { BaseColumns._ID, "name", "description" };
                MatrixCursor c = new MatrixCursor(columnNames);
                try {
                    String urlString = "http://192.168.3.223:84/lesfemmesapi/welcome/getItem/"+constraint;
                    URL url = new URL(urlString);
                    InputStream stream = url.openStream();
                    BufferedReader reader = new BufferedReader(new InputStreamReader(stream));
                    String jsonStr = reader.readLine();

                    JSONObject result = new JSONObject(jsonStr);
                    JSONArray jArray =  result.getJSONArray("dataItem");
                    for(int i = 0; i < jArray.length();i++) {
                        JSONObject detail = jArray.getJSONObject(i);
                        c.newRow().add(i).add(detail.getString("ItemCode")).add(detail.getString("ItemName"));
                    }

                } catch (Exception e) {
                    e.printStackTrace();
                }
                return c;
            }
        };
        a.setFilterQueryProvider(provider);

AutoCompleteTextView with volley with text filter

1 Answers1