How to sort results on android from SQLite?

Question

i need to display multiple database tables to seperate textviews.

So i need to pull all 'appointments' from a table and sort them to display in separate textviews on the mainActivity such as txtMonday, txtTuesday, txtWednesday

The database is designed to store the day along with the other details:

private static final String DATABASE_CREATE =
        "create table " + TABLE_AP + "(" + COLUMN_ID + " integer primary key autoincrement, "
        + COLUMN_DAY + " text not null, "
        + COLUMN_TIME + " text not null, "
        + COLUMN_DURATION + " text not null, "
        + COLUMN_DESCRIPTION + " text not null);";

This is how i attempt to call it through MainActivity: (I also will be calling it with onCreate)

  public void onResume (){
      APData = new AppointmentDataSource(this);
      APData.open();
      List<Appointment> appointments = APData.retrieveAllAppointments();
      APData.close();

AppointmentDataSource:

public List<Appointment> retrieveAllAppointments () {
    List<Appointment> appointments = new ArrayList<Appointment>();

    Cursor cursor = database.query(MySQLiteHelper.TABLE_AP, , null, null, null, null, null);

    cursor.moveToFirst();


    while (!cursor.isAfterLast()) {
        Appointment ap = cursorToBk(cursor);
        appointments.add(ap);
        cursor.moveToNext();
    }

    cursor.close();
    return appointments;        
}

Also for the days, i used radio buttons to choose between monday / tue / wed / thur / fri so i store the day with :

createButton.setOnClickListener(new View.OnClickListener() {

      @Override
      public void onClick(View view) {
        findRadioGroup = (RadioGroup) findViewById(R.id.radioDay);
        int selectedId = findRadioGroup.getCheckedRadioButtonId();
        radioButton = (RadioButton) findViewById(selectedId);


        String day=radioButton.getText().toString();
        String time=txtTime.getText().toString();
        String duration=txtDuration.getText().toString();
        String description=txtDescription.getText().toString();

        APData.insert(day, time, duration, description);
        APData.close();
        finish();
      }

    });

and the XML/strings for them:

<string name="RadioMon">Mon</string>
<string name="RadioTue">Tue</string>
<string name="RadioWed">Wed</string>
<string name="RadioThu">Thur</string>
<string name="RadioFri">Fri</string>

I dont understand what you want to sort? explain better please — OschtärEi
– OschtärEi, Commented Apr 11, 2013 at 12:27
The last argument of the query method of SQLiteDatabase holds the "orderBy" parameter of the SQL function. More infos here: developer.android.com/reference/android/database/sqlite/… — AlexVogel
– AlexVogel, Commented Apr 11, 2013 at 12:43
Ah sorry Tenhouse, I want to sort them by day, and put the Time / duration / description under the correct textview day — user2253722
– user2253722, Commented Apr 11, 2013 at 13:20
But how will i be able to use 'OrderBy day' to separate the rows to the individual day textviews. — user2253722
– user2253722, Commented Apr 11, 2013 at 13:34
So for the only way i think i can do it is by creating multiple RetrieveAllAppointments and just change them to 'RetrieveMondayAppointments' / 'RetrieveTuesdayAppointments' ect ect and just filter out all the days that are not monday or tuesday or w/e — user2253722
– user2253722, Commented Apr 11, 2013 at 13:36

Cosmin Ionascu · Accepted Answer · 2013-04-12 14:20:26Z

1

In your datamodel you should have a class that manipulates the Appointments, so when you retrieve all your appointments from the database just filter them by appointments[i].Day, or something like that, based on how your Appointment class is created. You don't need to explicitly create different DB selects for each of them.

  public void onResume (){
  APData = new AppointmentDataSource(this);
  APData.open();
  List<Appointment> appointments = APData.retrieveAllAppointments();
  APData.close();
  TextView tvMonday = (TextView)findViewById(R.id.tvMonday);
  TextView tvTuesday = (TextView)findViewById(R.id.tvTuesday);
  ... (all your days textViews).
  for(Iterator<Appointment> i = appointments.iterator(); i.hasNext();){ 
  Appointment item = i.next();
     if(item.Day.equals("Monday") tvMonday.append(item.ToString());
     //same for the rest of your textViews
  }

Should be something like this.

edited Apr 12, 2013 at 14:20

answered Apr 11, 2013 at 14:39

Cosmin Ionascu

7,7085 gold badges27 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user2253722 Over a year ago

So, i have to sort it like appointments[i].day and then change the text values of the textviews from the retrieveAllAppointments method? Because i can only return 1 value or 1 list and not sure how to sort it once its been returned.

Cosmin Ionascu Over a year ago

Well as far as I understood you return all the appointments from the DB. And an object of type Appointment should have a property Appointment.Day. And yes, I am saying that you could try to sort it by appointments[i].day and then decide where to send each objects on your layout.

user2253722 Over a year ago

Hey man, you able to show me some example code and where i need to put it? Cant get this working sorry.

Cosmin Ionascu Over a year ago

Check the update, I've posted a piece of code, hope it helps you.

Collectives™ on Stack Overflow

How to sort results on android from SQLite?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related