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.