sugar orm :retrieve fields in textview

Question

I m new with sugar orm. I need to retrieve a field to charge in a textview. It s possible to do it with sugar orm. Something like this select field1, field2 from table where condition1 and condition2

Answer 1

Sure you can, Just experience static methods that generated by sugar orm. Class that extends SugarRecord has methods like

YourModel.findById(YourModel.class, 1)

or any other methods that allow you write your raw query or chain methods where you can invoke like

Select.from(YourModel.class).where(Condition.prop("age").gt(20)).limit(1);

These features are the reasons why you are using SugarORM.

UPDATE:

The line below is just an example for usage.

CampaignDAO dao = CampaignDAO
                .find(CampaignDAO.class, NamingHelper.toSQLNameDefault("isPersonal") + " = ? ", "1")
                .get(0);

The code below is critical. It generates field name which is is_Personal in database table.

NamingHelper.toSQLNameDefault("isPersonal")