Q:

ActiveAndroid how to get single column items from table and store those in arraylist

I am new to active android, i have a table named MyTable with columns articleName, articleId and imageTicket, i want to store all imageTicket column values in a ArrayList. can anyone help me with a query?

A:

Here is my code to get imageTicket column from MyTable
 private ArrayList<MyTable> myTableList = new ArrayList<MyTable>();
 // to get all table data
 myTableList =  new Select().from(MyTable.class).execute();

 for(int i = 0; i < myTableList.size(); i++){         
     String imageTicket = myTableList.get(i).getImageTicket();
     // do something with imageticket value
 }

