Getting Started With MarkLogic Server — Chapter 3

Create a Simple JSON Document

To create a simple document and query it, perform the following steps:

1. Go to the following URL (substitute your hostname if MarkLogic is not running on your local machine):

   http://localhost:8000/

2. When prompted, enter a username and password. The user should have the admin role (you can use the same user created when you installed MarkLogic).
3. Optionally, in Query Console, create a new workspace. This will make it easier to come back to later.
4. To create a JavaScript object and return the results, enter the following in the query text area of Query Console:

   var obj = {key1:"value1", key2:"value2"};
   obj;

   Click the Run button. You will see the object serialized in the results pane.

5. To create a document, enter the following in the query text area of Query Console:

   declareUpdate();
   var obj = {key1:"value1", key2:"value2"};
   xdmp.documentInsert("/simple.json", obj);

   Click the Run button. You will see your query response was empty in the results pane. But what actually happened is you created a document in the database. The declareUpdate() function is required everytime your program includes an update to the database (otherwise an exception is thrown--try it).

6. Look at the document you just created by entering the following in the query text area of Query Console:

   cts.doc("/simple.json");

   Click the Run button. You will see the JSON document you created in the results pane.

7. To see the key1 property, enter the following and then click the Run button:

   cts.doc("/simple.json").root.key1;

   You will see the value for the key1 property (value1) in the results pane. Note that cts.doc returns a document node, so you first have to navigate to the root to get to the JSON node, and then you can navigate to the key1 property.

Creating and Searching Documents

To create some documents and then perform some searches against them, perform the following steps:

1. In Query Console, run the following:

   // create some documents to search over
   declareUpdate();
   var phrase1 = "The quick brown fox jumps over the lazy dog.";
   var fox = {fox: phrase1};
   var phrase2 = "The huge white elephant walked in the mud.";
   var elephant = {elephant: phrase2};
   var phrase3 = "The fast electric car drove down the highway.";
   var car = { car: phrase3};
   var obj1 = { fox: {colors:["brown", "red", "yellow"],
                      actions:["jump", "sleep", "eat"]} ,
               elephant: {colors:["brown", "white", "green"],
                      actions:["blow horn", "sleep", "eat", "walk"]},
               car: {colors:["brown", "red", "yellow", "green", "grey"],
                      actions:["speed", "drive", "stop", "accelerate"]}
              };
   var col = "my-phrases";
   var perms = [xdmp.permission("qconsole-user", "read"),
                xdmp.permission("qconsole-user", "update")];
   xdmp.documentInsert("/fox.json", fox, perms, col);
   xdmp.documentInsert("/elephant.json", elephant, perms, col);
   xdmp.documentInsert("/car.json", car, perms, col);
   xdmp.documentInsert("/stuff.json", obj1, perms, col);

2. Click the Explore button in query console. You should see the four new documents you just created. You can click on them to see their contents.
3. Now in another Query Console buffer, run the following:

   // find all documents with the word "the" in the "my-phrases"
   // collection and count them
   var count = 0;
   var results = new Array();
   for (var result of cts.search(
          cts.andQuery(["the", cts.collectionQuery("my-phrases")]))) {
     count++;
     results.push(result); };
   results.push(fn.concat("Count = ", count));
   results;

   This returns the following array:

   [
    {"car":"The fast electric car drove down the highway."}, 
    {"fox":"The quick brown fox jumps over the lazy dog."},
    {"elephant":"The huge white elephant walked in the mud."}, 
    "Count = 3"
   ]

4. Now in another Query Console buffer, run the following:

   // find all documents in the "my-phrases" collection 
   // with the word "car" and count them
   var count = 0;
   var results = new Array();
   for (var result of cts.search(cts.andQuery([
           cts.collectionQuery("my-phrases"),
           cts.wordQuery("car")])) ) {
     count++;
     results.push(result); };
   results.push(fn.concat("Count = ", count));
   results;

   This returns the following array:

   [
    {"car":"The fast electric car drove down the highway."},
    "Count = 1"
   ]

5. Try changing some of the values in the cts.collectionQuery or the cts.wordQuery to see what different results you get.
6. Now in another Query Console buffer, run the following:

   // find all documents with the word "car" and count them
   var count = 0;
   var results = new Array();
   for (var result of fn.collection() ) {
     var res = result.root.car;
     var x = res;
     count++;
     results.push(x); };
   results.push(fn.concat("Count = ", count));
   results;

   This returns the following array:

   [
    "The fast electric car drove down the highway.", 
    null, null, 
    {"colors":["brown", "red", "yellow", "green", "grey"],
     "actions":["speed", "drive", "stop", "accelerate"]}, 
    "Count = 4"
   ]

7. A simpler way to find the number of documents with the word car in it is to perform the following:

   cts.estimate("car");

   This is an estimate of the number of documents that match the query, which means it is the number of documents that the indexes indicate are a match. For many searches, this will be accurate. For details about search, see the Search Developer's Guide.

8. You can also use the jsearch API to perform the search as follows:

   var jsearch = require('/MarkLogic/jsearch.sjs');
   jsearch.documents()
     .where([cts.collectionQuery('my-phrases'), cts.wordQuery('car')])
     .map({snippet: true})
     .result();

   This returns two objects, the first is the HTTP header and the second contains the response from the endpoint, which contains a report detailing what matches the search.

   {"results":
     [{"score":108544, 
       "fitness":0.670031011104584, 
       "uri":"/car.json", 
       "path":"fn:doc(\"/car.json\")", 
       "confidence":0.497606456279755, 
       "index":0,
       "matches":
         [{"path":"fn:doc(\"/car.json\")/text(\"car\")",
           "matchText":
             ["The fast electric ", {"highlight":"car"}, 
              " drove down the highway."]
           }]
     }], 
    "estimate":1
   }

   For details about jsearch, see jsearch API Documentation and Creating JavaScript Search Applications in the Search Developer's Guide.

This is just a very brief introduction to how you can search in documents. For information about the search functionality possible in MarkLogic, see the Search Developer's Guide.