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?
Comments
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?
Please sign in to leave a comment.