Maximo

Maximo

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

 View Only

  • 1.  Ad-hoc report filling in gaps on right side of join incorrectly

    Posted Tue November 02, 2021 09:49 AM
    Edited by System Admin Wed March 22, 2023 11:48 AM
    MAM 7.6.1.2:

    I have a view object in Maximo that only selects WOs, not tasks (ISTASK=0).
    I effectively have a left join from the WORKORDER table to the view.

    If I were to mock up what Maximo does, but in an SQL client, it would look like this:
    select
    wo.wonum as wo_wonum,
    wo.istask as wo_istask,
    vw.istask as vw_istask
from
    maximo.workorder wo
left join
    maximo.wotaskrollup_vw vw
    on wo.wonum = vw.wonum​


    As expected, view doesn't have any matching tasks, so the task rows have nulls in the view column.


    However, if I do the same sort of thing in an ad-hoc report, the task rows have "N" values in the VW.ISTASK column, which is incorrect/unexpected.
    For the task rows, the VW.ISTASK values should be null, just like other columns from the view (such as VW.ACTTOTALCOST_TASKS_INCL).

    (Screenshot of the relationship: https://i.stack.imgur.com/DL77v.png)



    Question:
    Why is the ad-hoc report filling in gaps on right side of the join incorrectly? (for the VW.ISTASK column)
    The highlighted values should be null, not "N".

    Thanks.


    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Ad-hoc report filling in gaps on right side of join incorrectly

    Posted Tue November 02, 2021 03:29 PM
    Could it be that the MAXTYPE for the Maximo attribute ISTASK for Maximo View Object wotaskrollup_vw is YORN and default value is 0? You could change MAXTYPE to UPPER length 1 and apply decode to pass Y, N or NULL.

    ------------------------------
    Nivin Jacob George Senior Consultant
    Senior Consultant
    Praxis Solutions
    Kuwait
    ------------------------------

    Original Message


  • 3.  RE: Ad-hoc report filling in gaps on right side of join incorrectly

    Posted Tue November 02, 2021 03:37 PM
    Good idea. The default value is 0.



    Original Message


  • 4.  RE: Ad-hoc report filling in gaps on right side of join incorrectly

    Posted Tue November 23, 2021 10:16 PM

    Original Message


  • 5.  RE: Ad-hoc report filling in gaps on right side of join incorrectly

    Posted Mon November 29, 2021 12:44 PM
    That "decode" idea is interesting. Thanks.
    Original Message