How to get total count in couchbase Views -

-

when query view in couchbase using user_id(key), limit(10) , skip(0) parameter, response has following structure:

{   "total_rows":1896,   "rows":[...] }

here view return list of reports based on user_id:-

function map(doc, meta) {     if (doc.type == 'report' && doc.subscribed) {         (var subscriber in doc.subscribed) {             emit(subscriber, doc);         }     } }

here sample report doc:- 

{    "agree_allowed":true,    "assigned_by":"",    "assigned_to":"",    "closed":[     ],    "comments_allowed":true,    "details":"test",    "email":"",    "status":"in progress",    "subscribed":{       "user_cfd29b81f0263a380507":true,       "user_cfd29b81f0263a380508":true,       "user_cfd29b81f0263a380509":true,       "user_cfd29b81f0263a3805010":true    },    "summary":"test",    "time_open":0,    "timestamp":"2015-07-17t15:34:30.864z",    "type":"report",    "user_id":"user_cfd29b81f0263a380507",    "username":"test17" }

but rows count 3, if want achieve pagination how can total count, can useful pagination.

total_rows contains unfiltered count, should equal total number of subscribed entries (all [user,report] pairs).

if want efficient pagination, shouldn't use skip(n), because forces index scan n first rows , discard them.

what should instead use startkey, startkey_docid , limit (well, use skip(1) rid of last result of previous page).

this explained in quite bit of detail in blog post: http://blog.couchbase.com/pagination-couchbase


Comments

Post a Comment

Popular posts from this blog

node.js - NodeJS remote terminal to Dropbear OpenWRT-Server -

-
i wandering whether there valid solution have remote terminal openwrt-box out of nodejs-app? connecting terminal works: ssh -i ~/.mykeys/id_rsa root@192.168.178.39 busybox v1.23.2 (2015-04-22 23:25:48 utc) built-in shell (ash) root@openwrt:~# the only interactive ssh solution nodejs doesn't interactive part described in readme.md following: var client = require('ssh2').client; var conn = new client(); conn.on('ready', function() { console.log('client :: ready'); conn.shell(function(err, stream) { if (err) throw err; stream.on('close', function() { console.log('stream :: close'); conn.end(); }).on('data', function(data) { console.log('stdout: ' + data); }).stderr.on('data', function(data) { console.log('stderr: ' + data); }); stream.end('ls -l\nexit\n'); }); }).connect({ host: '192.168.100.100', port: 22, username...
Read more

python - jinja2: TemplateSyntaxError: expected token ',', got 'string' -

-
i new jinja2 , having issue using python regular expression (re). in following code bold lines have error string in them. {% block content %} <div class="container"> {% l in lines %} {% if re.search(r"error", l) %} {# <<< throws error #} <b> {{ l }} </b> {% else %} {{ l }} <hr> {% endif %} {% endfor %} </div> {% endblock %} the re.search above throws following error: jinja2.exceptions.templatesyntaxerror templatesyntaxerror: expected token ',', got 'string' raw python code not supported in jinja2 template syntax. {% if re.search(r"error", l) %} replace line with {% if "error" in l %} can fix problem. if logical condition more complicated, should consider defining own custom filters (which can call python code) or complicated things in view layer. go check global namespace .
Read more

Qt4: how to send QString inside a struct via QSharedMemory -

-
i have struct struct control_data{ int column_number; qstring cell; }; i need send thread of qsharememory. read can't because qstring contains pointers inside. other ways? you have serialize struct byte array. can convert qstring const char* this: mystring.tostdstring().c_str(); but serializing qstring should work. the first step serialize struct qdatastream using qt, example here . then once struct can read , written can pass shared memory. a complete example of using qsharedmemory can found here . here relevant code: // first, test whether shared memory segment attached process. // if so, detach if (sharedmem.isattached()) { sharedmem.detach(); } ... qbuffer buffer; buffer.open( qbuffer::readwrite ); qdatastream out( &buffer ); out << youstruct; int size = buffer.size(); // size of int + size of qstring in bytes if ( !sharedmem.create( size ) ) { return; } // write shared memory sharedmem.lock(); char *to = (char*...
Read more