Databases
StackOverflow2013
Postsdbo
PORetrieve fields with space in the name through javascript
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORetrieve fields with space in the name through javascript
    primarykey
    data
    text
    <p>I have a problem in retrieving fields stored in MongoDB using a javascript script.</p> <p>The db has been stored automatically after a web-crawl. Here's an example of an entry:</p> <pre><code>{ "_id" : ObjectId("51ed0b2e12fd5629bf380355"), "title" : "Robert", "extraction" : { "infobox" : [ { "given name" : { "region" : "Germanic", "articles" : "Robert", "pronunciation" : "{{IPAc-en|ˈ|r|ɒ|b|ər|t}}", "related names" : "Rob, Robbie, Robin, Rupert, Bob, Bobby, Bert, Rahbert", "name" : "Robert", "gender" : "Male", "meaning" : "\"fame-bright\"" } } ] } } </code></pre> <p>I have to retry all the couples <em>title</em> - <em>related names</em>. I wrote this javascript:</p> <pre><code>db = connect("localhost:27017/Test"); var nameCursor = db.Test.find({"extraction.infobox.given name.related names":{$exists:true}},{"title":1,"extraction.infobox.given name.related names":1}); nameCursor.forEach( function(myDoc) { print(myDoc.title+" "+extraction.infobox.given name.related names ); } ); quit(); </code></pre> <p>which of course is not working when it has to print because of the space in <code>given name</code> and <code>related names</code> fields. Is there a way to escape the space, or at least to print the <em>infobox</em> json string, which I will eventually parse? </p> <p>Thanks in advance!</p> <p>P.S. I already know that next time I will have to substitute the space in the field keys with <code>_</code>. The extraction takes a long time, and now I quite in a hurry :)</p> <p><strong>Edit after Sammaye comment</strong></p> <p>Using <code>extraction.infobox['given name']['related names']</code>, it gives me the error </p> <pre><code> JavaScript execution failed: TypeError: Cannot read property 'related names' of undefined at names.js:L14 </code></pre> <p>Of course, if I use <code>extraction.infobox['given name']</code> it prints </p> <pre><code>Robert undefined </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdavide
    1. USdavide
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO`extraction.infobox['given name']['related names']`
      singulars
      1. PORetrieve fields with space in the name through javascript
      1. USSammaye
    2. COIt is not working (see edit), could it be because of the array nature of `infobox`?
      singulars
      1. PORetrieve fields with space in the name through javascript
      1. USdavide
    3. CONah arrays and objects are both objects and can be accessed the same, most likely your structure or your query is not working as you expect
      singulars
      1. PORetrieve fields with space in the name through javascript
      1. USSammaye
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload