How to get over 100 records from azure space db using query

Question

I want to get over 100 entries from the azure-cosmos database using a select query.

I am writing a stored procedure and using the select query to retrieve the record.

SELECT * FROM activities a

I get a total of 100 entries, although there are more than 500 entries. I can get all the configuration settings provided by Azure.

I want to perform the same operation using a query or stored procedure. How can i do this?

Please suggest changes that need to be made.

Answer 1

I am writing a stored procedure and using the select query to retrieve the record.

SELECT * FROM actions a

I get only 100 entries, although there are more than 500 entries.

FeedOptions pageSize queryDocuments 100, . -1. , , .

function getall(){
 var context = getContext();
  var response = context.getResponse();
  var collection = context.getCollection();
  var collectionLink = collection.getSelfLink();

  var filterQuery = 'SELECT * FROM c';

  collection.queryDocuments(collectionLink, filterQuery, {pageSize:-1 },
    function(err, documents) {
      response.setBody(response.getBody() + JSON.stringify(documents));
    }
  );
}

Answer 2

:

    function EstraiDatiBulk () {
        var context = getContext();
        var response = context.getResponse();
        var collection = context.getCollection();
        var collectionLink = collection.getSelfLink();

        var filterQuery = 'SELECT c.messageUID as messageUID, ';
        filterQuery += 'c.messageId as messageId, ';
        filterQuery += 'c.release as release, ';
        filterQuery += 'c.VIn/100 as VIn, ';
        filterQuery += 'c.VOut/100 as VOut, ';
        filterQuery += 'c.AIn/100 as AIn, ';
        filterQuery += 'c.AOut/100 as AOut, ';
        filterQuery += 'c.CosPhi as CosPhi, ';
        filterQuery += 'c.W/100 as W, ';
        filterQuery += 'c.WhCnt/3600 as WhCnt, ';        
        filterQuery += 'c.VarhCnt/3600 as VarhCnt, ';
        filterQuery += 'c.TimeSlot as TimeSlot, ';
        filterQuery += 'c.MeterTS as MeterTS, ';
        filterQuery += 'c.VA as VA, ';
        filterQuery == 'c.Var/100 as Var, ';
        filterQuery += '((c.VIn-c.VOut)/c.VIn)-0.01 as Efficiency, ';
        filterQuery += 'c.Sampling as Sampling, ';
        filterQuery += 'c.Wh/3600 as Wh, ';
        filterQuery +=  'c.Varh/3600 as Varh, ';
        filterQuery +=  'c.id as id, ';
        filterQuery +=  'c.EventProcessedUtcTime as EventProcessedUtcTime, ';
        filterQuery +=  'c.EventEnqueuedUtcTime as EventEnqueuedUtcTime ';
        filterQuery +=   'FROM c';

        collection.queryDocuments(collectionLink, filterQuery, {pageSize:-1 },
            function(err, documents) {
            response.setBody(response.getBody() + JSON.stringify(documents));
            }
      );
    }

. - ? . .