How to only show specific elements in a CursorAdapter

Question

I have a custom CursorAdapter that is taking items from a database and displaying them in a listview. If possible, I would like to display only certain elements based on some boolean value within a database element. Here is something similar to what I would like to do:

package itp.uts.program;

import android.content.Context;
import android.database.Cursor;
import android.graphics.Color;
import android.graphics.Typeface;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.CursorAdapter;
import android.widget.TextView;
//Adapter tests if an element is read or unread, and bolds the items that are unread
public class BoldAdapter extends CursorAdapter{

private final LayoutInflater mInflater;
public BoldAdapter(Context context, Cursor c, boolean autoRequery) {
    super(context, c, autoRequery);
    mInflater = LayoutInflater.from(context);
}
public BoldAdapter(Context context, Cursor c) {
    super(context, c);
    mInflater = LayoutInflater.from(context);
}
@Override
public void bindView(View view, Context context, Cursor cursor) {

}
@Override
public View newView(Context context, Cursor cursor, ViewGroup parent) {
    //Creates a view to display the items in
    final View view = mInflater.inflate(R.layout.notes_row, parent, false);
    TextView textRequestNo = (TextView) view.findViewById(R.id.text1);
    TextView textMessage = (TextView) view.findViewById(R.id.text2);
    StringBuilder requestNo = new StringBuilder(cursor.getString(cursor
            .getColumnIndex("requestNo")));
    StringBuilder message = new StringBuilder(cursor.getString(cursor
            .getColumnIndex("Message")));

    //Sets the text fields as elements from the database
    textRequestNo.setText(requestNo);
    textMessage.setText(message);

    if (cursor.getString(cursor.getColumnIndex("Read")).equals("true"))
    {//Tests if the item is unread
        **//DO NOT SHOW THE ELEMENT, HOW DO I DO THIS?**
    }

    return view;
}

}

Answer 1

just return a View and set it's visibility property to VIEW.GONE

Answer 2

Ideally, you just filter out the rows you don't want in your database query.

If, for whatever reason, that is not possible, create a wrapping adapter that filters out the rows you do not want. Here is an AdapterWrapper base class you can use to help.