CouchDB (Hardcoded) Multi-dimensional Query (by using List)

design.json

{
  _id: "_design/user_actions",
  _rev: "some-revision",
  views: {
    what_ever: {
      map: function(doc) {
        // ...
      }
    }
  },
  lists: {
    that_list: function() {
      start({
        headers: {
          "Content-Type": "application/json"
        }
      });

      var result = {};
      var row;
      while(row = getRow()) {
        var userId = row.value.userId;
        var action = row.value.action;
        if(!result[userId]) {
          result[userId] = {};
        }
        if(!result[userId][action]) {
          result[userId][action] = 0;
        }
        result[userId][action]++;
      }
      send(JSON.stringify(result));
    }
  }
}

document_example.json

...

result.json

// when calling http://couchurl/db/_design/user_actions/_list/that_list/what_ever?startkey=x&endkey=y