Maximo

Maximo

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

 View Only

  • 1.  BIRT report - Custom viewer URL and Parameters

    Posted Tue September 19, 2023 10:23 AM

    Hello all,

    I'm trying to configure separate hostname/URL to run, BIRT reports through 'mxe.report.birt.viewerurl' system property.
    It is opening reports in the specified hostname, but the parameter values are not passed except (params["where"]). That is, it fetches all records though values specified in parameters or filters only by the List tab's where clause.
    Is there any additional setting to be done?
    Maximo version : 7613
    BIRT Version: 431
    Kindly share your ideas/ experiece in similar issue.
    Thanks!


    ------------------------------
    Sankar Ganesh
    ------------------------------


  • 2.  RE: BIRT report - Custom viewer URL and Parameters

    Posted Mon September 25, 2023 10:25 AM

    Hi Sankar, 

    If you want to have hostname as a parameter value to be used, you can create a dataset under beforeOpen method and run a sql against maxpropvalue table. It CAN'T dynamically take the values of hostname with :HOSTNAME inside birt report. You need to query it from maximo table.

    What params you plan to use on your report ? Create them under report parameter or let me know on what values you want to use as params. 

    Thanks,

    Suren



    ------------------------------
    Surendar Balasundaram
    ------------------------------

    Original Message


  • 3.  RE: BIRT report - Custom viewer URL and Parameters

    Posted Fri September 29, 2023 05:18 AM

    Hi Surendar,

    Thanks for your repsonse!

    It is not about 'Adding hostname' as parameter.

    I'm trying to configure 'separate hostname of  running reports'/

    When I submit the report with parametrs, it open report in new tab with another URL (expected behaviour of .birt.viewerurl property). But it does not filter records based on parameter values.

    Do you have any idea on this?

    Thanks!



    ------------------------------
    Sankar Ganesh
    ------------------------------

    Original Message


  • 4.  RE: BIRT report - Custom viewer URL and Parameters

    Posted Tue October 17, 2023 10:15 PM

    Hi Shankar, 

    Please let me know the parameters that you are passing in the report and how you are using inside the query. 

    for example, MXReportSqlFormat.createParamWhereClause("WORKORDER.SITEID", params["siteid"])  

    -- OOB method in BIRT to read the siteid from the lookup and form a query. We need to use it in our Open method to filter the records. 

    Thanks and regards,

    Surender



    ------------------------------
    Surendar Balasundaram
    ------------------------------

    Original Message


Related Content