title: Query IN with Realm Android
body: <p>so i try some query with Realm with my project, i want to get all Detail menu with personsInMenu has Status True. i want to get all the prices and get the size of how many people has Status True with that Menu.</p>
  
  <p>this is my model</p>
  
  <pre><code>public class DetailMenu extends RealmObject {
  
      @PrimaryKey
      private int MenuID;
      private int Quantity;
      private String MenuName;
      private int MenuPrice;
      public RealmList&lt;PersonInMenu&gt; personInMenus;
  
      //all the setter getter.. its too long if i input those setter getter
  
  }
  
  public class DetailPerson extends RealmObject {
  
      @PrimaryKey
      private int PersonID;
      private String PersonName;
      private int PersonPrice;
  
  }
  
  public class PersonInMenu extends RealmObject {
  
      @PrimaryKey
      private int PersonID;
      private boolean Status;
  
  }
  </code></pre>
  
  <p>this is my query:</p>
  
  <pre><code>RealmResults&lt;DetailMenu&gt; personSize = realm.where(DetailMenu.class).equalTo("personInMenus.PersonID", Person.get(0).getPersonID()).equalTo("personInMenus.Status", true).findAll();
  </code></pre>
  
  <p>hopefully someone can help me on this.</p>