We are moving to Discord!

Join us on the Countly Community Discord Server! Engage in discussions, share your feature ideas, and learn from fellow Countly users to build exceptional apps and experiences.

DB Viewer Filter Query Not Working

I'm trying to filter query results by applying Filter Query, but it's not working i.e. I get ZERO results. 

Here's my Filter Query:

{"sg":{"payerStatus": "true"}}

Here's my JSON Object:

{
	"uid" : "TqY",
	"did" : "8897529E-B7E1-4B6E-BA00-3D8487DE2B19",
	"up" : {
		"fs" : 1403307938,
		"ls" : 1403307938,
		"tsd" : 90,
		"sc" : 1,
		"d" : "iPhone6,1",
		"cty" : "Unknown",
		"cc" : "US",
		"p" : "iOS",
		"pv" : "iiPhone OS 7:0:6",
		"av" : "1:9:1",
		"r" : "1136x640"
	},
	"ts" : 1403309348000,
	"cd" : ISODate("2014-06-21T00:09:08.100Z"),
	"d" : "2014:6:20",
	"w" : "2014:w25",
	"m" : "2014:m6",
	"h" : "2014:6:20:h17",
	"sg" : {
		"Experiment_GameCenter" : 2,
		"Experiment_RateMyApp" : 1,
		"Experiment_RefreshNotifs" : 1,
		"Experiment_DON" : 1,
		"Experiment_ExpSpeed" : 0,
		"Experiment_E2" : 0,
		"Experiment_OfferWall" : 1,
		"Experiment_WatchToEarn" : 0,
		"Experiment_Ads" : 0,
		"Experiment_Sales" : 1,
		"totalCredits" : 5000495,
		"totalCreditsBucket" : "5000000+",
		"level" : 1,
		"levelBucket" : "1-3",
		"payerStatus" : "True",
		"sessionStartTotalCredits" : 500,
		"sessionStartTotalCreditsBucket" : "251-1000",
		"sessionStartLevel" : 1,
		"UserID" : "5ce86cdd-b93b-467e-958f-6b257ca62f28",
		"sessionStartLevelBucket" : "1-3",
		"installWeek" : "06/16/2014",
		"sessionStartPayerStatus" : "False",
		"playerTenure" : 0,
		"platform" : "iOS"
	},
	"s" : 1.99,
	"c" : 1,
	"_id" : ObjectId("53a4cd246698af09366881fe")
}

I'm doing this from Countly Dashboard area:

Utilities > DB Viewer > countly_drill > {drill_events(App:Event)}
 
Is there something wrong with my Filter Query?
0

Comments

1 comment
  • Official comment

    Hi,

     

    Could you please try querying using this:

    {"sg.payerStatus": "true"}

    Instead of this:

    {"sg":{"payerStatus": "true"}}

    And get back to us informing us if it worked?

    Comment actions Permalink

Please sign in to leave a comment.