Autocompletion on one field

[luxsyp]

Hello I would like to be able to create an auto-completion based on my database,

my model look like this :

  @Table(name = "Drug")
  public class Item extends Model {

  @Column(name = "Name")
  public String name;

  @Column(name = "Desc")
  public String desc;

  @Column(name= "Type")
  public Integer type;
 }

I would like to be able to auto-complete on the name only without getting ALL my objects before.

Is there a way to only get a List, where the String is the field name of my object without getting all the object (name+desc+type) ?

[jlhonora]

I believe you can't get a list of strings directly. Here's a (very insecure) alternative:

List<Item> items = new Select("Name").from(Item.class)
    .where("Name LIKE %" + input + "%").execute();

List<String> strings = new ArrayList<String>();

for (Item item : items) {
    strings.add(item.name);
}

It is insecure because SQL injection could occur. I don't know if ActiveAndroid has any anti-SQL injection utilities.

Edit: It doesn't have a built-in anti SQL injection mechanism, here's the part where arguments are added:

void addArguments(Object[] args) {
    for(Object arg : args) {
        if (arg.getClass() == boolean.class || arg.getClass() == Boolean.class) {
            arg = (arg.equals(true) ? 1 : 0);
        }
        mArguments.add(arg);
    }
}

Edit 2: Multiple statements are not supported in Android's SQLiteDatabase (reference), so injection shouldn't be a problem.

[luxsyp]

sounds like I can start from this thx