1 Reply Latest reply: Mar 22, 2013 12:31 AM by Deep00 RSS

    XmlViewService.executeXmlQuery() does not respect maxRowsPerPage

    522865
      XmlViewService.executeXmlQuery() does not respect XMLQueryExecutionOptions.maxRowsPerPage. I tried 10, 20, but it always returned 500 rows. Is this a bug?
        • 1. Re: XmlViewService.executeXmlQuery() does not respect maxRowsPerPage
          Deep00
          Hi

          I understand you were using XmlViewService.executeXmlQuery() . I am using the same feature, but it always returns 0 rows, even the analysis returns 30 rows when executing on OBIEE.

          Could you please suggest a solution. Below is the code i have. I have even tried with maxRowsPerPage, but didn't make any difference.

          I am using OBIEE 11.1.1.6.5

          <code>
          XmlViewServiceSoap xmlViewServiceSoap = xmlViewService.getXmlViewServiceSoap();
          ReportRef rRef = new ReportRef();
          rRef.setReportPath("/xyz/abc/reportName");

          ReportParams rParams = new ReportParams();
          XMLQueryExecutionOptions xqeo = new XMLQueryExecutionOptions();
          xqeo.setRefresh(true);
          xqeo.setPresentationInfo(true);

          QueryResults qr = xmlViewServiceSoap.executeXMLQuery(rRef, XMLQueryOutputFormat.SAW_ROWSET_SCHEMA_AND_DATA, xqeo, rParams, sessionID);

          String result = qr.getRowset();
          </code>

          Edited by: Deep00 on 21-Mar-2013 22:31