Realm Query for List

[pollux-]

I have a product Model Like this

public class Product
{
private String title;
private RealmList<Meta> meta;

public class Meta {
public String key;
public String value;
     }
}

Model is populated from below JSON.

[{
	"title": "BBQ chicken",
	"meta": [{
			"key": "content",
			"value": "Chicken"

		},
		{
			"key": "protein",
			"value": "Chicken"
		}
	]

}, {
	"title": "Beef BBQ",
	"meta": [{
			"key": "content",
			"value": "Beef"

		},
		{
			"key": "protein",
			"value": "good"
		}, {
			"key": "ingredient",
			"value": "chicken"
		}
	]

}]

What I need is, filter all products which have content="chicken". So I ended up in writing a query like this.

realm.where(Product.class).equalTo("meta.key","content").equalTo("meta.value","chicken").findAll().
But I ended up in result set with both the products. How can I do something like this say, I need only the products which has key="content" and value="chicken".

[Zhuinden]

realm.where(Product.class)
         .equalTo("meta.key","content")
         .findAll()
         .where()
         .equalTo("meta.value","chicken")
         .findAll()

[pollux-]

@Zhuinden thanks , Awesome, will try this

[cmelchior]

@pollux- You can also read this relevant section in the docs: https://realm.io/docs/java/latest/#link-queries

[pollux-]

Awesome, working as expected 👍

       
 final Realm dbInstance = DbManager.getInstance().getDBInstance();
        dbInstance.executeTransaction(new Realm.Transaction() {
            @Override
            public void execute(Realm realm) {

                try {
                    RealmResults<TestProduct> product = dbInstance.where(TestProduct.class).findAll();
                    if (product.size() ==0) {
                        final InputStream testJson = getAssets().open("test_json");
                        dbInstance.createAllFromJson(TestProduct.class, testJson);
                    }
                    RealmResults<TestProduct> all = dbInstance.where(TestProduct.class).equalTo("meta.key","content").findAll().where().equalTo("meta.value","chicken").findAll();
                    int size = all.size();

                } catch (IOException e) {
                    e.printStackTrace();
                }

            }
        });