{"id":630,"date":"2023-10-23T10:56:21","date_gmt":"2023-10-23T08:56:21","guid":{"rendered":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/?page_id=630"},"modified":"2026-07-14T20:55:21","modified_gmt":"2026-07-14T18:55:21","slug":"2-10-buscar-en-un-array-de-documents","status":"publish","type":"page","link":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/2-10-buscar-en-un-array-de-documents\/","title":{"rendered":"2.10. Buscar en un <em>array<\/em> de documents"},"content":{"rendered":"<p>Si ens fixem en l\u2019estructura del fitxer JSON importat, nom\u00e9s cont\u00e9 un document JSON. I en un dels camps, l\u2019anomenat <strong>knownGene<\/strong>, cont\u00e9 un <em>array<\/em> de documents JSON, i cada document de l\u2019<em>array<\/em> cont\u00e9 informaci\u00f3 dels gens del cromosoma 11: nom, cadena, cromosoma, etc.<\/p>\n<p>Aix\u00f2 ens obliga a con\u00e8ixer com es treballa amb els continguts dels <em>arrays<\/em> si volem gestionar correctament aquesta informaci\u00f3.<\/p>\n<p>Hem de fer servir el <code>dot.notation<\/code>.<\/p>\n<p>Per exemple, mostrarem la informaci\u00f3 del gen <code>uc009vis.3<\/code>.<\/p>\n<p>Aquesta \u00e9s la instrucci\u00f3:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\" data-enlighter-theme=\"mowtwo\">db.chr11.find({ \"knownGene.name\": \"uc009vis.3\"}, {\"knownGene.$\": 1}).pretty();\r\n\r\n<\/pre>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\" data-enlighter-theme=\"mowtwo\">&gt; db.chr11.find(\r\n\u2026 { \"knownGene.name\": \"uc009vis.3\"}, {\"knownGene.$\": 1}\r\n\u2026 ).pretty();\r\n{\r\n        \"_id\" : ObjectId(\"6487db999faf672901337f0a\"),\r\n        \"knownGene\" : [\r\n                 {\r\n                        \"name\" : \"uc009vis.3\",\r\n                        \"chrom\" : \"chr11\",\r\n                        \"strand\" : \"-\",\r\n                        \"txStart\" : 14361,\r\n                        \"txEnd\" : 16765,\r\n                        \"cdsStart\" : 14361,\r\n                        \"cdsEnd\" : 14361,\r\n                        \"exonCount\" : 4,\r\n                        \"exonStarts\" : \"14361,14969,15795,16606,\",\r\n                        \"exonEnds\" : \"14829,15038,15942,16765,\",\r\n                        \"proteinID\" : \"\",\r\n                        \"alignID\" : \"uc009vis.3\"\r\n                 }\r\n        ]\r\n}\r\n&gt;<\/pre>\n<p>Veiem com per referir-nos al nom del gen escrivim <code>\"knownGene.name\":<\/code> \u00e9s a dir, el nom del camp del document que \u00e9s un <em>array<\/em> de documents JSON, el <code>knownGene<\/code>, punt i a continuaci\u00f3 el nom del camp dels documents que es troben <em>a <\/em>l\u2019<em>array<\/em> <code>name<\/code>. Amb <code>knownGene.$\": 1<\/code> indiquem que ens mostri tots els camps dels documents trobats a l\u2019<em>array<\/em> <code>knownGene<\/code>.<\/p>\n<p>El <code>dot.notation<\/code> tamb\u00e9 ens serveix per referir-nos a camps de documents embeguts.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si ens fixem en l\u2019estructura del fitxer JSON importat, nom\u00e9s cont\u00e9 un document JSON. I en un dels camps, l\u2019anomenat knownGene, cont\u00e9 un array de documents JSON, i cada document de l\u2019array cont\u00e9 informaci\u00f3 dels gens del cromosoma 11: nom, cadena, cromosoma, etc. Aix\u00f2 ens obliga a con\u00e8ixer com es treballa amb els continguts dels [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"acf":[],"_links":{"self":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/630"}],"collection":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/comments?post=630"}],"version-history":[{"count":8,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/630\/revisions"}],"predecessor-version":[{"id":1099,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/630\/revisions\/1099"}],"wp:attachment":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/media?parent=630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}