This discussion is archived
1 Reply Latest reply: Mar 21, 2013 10:31 PM by Deep00 RSS

XmlViewService.executeXmlQuery() does not respect maxRowsPerPage

522865 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points