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

[Roger75]

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

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?

[wissem]

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

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

 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

[Roger75]

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!