need help to build a database.search formula

private String getFieldFormParents(Document Doc, String FieldName, Database ContactDB){
		String ParentUNID;
		Document ParentDoc;
		String FieldValue;
		
		try{	
			//check for the field
			FieldValue=getField(Doc, FieldName);
			if (FieldValue.trim().length() > 0){
					//found!
					return FieldValue;
			}else{
				//check for a parent
				ParentUNID = Doc.getParentDocumentUNID();
				if (ParentUNID.trim().length() > 0){
					ParentDoc = ContactDB.getDocumentByUNID(ParentUNID);
					//recursive call
					return getFieldFormParents(ParentDoc, FieldName, ContactDB);					
				}else{
					//no more parent field not found
					return "";
				}
			}
		} catch(Exception e) {
			e.printStackTrace();
		}
		return null;
	}
private String getField(Document ContactDoc, String FieldName){
			 Item item;			
                 try{
					// Get item object. Global object nabdoc was set earlier in
					// getPersonDocument function.
					item=ContactDoc.getFirstItem(FieldName);
					//Sometimes item does not exist in the document, it's not an error so
					// we return an empty string.
					if (item==null){
						return "";
					}else{
					//Return the value that the item holds
						return item.getValueString();
					}
				} catch(Exception e) {
					e.printStackTrace();
				}
			return "";
		}
 
 
	private DocumentCollection getContactDocumentCollection(int intContactSelectionType,
												 String strFilter, 
												 boolean onlyFirstLetterFilter,
												 int[] RegionSelection,
												 Database ContactDB){			
			DocumentCollection ContactsSearch;
			DocumentCollection ContactsReturn;					
			Document ContactDoc;
			Document CompanyDoc;
			String strRegion;
			int intRegion;
			boolean blnFound;
			try{
				if (onlyFirstLetterFilter){
					//Search the database for documents where CompanyName field matches received parameter
					ContactsSearch = ContactDB.search("Form=\"Contact\" & @LowerCase(@Left("+ContactSelectionType.getSearchField(intContactSelectionType)+";1))=\""+strFilter.toLowerCase().charAt(0)+"\"", null, 0);
					//ContactsReturn = ContactDB.search("Form=\"Contact\" & @LowerCase(@Left("+ContactSelectionType.getSearchField(intContactSelectionType)+";1))=\""+strFilter.toLowerCase().charAt(0)+"\"", null, 0);
					
 
				}else{
					ContactsSearch = ContactDB.search("Form=\"Contact\" & \"A\"=\"X\"", null, 0);				
					//ContactsReturn = ContactDB.search("Form=\"Contact\" & "+ContactSelectionType.getSearchField(intContactSelectionType)+"=\""+strFilter+"\"", null, 0);				
				}
				ContactsReturn = ContactDB.search("Form=\"Contact\" & "+ContactSelectionType.getSearchField(intContactSelectionType)+"=\""+strFilter+"\"", null, 0);
				ContactDoc = ContactsSearch.getFirstDocument();
				while (ContactDoc != null) {
					strRegion=getFieldFormParents(ContactDoc, "Region", ContactDB);
					strRegion = strRegion.trim();
					if (strRegion.length() == 0){
						//region is from unlinked CIE
						CompanyDoc = getCompanyDocumentForContact(ContactDoc, ContactDB);
						strRegion=getField(CompanyDoc, "Region");
						strRegion = strRegion.trim();
					}
					if (isInteger(strRegion)){
						intRegion = Integer.parseInt(strRegion);
						blnFound = false;
						for (int i=0;  i<RegionSelection.length;  i++){
							if (intRegion == RegionSelection[i]){
								blnFound = true;
								break;
							}
						}
					}else{
						blnFound = false;
					}
					
					//remove doc from Collection
					if (blnFound) {
						ContactsReturn.addDocument(ContactDoc);
					}
					ContactDoc = ContactsSearch.getNextDocument();
				}
					
				
				return ContactsReturn;
			} catch(Exception e) {
				e.printStackTrace();
			}
			return null;
 		}

Select allOpen in new window