How to find accounts which have zimbraNotes field with no value using Java Soap API?

I'm trying to find all accounts which have zimbraNotes field equals "" (blank) using the following filter, but it's not working:

Code:

---

SearchOptions arg=new SearchOptions();

arg.setQuery("zimbraNotes='' ");
String attRet[]=null;
arg.setReturnAttrs(attRet);
arg.setFlags(Provisioning.SA_ACCOUNT_FLAG);

List<NamedEntry> list = sp.searchDirectory(arg);

---

How to do that?

Quote:

---

Originally Posted by Roger75

I'm trying to find all accounts which have zimbraNotes field equals "" (blank) using the following filter, but it's not working:

Code:

---

SearchOptions arg=new SearchOptions();

arg.setQuery("zimbraNotes='' ");
String attRet[]=null;
arg.setReturnAttrs(attRet);
arg.setFlags(Provisioning.SA_ACCOUNT_FLAG);

List<NamedEntry> list = sp.searchDirectory(arg);

---

How to do that?

---

you can try this solution

Code:

---


 List<com.zimbra.cs.account.Account>listAccounts= soapProvisioning.getAllAccounts(soapProvisioning.getDomainByName("domainName"));
                      for(int i=0;i<listAccounts.size();i++){
                              if(listAccounts.get(i).getNotes().equals("")){
                                      //account have zimbraNotes field equals ""
                              }
                      }

---

Regards

Wissem

You must be kidding... I wanna just getting the accounts with zimbraNotes equals("")! if I do like you said I'll spent a week in my process!