Ordering in DBFLow

Question

I am trying to implement DBFlow in my Android Project. I have been able to create a table and add rows and columns to it. I have two columns, ID and Names. Now I want to retrieve the Names from the table and arrange it in descending order by ID. I found this example syntax in Github DBFlow page

SQLite.select()
  .from(table)
  .where()
  .orderBy(Customer_Table.customer_id, true)
  .queryList();

SQLite.select()
    .from(table)
    .where()
    .orderBy(Customer_Table.customer_id, true)
    .orderBy(Customer_Table.name, false)
    .queryList();

But I am unable to under what "Customer_Table.customer_id" means in that code. When I try to put the method orderBy(), Android Studio suggests (NameAlias nameAlias, boolean) as the parameter. How do I added a NameAlias to my table? Can someone please help me with this?

score 3 · Answer 1 · answered Apr 12 '17 at 06:25

When you implement DbFlow in your project it automatically builds a table class for each table model you have annotated with the @Table annotation.

i.e, if you have a table with name Customer then the corresponding class would be Customer_Table and if your table is User then the corresponding class would be User_Table.

Let this be your Customer table:

@Table
public class Customer extends BaseModel {
    @Column
    String customer_name;
}

If you want to order your results with customer name in Customer table, then use like this,

SQLite.select()
  .from(table)
  .where()
  .orderBy(Customer_Table.customer_name, true)
  .queryList();

score 0 · Answer 2 · answered Mar 28 '16 at 17:53

0

In "Customer_Table.customer_id", Customer_Table is name of table and customer_id is column name. You can get the name and id from database and sort the data list programmatically or you can use this query

mDb.query(true, PT_TABLE, new String[] {KEY_PID, KEY_NAME}, null, null, null, null, KEY_PID+" DESC", null);

answered Mar 28 '16 at 17:53

Ashim Kansal

263
2
12

@Table(database = AppDatabase.class) public class Articles extends BaseModel { .... } I have used that code to make table. So the table name is Articles? – Aakaash Jois Mar 28 '16 at 18:41
use SQLite.select() .from(Articles.class) .where() .orderBy(Articles.ID, true) .queryList(); – Ashim Kansal Mar 28 '16 at 20:06
That line shows the error, cannot resolve method 'orderBy(int, boolean)' – Aakaash Jois Mar 29 '16 at 12:50
@AshimKansal with DBflow one has to add "_Table", like this `SQLite.select() .from(Articles.class) .where() .orderBy(Articles_Table.ID, true) .queryList();` – Someone Somewhere Jul 18 '17 at 17:57

Ordering in DBFLow

2 Answers2