Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Request for assistance with passing an application parameter

    Posted 10/15/21 02:09 PM

    Good afternoon,

    I hope that all is well with you and yours.

    I am new to BIRT reporting and have made good progress through research – reading the guides and the eclipse forum, opentext forum. Many hours searching the internet.

    I have a dilemma trying to create listing of follow-up work orders on a report that I generate automatically through an automation script. All works well passing the WONUM as the application parameter except, the follow-up work orders. If I use .... + " where origrecordid ='" + params["where"] +"'" it works in BIRT Report Designer Preview when I give it a WONUM. But I have tried countless combinations before importing the design file in through Report Administration also taking care to generate a new request page after each iteration of the importation.

    These have included joining the RELATEDRECORD table and of course using the workorder attribute origrecordid.

    Any guidance would be greatly appreciated.

    Cheers,
    Colin



    ------------------------------
    Colin Aitchison
    ------------------------------

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Request for assistance with passing an application parameter

    Posted 10/15/21 03:49 PM

    Hi Colin,

    You didn't mention what was going wrong with your report but I'm assuming you're either getting an error or the report is just not returning any data.

    Have you tried changing Maximo's Log Level for reporting to DEBUG (https://www.ibm.com/support/pages/how-set-logging-maximo-birt-report-issues) and then reviewing your Maximo log for the detailed output when generating the report?  That output can give you more detail on what the source of an error is if you're getting one.  If there is no error, the log can also show you the exact query text being run against the database.  That's often helpful for identifying typos in your script or when parameter values aren't being processed in the way you might expect.



    ------------------------------
    Adam Davis
    Maximo Consultant
    Asset Partners
    Chicago IL
    312-224-8300
    ------------------------------



  • 3.  RE: Request for assistance with passing an application parameter

    Posted 10/15/21 04:07 PM
    Hi Adam,

    Thank you for the replay and I hope that all is well with you and yours. 

    Sorry, I should have provided more details in that I'm not getting an error I'm just not getting that data reported back to me in this table bound query additionally of note  the column binding is right. My other items using cell binding are returned. 
    I have the logger on and set to 'DEBUG' and it does show me the SQL which when passing the where clause  to the cell bound items like this"  ... +" where " + params["where"]... shows the WONUM without any quotation marks.

    Cheers,
    Colin

    ------------------------------
    Colin Aitchison
    ------------------------------

    Original Message


Related Content