Maximo

Maximo

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

 View Only

  • 1.  Build custom request page for BIRT report?

    Posted Mon January 25, 2021 07:53 PM
    Is it possible to build a custom request page for BIRT reports?

    For example, I'd use a custom form so that I could include things like the classification drilldown and the  GL selection window (as report parameters).

    Thanks.
    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Build custom request page for BIRT report?

    Posted Tue January 26, 2021 08:10 AM
    I've never had to use other controls on the request page so it's possible it may work or not. I'd assume as long as it works on the advanced search though it'd work as both use the concept of zombie MBOs.

    But modifying the request page is relatively easy. Each report has a unique dialog generated in the REPLIBRARY. You can get that by going to application designer and exporting the REPLIBRARY XML. Then search for the reportnum of your report (IE reportnum="1292" or id="reportd1292") and that is your dialog. You can modify the dialog here, or what I would recommend, is you can extract the dialog and add it as a dialog in the application itself. So if your report was run in WOTRACK for example, add the dialog to WOTRACK. 

    The reason for this is users may regenerate the request pages (in bulk or individually on your report) which will obliterate any changes you make in the REPLIBRARY. The Maximo framework looks for a dialog in the application first so it'll launch your custom dialog if you put it in the app. And you can make changes relatively safely here.

    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------

    Original Message


  • 3.  RE: Build custom request page for BIRT report?

    Posted Tue January 26, 2021 11:51 PM
    Edited by System Admin Wed March 22, 2023 11:44 AM
    Thanks Steven.

    I've made some progress on your suggestion:

    1. Extracted the OOB request page dialog from REPLIBRARY.xml and added it as a custom dialog in the WOTRACK application.
    2. Maximo automatically picks up the custom dialog (as you described).
    3. I copied and pasted the classification field/drilldown from WOTRACK.AdvancedSearch -to- the custom request page dialog.

    That all worked pretty good, however, I'm stuck when it comes to getting the WO classification drilldown to work properly.

    WO classification drilldown:

    It's my understanding that BIRT reports and ad-hoc reports can only use persistent fields, not non-persistent fields. When I look at the classification drilldown field that I pasted in from the WOTRACK.AdvancedSearch, I see that it's attribute is CLASSSTRUCTURE.HIERARCHYPATH. Unfortunately, that HIERARCHYPATH field is non-persistent. And while I am able to open the drilldown window and select a classification, when I navigate back to the request page dialog, the value is still blank for the classification field. So that's a bummer.

    (Hint: to zoom into the image, right click and open it in a new tab.)

    Custom hierarchy path field:

    I actually already have a custom/persistent hierarchy path field in the WORKORDER table. So I've gone ahead and changed the classification field's attribute from CLASSSTRUCTURE.HIERARCHYPATH -to- custom_HIERARCHYPATH. However, when I try to use the drilldown, I get the same result as before: I select a classification, but when I navigate back to the request page dialog, the value is still blank for the classification field.

    Note: the only difference now is, I can paste in a literal value (eg. FORESTRY \ TREE REMOVAL \ STREET TREE) to the field, and that technically works (it didn't work with the non-persistent field). If I run the report, the results get filtered by that hierarchy path. So at least that shows that the underlying custom field is working properly.

    But of course, users won't be copy/pasting in hierarchy paths, that's what the classification drilldown is supposed to be for.

    Question:

    Do you have any ideas as to how I could get the classification drilldown working for my custom/persistent hierarchy path field?

    Thanks.



    #Maximo
    #AssetandFacilitiesManagement


  • 4.  RE: Build custom request page for BIRT report?

    Posted Thu January 28, 2021 03:34 PM
    I'm so close! It's probably just a small thing that I've overlooked...
    Original Message


  • 5.  RE: Build custom request page for BIRT report?

    Posted Thu January 04, 2024 10:56 AM

    Hi User1971 @Steven Shull @Steven Shull - I am also trying to implement similar functionality with Custom Report lookup using LookupBean where I have parent-child records to select and comma-concatenate, everything is working perfectly but unable to set the concatenated values back to REPORTPARAMETER (where my Custom Lookup is associated). I have a Action Script which concatenate the selected records, but databean.getParent(), databean.getReturnAttribute() are NULL hence unable to set it to reportparam attribute.

    Any suggestions please?

    Thanks!



    ------------------------------
    Rahul Goyal
    ------------------------------

    Original Message


Related Content