Finding documents with matching array elements using "all"

Sonal_Panchal · March 24, 2020, 6:20pm

I created one collection in which I have one key as an array with around 19000 key
but when I run a query find in which I add where condition to filter the same array by it’s value is not working
please look my collection data

_id:5e79f884fc6b7851f51a1a9b
name:“test”
start_date:2020-03-24T12:09:23.000+00:100:
4.studentIds:Object
1:“N00189250”
2:“N00080147”
3:“N00081952”
4:“N00083010”
5:“N00083496”
6:“N00084994”
7:“N00085858”

where condition
->where(‘studentIds’,‘all’,[‘N00085858’])
acepted result should be return the above document
current result empty data

Stennie_X · March 25, 2020, 6:09am

Welcome to the MongoDB Community @Sonal_Panchal!

To help understand your issue can you please provide:

an example document as output by findOne() in the mongo shell
details of the MongoDB driver/framework and version you are using

I suspect the all in your query may instead want to be the $all operator.

Regards,
Stennie

Sonal_Panchal · March 25, 2020, 6:42am

details of the MongoDB driver/framework and version you are using
Laravel framework below is the driver/framework for MongoDB
GitHub - mongodb/laravel-mongodb: A MongoDB based Eloquent model and Query builder for Laravel (Moloquent)
And my MongoDB version is

db.version()
4.0.14

an example document as output by findOne() in the mongo shell
Below id my collection document
and my query is in laravel framework query builder

Query

        DB::table('popup_master')
            ->where('status','Published')
            ->where('start_date','<=',$curDate)
            ->where('end_date','>=',$curDate)
            ->whereNull('deleted_at')
            ->where(function($q) use($userRole, $userId) {
                $q->where('studentIds','all',[strtoupper($userId)])
                ->orWhere('notif_roles',$userRole);
            })
            ->orderBy('position')->select(['link_url','display_view','internalFlag','encryptParameterFlag','parameterName'])->get();

The above query works when there were 1000 records in the array key studentIds but where there were 20 thousand records it doesn’t work with the same query.
can you please let me know what’s the issue in that
If the query works for 1000 records it should work for 20, 40 thousands of records.

> db.popup_master.find().pretty()
> {
> 	"_id" : ObjectId("5e7afa46b5677c71fd425133"),
> 	"name" : "test Document",
> 	"start_date" : ISODate("2020-03-25T06:29:02Z"),
> 	"link_url" : null,
> 	"end_date" : ISODate("2020-03-31T06:28:49Z"),
> 	"filter_type" : "2",
> 	"display_view" : {
> 		"desktop_image" : "asset/test.jpeg"
> 	},
> 	"status" : "Published",
> 	"internalFlag" : "0",
> 	"encryptParameterFlag" : "0",
> 	"parameterName" : null,
> 	"updated_at" : ISODate("2020-03-25T06:29:26Z"),
> 	"created_at" : ISODate("2020-03-25T06:29:26Z"),
> 	"notif_roles" : null,
> 	"popup_population_filters" : {
> 		"facultad" : [ ],
> 		"year" : [ ],
> 		"Period" : [ ],
> 		"Campus" : [ ],
> 		"level" : [ ],
> 		"Modalidad" : [ ],
> 		"Programa" : [ ],
> 		"program_all" : null,
> 		"nrc_all" : null,
> 		"Course" : [ ],
> 		"ProgramaStr" : [ ],
> 		"CourseStr" : [ ]
> 	},
> 	"selected_year" : null,
> 	"studentIds" : [
> 		"N00248748",
> 		"N00157568",
> 		"N00175665",
> 		"N00176430",
> 		"N00176448",
> 		"N00177176",
> 		"N00179354",
> 		"N00179477",
> 		"N00179942",
> 		"N00181371",
> 		"N00181429",
> 		"N00182040",
> 		"N00182228",
> 		"N00183028",
> 		"N00183372",
> 		"N00183826",
> 		"N00184232",
> 		"N00184363",
> 		"N00184561",
> 		"N00186485",
> 		"N00187468",
> 		"N00188085",
> 		"N00189250",
> 		"N00080147",
> 		"N00081952",
> 		"N00083010",
> 		"N00083496",
> 		"N00084994",
> 		"N00085858",
> 		"N00086044",
> 		"N00087382",
> 		"N00088295",
> 		"N00089202",
> 		"N00089254",
> 		"N00089278",
> 		"N00091533",
> 		"N00092863",
> 		"N00093083",
> 		"N00093731",
> 		"N00094043",
> 		"N00095024",
> 		"N00097777",
> 		"N00101858",
> 		"N00102420",
> 		"N00031621",
> 		"N00032062",
> 		"N00032849",
> 		"N00034267",
> 		"N00035306",
> 		"N00035736",
> 		"N00040903",
> 		"N00043942",
> 		"N00044626",
> 		"N00044996",
> 		"N00046861",
> 		"N00047971",
> 		"N00048622",
> 		"N00049530",
> 		"N00050165",
> 		"N00050292",
> 		"N00054701",
> 		"N00054840",
> 		"N00129756",
> 		"N00130312",
> 		"N00130689",
> 		"N00133876",
> 		"N00134188",
> 		"N00139655",
> 		"N00144574",
> 		"N00145797",
> 		"N00149348",
> 		"N00149580",
> 		"N00150598",
> 		"N00151333",
> 		"N00151420",
> 		"N00152764",
> 		"N00152992",
> 		"N00021808",
> 		"N00023997",
> 		"N00024152",
> 		"N00024561",
> 		"N00027204",
> 		"N00191021",
> 		"N00191458",
> 		"N00196571",
> 		"N00197525",
> 		"N00198474",
> 		"N00199706",
> 		"N00199732",
> 		"N00201281",
> 		"N00201516",
> 		"N00202372",
> 		"N00199414",
> 		"N00199572",
> 		"N00199776",
> 		"N00200480",
> 		"N00200877",
> 		"N00201440",
> 		"N00201904",
> 		"N00203264",
> 		"N00203358",
> 		"N00205204",
> 		"N00205538",
> 		"N00205725",
> 		"N00205942",
> 		"N00206523",
> 		"N00206956",
> 		"N00207127",
> 		"N00207578",
> 		"N00207625",
> 		"N00207863",
> 		"N00081927",
> 		"N00082453",
> 		"N00082639",
> 		"N00082943",
> 		"N00083266",
> 		"N00089299",
> 		"N00089442",
> 		"N00093761",
> 		"N00094614",
> 		"N00094914",
> 		"N00097205",
> 		"N00098532",
> 		"N00098781",
> 		"N00099894",
> 		"N00100197",
> 		"N00103413",
> 		"N00222196",
> 		"N00222308",
> 		"N00222893",
> 		"N00223343",
> 		"N00223357",
> 		"N00223418",
> 		"N00224127",
> 		"N00224862",
> 		"N00225039",
> 		"N00225402",
> 		"N00225418",
> 		"N00225449",
> 		"N00226104",
> 		"N00056018",
> 		"N00056275",
> 		"N00058141",
> 		"N00058482",
> 		"N00060656",
> 		"N00061144",
> 		"N00062488",
> 		"N00062867",
> 		"N00064827",
> 		"N00067090",
> 		"N00068136",
> 		"N00070557",
> 		"N00071633",
> 		"N00073704",
> 		"N00073707",
> 		"N00074209",
> 		"N00078616",
> 		"N00168533",
> 		"N00168554",
> 		"N00171127",
> 		"N00172088",
> 		"N00172528",
> 		"N00172838",
> 		"N00173046",
> 		"N00173582",
> 		"N00175310",
> 		"N00015481",
> 		"N00019928",
> 		"N00021408",
> 		"N00027008",
> 		"N00027329",
> 		"N00027665",
> 		"N00028776",
> 		"N00107922",
> 		"N00111273",
> 		"N00112021",
> 		"N00115283",
> 		"N00116308",
> 		"N00118295",
> 		"N00118304",
> 		"N00119608",
> 		"N00120203",
> 		"N00121282",
> 		"N00121290",
> 		"N00123292",
> 		"N00124292",
> 		"N00128539",
> 		"N00186117",
> 		"N00186221",
> 		"N00187034",
> 		"N00187094",
> 		"N00187423",
> 		"N00187511",
> 		"N00190664",
> 		"N00192398",
> 		"N00195441",
> 		"N00196790",
> 		"N00197358",
> 		"N00197368",
> 		"N00198076",
> 		"N00198099",
> 		"N00061324",
> 		"N00063443",
> 		"N00064015",
> 		"N00064069",
> 		"N00065255",
> 		"N00065717",
> 		"N00066781",
> 		"N00066920",
> 		"N00067423",
> 		"N00067559",
> 		"N00071035",
> 		"N00074849",
> 		"N00076151",
> 		"N00076712",
> 		"N00212656",
> 		"N00212736",
> 		"N00212885",
> 		"N00213156",
> 		"N00213240",
> 		"N00214111",
> 		"N00214754",
> 		"N00215894",
> 		"N00216225",
> 		"N00216262",
> 		"N00216972",
> 		"N00217077",
> 		"N00218353",
> 		"N00219017",
> 		"N00219039",
> 		"N00219352",
> 		"N00219598",
> 		"N00220626",
> 		"N00221009",
> 		"N00221324",
> 		"N00221457",
> 		"N00221538",
> 		"N00221571",
> 		"N00102637",
> 		"N00102878",
> 		"N00103681",
> 		"N00104099",
> 		"N00105960",
> 		"N00108793",
> 		"N00111755",
> 		"N00112861",
> 		"N00113142",
> 		"N00113729",
> 		"N00114576",
> 		"N00114830",
> 		"N00114847",
> 		"N00115376",
> 		"N00115465",
> 		"N00120840",
> 		"N00121867",
> 		"N00122170",
> 		"N00123580",
> 		"N00124282",
> 		"N00125391",
> 		"N00126840",
> 		"N00151504",
> 		"N00151686",
> 		"N00152402",
> 		"N00152953",
> 		"N00153304",
> 		"N00153371",
> 		"N00154957",
> 		"N00155097",
> 		"N00156566",
> 		"N00156670",
> 		"N00158184",
> 		"N00158665",
> 		"N00158901",
> 		"N00159145",
> 		"N00159542",
> 		"N00163874",
> 		"N00166810",
> 		"N00169333",
> 		"N00169341",
> 		"N00130545",
> 		"N00105673",
> 		"N00106005",
> 		"N00108214",
> 		"N00111741",
> 		"N00113532",
> 		"N00113904",
> 		"N00114819",
> 		"N00116880",
> 		"N00116934",
> 		"N00117644",
> 		"N00119024",
> 		"N00119350",
> 		"N00119369",
> 		"N00119985",
> 		"N00120493",
> 		"N00121935",
> 		"N00125797",
> 		"N00126315",
> 		"N00126609",
> 		"N00127082",
> 		"N00057428",
> 		"N00057813",
> 		"N00058312",
> 		"N00058457",
> 		"N00059406",
> 		"N00061224",
> 		"N00061927",
> 		"N00065703",
> 		"N00066271",
> 		"N00067508",
> 		"N00067874",
> 		"N00068616",
> 		"N00068922",
> 		"N00069433",
> 		"N00070786",
> 		"N00076119",
> 		"N00076974",
> 		"N00077878",
> 		"N00030168",
> 		"N00031919",
> 		"N00032818",
> 		"N00036898",
> 		"N00040927",
> 		"N00041304",
> 		"N00042355",
> 		"N00044991",
> 		"N00046015",
> 		"N00046827",
> 		"N00047183",
> 		"N00050424",
> 		"N00053772",
> 		"N00156924",
> 		"N00158829",
> 		"N00160726",
> 		"N00162005",
> 		"N00163080",
> 		"N00163152",
> 		"N00163862",
> 		"N00164648",
> 		"N00165940",
> 		"N00166313",
> 		"N00169208",
> 		"N00169346",
> 		"N00170413",
> 		"N00170864",
> 		"N00171841",
> 		"N00018012",
> 		"N00018901",
> 		"N00019613",
> 		"N00020496",
> 		"N00024178",
> 		"N00024365",
> 		"N00025594",
> 		"N00202956",
> 		"N00203152",
> 		"N00204168",
> 		"N00205577",
> 		"N00206550",
> 		"N00206800",
> 		"N00207514",
> 		"N00207654",
> 		"N00208249",
> 		"N00208939",
> 		"N00209030",
> 		"N00209751",
> 		"N00210453",
> 		"N00210930",
> 		"N00211034",
> 		"N00211308",
> 		"N00211524",
> 		"N00212036",
> 		"N00212241",
> 		"N00212612",
> 		"N00213291",
> 		"N00213373",
> 		"N00128593",
> 		"N00129764",
> 		"N00132485",
> 		"N00132895",
> 		"N00133121",
> 		"N00137058",
> 		"N00137777",
> 		"N00138069",
> 		"N00142152",
> 		"N00142587",
> 		"N00144281",
> 		"N00144333",
> 		"N00144695",
> 		"N00145939",
> 		"N00146208",
> 		"N00146895",
> 		"N00150654",
> 		"N00150922",
> 		"N00152279",
> 		"N00208643",
> 		"N00209309",
> 		"N00209621",
> 		"N00210412",
> 		"N00210540",
> 		"N00211336",
> 		"N00212100",
> 		"N00212129",
> 		"N00213511",
> 		"N00214499",
> 		"N00214530",
> 		"N00217479",
> 		"N00218510",
> 		"N00219285",
> 		"N00219980",
> 		"N00220009",
> 		"N00232386",
> 		"N00233549",
> 		"N00233593",
> 		"N00234108",
> 		"N00153370",
> 		"N00153592",
> 		"N00154827",
> 		"N00159110",
> 		"N00159368",
> 		"N00160638",
> 		"N00160779",
> 		"N00160807",
> 		"N00161037",
> 		"N00161822",
> 		"N00165366",
> 		"N00165612",
> 		"N00169072",
> 		"N00169110",
> 		"N00169167",
> 		"N00169745",
> 		"N00171797",
> 		"N00016420",
> 		"N00019122",
> 		"N00024053",
> 		"N00028206",
> 		"N00189154",
> 		"N00190652",
> 		"N00192652",
> 		"N00194204",
> 		"N00195248",
> 		"N00195901",
> 		"N00195991",
> 		"N00196289",
> 		"N00198214",
> 		"N00198912",
> 		"N00055693",
> 		"N00056314",
> 		"N00057377",
> 		"N00057450",
> 		"N00058237",
> 		"N00059145",
> 		"N00059321",
> 		"N00061491",
> 		"N00063577",
> 		"N00065040",
> 		"N00066267",
> 		"N00066343",
> 		"N00066465",
> 		"N00068583",
> 		"N00070152",
> 		"N00071286",
> 		"N00072242",
> 		"N00072265",
> 		"N00072974",
> 		"N00073691",
> 		"N00076693",
> 		"N00077194",
> 		"N00224798",
> 		"N00224802",
> 		"N00225027",
> 		"N00225201",
> 		"N00225358",
> 		"N00225873",
> 		"N00226362",
> 		"N00226998",
> 		"N00227002",
> 		"N00229407",
> 		"N00229568",
> 		"N00229648",
> 		"N00229990",
> 		"N00230220",
> 		"N00230437",
> 		"N00230518",
> 		"N00230935",
> 		"N00231198",
> 		"N00231347",
> 		"N00231367",
> 		"N00231392",
> 		"N00231636",
> 		"N00232503",
> 		"N00233282",
> 		"N00233382",
> 		"N00233490",
> 		"N00130217",
> 		"N00130333",
> 		"N00132811",
> 		"N00133751",
> 		"N00136095",
> 		"N00136852",
> 		"N00137346",
> 		"N00137511",
> 		"N00137975",
> 		"N00139185",
> 		"N00139607",
> 		"N00141634",
> 		"N00141882",
> 		"N00142044",
> 		"N00142220",
> 		"N00143465",
> 		"N00143479",
> 		"N00146517",
> 		"N00147560",
> 		"N00148349",
> 		"N00150841",
> 		"N00151067",
> 		"N00104262",
> 		"N00104992",
> 		"N00106891",
> 		"N00110459",
> 		"N00112159",
> 		"N00112368",
> 		"N00113593",
> 		"N00113638",
> 		"N00118561",
> 		"N00119969",
> 		"N00121152",
> 		"N00122989",
> 		"N00123746",
> 		"N00125859",
> 		"N00220895",
> 		"N00221013",
> 		"N00221497",
> 		"N00221556",
> 		"N00221637",
> 		"N00221815",
> 		"N00221860",
> 		"N00222049",
> 		"N00223118",
> 		"N00223192",
> 		"N00223545",
> 		"N00223884",
> 		"N00224060",
> 		"N00224359",
> 		"N00224868",
> 		"N00225439",
> 		"N00227048",
> 		"N00227131",
> 		"N00227314",
> 		"N00228613",
> 		"N00229187",
> 		"N00229503",
> 		"N00210768",
> 		"N00212375",
> 		"N00213433",
> 		"N00213812",
> 		"N00215281",
> 		"N00215472",
> 		"N00217304",
> 		"N00217307",
> 		"N00217571",
> 		"N00218057",
> 		"N00218145",
> 		"N00219212",
> 		"N00219553",
> 		"N00219831",
> 		"N00219841",
> 		"N00220349",
> 		"N00220416",
> 		"N00220915",
> 		"N00221160",
> 		"N00221424",
> 		"N00221699",
> 		"N00230108",
> 		"N00230573",
> 		"N00230658",
> 		"N00231943",
> 		"N00231984",
> 		"N00232124",
> 		"N00233146",
> 		"N00233437",
> 		"N00233442",
> 		"N00234092",
> 		"N00234129",
> 		"N00234153",
> 		"N00203496",
> 		"N00205803",
> 		"N00206485",
> 		"N00206951",
> 		"N00207590",
> 		"N00207765",
> 		"N00207914",
> 		"N00209002",
> 		"N00209194",
> 		"N00209667",
> 		"N00210237",
> 		"N00210360",
> 		"N00210990",
> 		"N00211384",
> 		"N00211554",
> 		"N00212044",
> 		"N00212047",
> 		"N00212359",
> 		"N00212502",
> 		"N00212625",
> 		"N00222500",
> 		"N00222747",
> 		"N00222962",
> 		"N00223384",
> 		"N00223710",
> 		"N00223952",
> 		"N00224084",
> 		"N00224329",
> 		"N00224555",
> 		"N00224604",
> 		"N00225073",
> 		"N00225604",
> 		"N00225980",
> 		"N00226009",
> 		"N00226085",
> 		"N00226807",
> 		"N00227247",
> 		"N00227353",
> 		"N00227434",
> 		"N00081637",
> 		"N00083414",
> 		"N00085341",
> 		"N00087159",
> 		"N00087694",
> 		"N00088957",
> 		"N00090066",
> 		"N00090999",
> 		"N00093032",
> 		"N00093751",
> 		"N00097481",
> 		"N00098278",
> 		"N00098494",
> 		"N00099500",
> 		"N00101213",
> 		"N00102906",
> 		"N00054496",
> 		"N00054728",
> 		"N00055987",
> 		"N00056464",
> 		"N00059676",
> 		"N00062038",
> 		"N00063751",
> 		"N00064165",
> 		"N00065014",
> 		"N00066730",
> 		"N00067571",
> 		"N00068685",
> 		"N00069665",
> 		"N00072430",
> 		"N00073642",
> 		"N00075065",
> 		"N00075996",
> 		"N00076844",
> 		"N00173103",
> 		"N00176403",
> 		"N00178682",
> 		"N00179810",
> 		"N00179863",
> 		"N00180434",
> 		"N00181388",
> 		"N00184250",
> 		"N00185495",
> 		"N00185938",
> 		"N00187246",
> 		"N00028387",
> 		"N00029783",
> 		"N00030117",
> 		"N00034460",
> 		"N00036629",
> 		"N00037666",
> 		"N00038120",
> 		"N00039126",
> 		"N00039161",
> 		"N00040479",
> 		"N00043168",
> 		"N00044337",
> 		"N00044835",
> 		"N00045436",
> 		"N00045651",
> 		"N00048074",
> 		"N00048338",
> 		"N00049787",
> 		"N00052770",
> 		"N00213986",
> 		"N00214524",
> 		"N00215921",
> 		"N00216511",
> 		"N00217220",
> 		"N00217316",
> 		"N00218558",
> 		"N00218868",
> 		"N00218869",
> 		"N00219589",
> 		"N00220247",
> 		"N00220488",
> 		"N00224005",
> 		"N00224011",
> 		"N00224102",
> 		"N00107385",
> 		"N00108074",
> 		"N00110516",
> 		"N00110747",
> 		"N00110777",
> 		"N00111584",
> 		"N00112635",
> 		"N00114416",
> 		"N00115132",
> 		"N00117507",
> 		"N00122588",
> 		"N00123470",
> 		"N00123512",
> 		"N00124695",
> 		"N00124701",
> 		"N00125542",
> 		"N00125980",
> 		"N00126495",
> 		"N00079876",
> 		"N00084531",
> 		"N00085530",
> 		"N00085602",
> 		"N00088010",
> 		"N00088920",
> 		"N00090221",
> 		"N00092965",
> 		"N00094566",
> 		"N00097704",
> 		"N00099628",
> 		"N00100438",
> 		"N00100649",
> 		"N00101054",
> 		"N00101361",
> 		"N00102696",
> 		"N00187745",
> 		"N00188427",
> 		"N00189555",
> 		"N00190567",
> 		"N00191703",
> 		"N00194408",
> 		"N00196337",
> 		"N00198157",
> 		"N00198439",
> 		"N00198756",
> 		"N00199937",
> 		"N00201840",
> 		"N00202422",
> 		"N00202508",
> 		"N00202885",
> 		"N00203237",
> 		"N00203535",
> 		"N00204471",
> 		"N00207104",
> 		"N00207424",
> 		"N00208027",
> 		"N00208131",
> 		"N00208436",
> 		"N00209676",
> 		"N00226768",
> 		"N00227977",
> 		"N00228104",
> 		"N00228801",
> 		"N00229252",
> 		"N00229844",
> 		"N00230168",
> 		"N00230189",
> 		"N00230496",
> 		"N00230639",
> 		"N00231397",
> 		"N00231489",
> 		"N00231673",
> 		"N00231794",
> 		"N00232114",
> 		"N00232151",
> 		"N00232194",
> 		"N00232233",
> 		"N00232234",
> 		"N00131162",
> 		"N00133817",
> 		"N00134884",
> 		"N00136636",
> 		"N00142157",
> 		"N00143244",
> 		"N00143582",
> 		"N00144410",
> 		"N00144440",
> 		"N00144839",
> 		"N00145969",
> 		"N00146102",
> 		"N00146201",
> 		"N00147525",
> 		"N00147897",
> 		"N00149373",
> 		"N00150364",
> 		"N00185404",
> 		"N00186496",
> 		"N00186669",
> 		"N00187247",
> 		"N00191115",
> 		"N00191237",
> 		"N00191396",
> 		"N00192399",
> 		"N00193440",
> 		"N00194333",
> 		"N00197593",
> 		"N00171575",
> 		"N00171736",
> 		"N00172524",
> 		"N00172801",
> 		"N00174324",
> 		"N00174334",
> 		"N00176220",
> 		"N00176389",
> 		"N00177153",
> 		"N00177204",
> 		"N00178652",
> 		"N00179250",
> 		"N00181046",
> 		"N00181471",
> 		"N00181761",
> 		"N00181768",
> 		"N00182119",
> 		"N00185204",
> 		"N00185310",
> 		"N00185962",
> 		"N00107744",
> 		"N00109597",
> 		"N00110549",
> 		"N00110925",
> 		"N00113681",
> 		"N00117780",
> 		"N00118519",
> 		"N00118995",
> 		"N00120100",
> 		"N00120333",
> 		"N00121238",
> 		"N00121369",
> 		"N00122594",
> 		"N00124325",
> 		"N00124769",
> 		"N00125806",
> 		"N00125907",
> 		"N00126542",
> 		"N00131342",
> 		"N00016668",
> 		"N00018355",
> 		"N00019033",
> 		"N00019572",
> 		"N00025374",
> 		"N00026805",
> 		"N00027009",
> 		"N00031287",
> 		"N00032471",
> 		"N00037524",
> 		"N00037860",
> 		"N00045536",
> 		"N00046923",
> 		"N00047875",
> 		"N00048143",
> 		"N00048285",
> 		"N00051695",
> 		"N00055892",
> 		"N00056078",
> 		"N00057234",
> 		"N00057824",
> 		"N00058939",
> 		"N00060054",
> 		"N00060779",
> 		"N00061808",
> 		"N00061839",
> 		"N00064102",
> 		"N00065715",
> 		"N00066847",
> 		"N00068114",
> 		"N00068650",
> 		"N00072731",
> 		"N00073615",
> 		"N00077000",
> 		"N00077428",
> 		"N00077480",
> 		"N00080037",
> 		"N00080937",
> 		"N00081871",
> 		"N00082169",
> 		"N00085404",
> 		"N00085541",
> 		"N00086975",
> 		"N00088075",
> 		"N00088808",
> 		"N00089931",
> 		"N00091601",
> 		"N00097586",
> 		"N00097723",
> 		"N00097902",
> 		"N00098826",
> 		"N00098977",
> 		"N00099330",
> 		"N00100199",
> 		"N00156952",
> 		"N00160032",
> 		"N00162432",
> 		"N00165701",
> 		"N00167208",
> 		"N00168496",
> 		"N00171162",
> 		"N00171356",
> 		"N00171602",
> 		"N00198040",
> 		"N00201400",
> 		"N00201830",
> 		"N00202665",
> 		"N00202942",
> 		"N00203715",
> 		"N00203727",
> 		"N00203737",
> 		"N00203757",
> 		"N00204548",
> 		"N00204715",
> 		"N00205865",
> 		"N00206002",
> 		"N00206726",
> 		"N00206871",
> 		"N00207491",
> 		"N00207809",
> 		"N00208375",
> 		"N00188282",
> 		"N00188376",
> 		"N00188422",
> 		"N00188688",
> 		"N00189709",
> 		"N00190311",
> 		"N00190860",
> 		"N00191942",
> 		"N00192114",
> 		"N00193133",
> 		"N00193683",
> 		"N00193749",
> 		"N00194254",
> 		"N00195344",
> 		"N00196302",
> 		"N00196409",
> 		"N00197337",
> 		"N00197968",
> 		"N00198184",
> 		"N00198351",
> 		"N00198375",
> 		"N00198570",
> 		"N00131830",
> 		"N00134166",
> 		"N00138573",
> 		"N00138722",
> 		"N00139823",
> 		"N00141406",
> 		"N00141508",
> 		"N00142727",
> 		"N00143409",
> 		"N00144591",
> 		"N00145375",
> 		"N00146223",
> 		"N00147454",
> 		"N00148011",
> 		"N00148664",
> 		"N00150257",
> 		"N00151340",
> 		"N00152224",
> 		"N00153686",
> 		"N00153796",
> 		"N00154434",
> 		"N00221087",
> 		"N00221130",
> 		"N00221300",
> 		"N00221338",
> 		"N00222007",
> 		"N00222445",
> 		"N00223041",
> 		"N00223935",
> 		"N00224074",
> 		"N00225634",
> 		"N00226174",
> 		"N00227106",
> 		"N00227400",
> 		"N00228315",
> 		"N00228410",
> 		"N00228705",
> 		"N00228901",
> 		"N00228925",
> 		"N00228980",
> 		"N00229185",
> 		"N00230101",
> 		"N00031683",
> 		"N00035219",
> 		"N00037022",
> 		"N00037155",
> 		"N00038963",
> 		"N00039509",
> 		"N00039708",
> 		"N00039896"
> 	]
> }