Where Clause Passed to Report Incorrectly

Options
nimebejo
nimebejo
edited February 11, 2022 in Analytics #1
<p>We are running Maximo 7.5 and BIRT 3.7.1</p>
<p> </p>
<p>I have a report that uses the params["where"] to display a list of work orders; however no work orders are displayed when the report is run from Maximo. I've added the params["where"] to display on the report.</p>
<p> </p>
<p>In the BIRT Designer the report runs correctly and displays results. In Maximo the report runs but does not display results.</p>
<p> </p>
<p>In maximo, the where clause is displayed on the report as: "��݊�8�F8�D�w�Z����#Fr�ȃ�^Ù¤/Dи1� �eΑӧ2" so it makes sense that no results are returned. </p>
<p> </p>
<p>Any ideas why the where clause would be getting so messed up?</p>
<p> </p>
<p>Thank you,</p>
<p> </p>
<p>Nick</p>

Comments

  • jverly01
    jverly01
    #2
    Options
    <p>Can you post the entire select statement from the report?</p>
  • nimebejo
    nimebejo
    #3
    Options
    <p>I rebuilt the report by copy/pasting the elements into a new report and it worked. There must have been some stray artifacts in the XML.</p>
    <p> </p>
    <p>Thank you.</p>
  • wwilliams
    wwilliams
    #4
    Options
    <p>we just finished the the 7.5.0.8 patch and I saw this with a report, I rebuilt the request page and it worked correctly.</p>

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs