0 Replies Latest reply: Dec 17, 2012 9:10 AM by user11109786 RSS

    RESTFul webservice does not return all fields defined in query

    user11109786
      Hello,

      I get a restful webservice defined and it return results when I click test button. But in the result returned, it only has two fields but not all fields I defined. Someone asked to post it in apex listener instead apex forum.

      Any Ideas?

      Version: 4.2
      query:
      select service_overview_his_id,
      a.service_id, b.service_name,
      cyear || '-' || cmonth month,
      enviorment,
      num,
      availability_percent,
      total_gb,
      used_gb,
      create_user_id,
      create_time
      from dbmon_service_overview_his a inner join dbmon_service_avil b on(a.service_id = b.service_id)
      where (cyear || '-' || cmonth) = :c_month

      test result:
      {"next":{"$ref":"http://xxxx:7777/apex/dbmonitor/dba/report/overviewdba/report/overview/2012-11?page=1"},"items":[{"service_overview_his_id":19,"service_id":1},{"service_overview_his_id":20,"service_id":1},{"service_overview_his_id":21,"service_id":2},{"service_overview_his_id":22,"service_id":2},{"service_overview_his_id":23,"service_id":3}]}

      Thanks,

      Robin