php - mongodb querying sub array -

-

i have array multiple sub-arrays:

> db.alumnos111.findone({curp:'aelj951211mascpn04'}) {         "_id" : objectid("520d5440bee9577c283542c3"),         "nocontrol" : "10301051680201",         "nombre" : "janette araceli",         "paterno" : "acero",         "materno" : "lopez",         "curp" : "aelj951211mascpn04",         "generacion" : "2010-2013",         "carrera" : "informÁtica",         "clv_centro" : "01dct0001f",         "estado" : "aguascalientes",         "plantel" : "cbtis no. 168",         "id_plantel" : "513",         "materias" : [                 {                         "semestre" : "4",                         "nombre_asignatra" : "ecologÍa",                         "grupo" : "4a",                         "turno1" : "2001",                         "parcial1" : "10",                         "parcial2" : "9",                         "parcial3" : "9",                         "calificacion" : "9",                         "periodo" : "semestral 2 - 2011",                         "id_periodo" : "111",                         "id_plangpo" : "14",                         "id_materia" : "4529"                 },                 {                         "semestre" : "4",                         "nombre_asignatra" : "fÍsica i",                         "grupo" : "4a",                         "turno1" : "2001",                         "parcial1" : "8",                         "parcial2" : "10",                         "parcial3" : "10",                         "calificacion" : "9",                         "periodo" : "semestral 2 - 2011",                         "id_periodo" : "111",                         "id_plangpo" : "14",                         "id_materia" : "4530"                 },                           {                         "semestre" : "4",                         "nombre_asignatra" : "inglÉs iv",                         "grupo" : "4a",                         "turno1" : "2001",                         "parcial1" : "8",                         "parcial2" : "10",                         "parcial3" : "9",                         "calificacion" : "9",                         "periodo" : "semestral 2 - 2011",                         "id_periodo" : "111",                         "id_plangpo" : "14",                         "id_materia" : "4531"                 },                  ] }

how should filter subarray(s) {"materias.id_materia" : '$in' ("4531",'4530'),'parcial3':10} of current _id?

any in php db->find or javascript helpful.

your query should looks this

db.alumnos111.find({"materias.id_materia" : { $in : [ "1234", "5678"] }})

to filter out documents w/ id_materia="1234" or id_materia="5678"

this example javascript executed straight in mongo shell


Comments

Post a Comment

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

-
the current version of mozilla firefox 23.0.1, version not support play mp3 shoutcast streams tcp port different 80 (most common 8000 shoutcast 1.9.8). i use flash when mp3 support not available in html5 audio, way detect is: try{ var = document.createelement('audio'); r = !!(a.canplaytype && !!a.canplaytype("audio/mpeg; codecs=mp3").replace(/^no$/,'')) }catch(e){ r = false; } the support mp3 shoutcast streams in firefox added in version 24 . a.canplaytype("audio/mpeg; codecs=mp3") = in chrome , firefox, chrome support, firefox not support, due current code detect not work firefox. the current version of jquery support ie 6 1.10.2, version not has .browser i think "stylized" way testing features , not querying browsers / versions, notwithstanding here see hard not violate "principle". what "stylized" way of detect mp3 icy support without navigator.useragent in firefox? ther...
Read more

web - SVG not rendering properly in Firefox -

-
i have problem svg renderring in firefox. whilst works in safari, chrome or in ie, doesn't work in firefox. inspecting element seems layers there, background visible if it's z-index higher z-index of others. rendered in firefox: svg logo in firefox link original source file: svg file thanks help. ps: used sketch 3 export svg. if helps somehow. you're experiencing bug 995813 . i fixed bug time ago change still making way through release process example display correctly firefox 31 onwards released on 22 july 2014. in meantime if move fill="white" <mask> element child <use> element work around firefox bug.
Read more

java - JavaFX 2 slider labelFormatter not being used -

-
i have following code not label slider "foo50", etc... 1 expect setlabelformatter call, instead seems have no effect (the slider labelled 50, 100, etc , println's dont run). there missing? not implemented in default 2.2 skin? using oracle java 7 package javafxbugtest; import javafx.application.application; import javafx.scene.*; import javafx.scene.control.*; import javafx.stage.*; import javafx.util.stringconverter; public class javafxbugtest extends application { @override public void start(final stage primarystage) { slider cp = new slider(); cp.setlabelformatter(new stringconverter<double>() { @override public string tostring(double t) { system.out.println("nope?"); return "foo" + t.tostring(); } @override public double fromstring(string string) { system.out.println("he...
Read more