Sunday, 12 June 2022

Standalone Lookup Using Relationship - Birt Report Parameter (Without New Attribute) || Maximo

There was a requirement of Month Parameter to be added on report runtime. The Month was already handled in the report query but we need standalone lookup just for month selection. But Maximo didn't allowed standalone lookup without linking attribute to the parameter. 

So we ended up with the below solution to add add Standalone Lookup Using Relationship - Birt Report Parameter (Without New Attribute).

Steps:

  • Add new ALN Domain with Month Values e.g. JAN, FEB, MAR....

  • Add following new Lookup changes in LOOKUPS.XML file with where clause = "DOMAINID = 'ZZMONTH' "

<table id="zzmonth" inputmode="readonly" mboname="ALNDOMAIN" selectmode="single" whereclause=" DOMAINID = 'ZZMONTH' ">

<tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="zzmonth_lookup_tablebody">

<tablecol dataattribute="value" id="zzmonth_lookup_tablebody_col_0"                                                     mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>

<tablecol dataattribute="description" id="zzmonth_lookup_tablebody_col_1"                                         mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>

</tablebody>

</table>

  • Create a Relationship zzmonth with ALNDOMAIN Table to get target the value attribute for ALNDOMAIN table.
    • where clause: DOMAINID = 'ZZMONTH'
  • Add new Parameter with name "p_month" in report administration application for your specific report. Add attribute name with the newly created relationship "zzmonth".
    • Attribute Name: zzmonth.value
    • Lookup Name: zzmonth








No comments:

Post a Comment