1 Reply Latest reply on Dec 16, 2015 4:40 AM by 713195

    Total Records in JSON of ORDS 3

    SYSMAN2007

      Hi

       

      I'm set Pagination Size in RESTful Module  to 3

      Resource Handler is GET and Source Type is Query:

       

      SELECT EMPNO,ENAME
      FROM EMP
      
      

       

       

      all records of EMP table is 50 records.

       

      How I can get total records count in URI json??

      like below below:

       

      {
          "first": 
      {
          "$ref": "http://appsdev2.isaco.ir:8080/ords/wrks_dev/test/vw_user_info_json/"
      },
      "previous":
      {
          "$ref": "http://appsdev2.isaco.ir:8080/ords/wrks_dev/test/vw_user_info_json/"
      },
      "next":
      {
          "$ref": "http://appsdev2.isaco.ir:8080/ords/wrks_dev/test/vw_user_info_json/?page=2"
      },
      "items":
      [
      {
          ...
      },
      {
         ...
      },
      {
          ...
      }
      ...
      "count":50
          ]
      }
      
      

       

      Also see example in ORDS documents show below infromatio in JSON

       

      "hasMore":true,

      "limit":7,

      "offset":0,

      "count":7,


      but I'm not see anything like this in my JSON results!!!


      * I'm create RESTful Service from apex and not used Sql Developer