Array of Primitives: Support queries

[cmelchior]

Split from #5031

We need to add support for arrays of values to RealmQuery. Based on API discussions we don't want to add a ton of extra methods, so instead we are going to use the empty field name "" when querying arrays of primitives.

E.g

public class Person extends RealmObject {
  public RealmList<String> names;
}

// Query list directly
Person p = getPerson();
RealmResults<String> results = p.names.where().like("", "Jo*").findAll();

// Query list in object
RealmResults<Person> results =  realm.where(Person.class).equalTo("names", "John").findAll();
```

This also include support for `RealmList.min()/max()/average()/sum()/minDate()/maxDate()` which depends on the query system

[Zhuinden]

I actually think

// Query list in object
RealmResults<Person> results =  realm.where(Person.class).equalTo("names", "John").findAll();

has a higher importance than the others, so that you can replace RealmString link queries with it.

[cmelchior]

Yes. No doubt about that

[vivekkiran]

Any progress/updates on this? I am eagerly waiting for this feature to support the primitive list from my Wordpress API the native way without a wrapper. :)

[Zhuinden]

Agreed, I was hoping for end of 2017, but maybe this year 😄

Surprised it's blocked, I thought subtable query does this.

[mgohin]

+1, I have to use .findAll() and filter in java :(

[Zhuinden]

@mgohin another option of course is to map the list into a single string field with some convention like |value1|value2|value3| and then contains("flatList", "|${searchValue}|")

But that's lame that we still have to do that, i agree