Problem with Filters class

[VikasKumar Gupta]

Hello Everyone,
I need the count of filtered records in a collection. I am using count method with filter criteria. For filter criteria, I am using" Filters.eq(key, value) method but I am not getting the zero result though it has the document with that filter criteria.
If any one has used Filter class then please let me know what wrong I am doing.

Regards,
Vikas

[Tim Cooke]

Perhaps a code example might help here showing your usage of the Filter / Filters class? Your question is a little vague just now.

[VikasKumar Gupta]

Dear Tim,
Please find the code snippet.

               

ServerAddress add = new ServerAddress(dbHost,port);
		List<MongoCredential> credential = new ArrayList<MongoCredential>();
		MongoCredential mc = MongoCredential.createCredential(user, databasName, pwd.toCharArray());
		credential.add(mc);
		MongoClient mongo = new MongoClient(add,credential);
		MongoDatabase database = mongo.getDatabase(databasName);
		MongoCollection<Document> collection = database.getCollection("service_logging");
		String totalCount = Long.toString(collection.count());
		String filteredCount = totalCount;
		if ( filterCriteria != null)
		{
			for ( int i = 0; i < filterCriteria.length; i++ )
			{
				IDataCursor filterCriteriaCursor = filterCriteria[i].getCursor();
					String	key = IDataUtil.getString( filterCriteriaCursor, "key" );
					String	value = IDataUtil.getString( filterCriteriaCursor, "value" );
					filteredCount = Long.toString(collection.count(Filters.eq(key,value)));
				filterCriteriaCursor.destroy();
			}
		}

[VikasKumar Gupta]

Hi,
I am able to solve this issue and the problem is, Mongodb is case sensitive and key name i suppose to pass should be in upper case but i was passing it in lower case.
Silly mistake but it wasted my lot of time. Lesson learned.

Thanks,
Vikas