Maximo Open Forum

 View Only

  • 1.  Maximo Hover

    Posted 06-25-2021 15:24
    I thought I might be able to create a view and then a relationship using POLINE where the new view is the child. I was hoping that I could pull additional information. I put the hover on the POLINE.ITEMNUM, it works for anything ITEM table related and invalid for the other columns in the view. 
    The view has item related data as well as last price paid and last date etc.

    I wanted the buyer to be able to hover and get previous PO info on the part..Just seems bizarre unless there is a default hover for the POLINE itemnum I don't see.

    Any ideas?
    Thx
    #Administration
    #EverythingMaximo

    ------------------------------
    Wes Williams
    Northrop Grumman
    ------------------------------


  • 2.  RE: Maximo Hover

    Posted 06-28-2021 09:35
    Hover dialogs, like lookups, function based on the related object, which in this case is item. You could create a relationship from ITEM to POLINE/your custom view. Only one record would be available and you would have to do something like only looking at closed POs or you're potentially going to get your own PO in the hover dialog which I don't think would be helpful.

    ------------------------------
    Steven Shull
    Projetech Inc.
    ------------------------------

    Original Message


  • 3.  RE: Maximo Hover

    Posted 06-28-2021 11:02
    Edited by Wes Williams 06-28-2021 11:19
    I created a relationship from POLINE to the view I created, The view includes the item, po, 
    poline and a derived table (to pull last unit cost and order date)  
    The hover shows the data from the item table, but invalid bindings for the last price( unit cost) and last order date.
    The control in the PO app Hover Window attribute = LASTPRICE.ITEMNUM LASTPRICE being the relationship.
    Anything related to the item table works, other fields in the relationship show invalid bindings.
    So not sure where you were going with ". Only one record would be available and you would have to do something like only looking at closed POs or you're potentially going to get your own PO in the hover dialog"
     
    I am looking at closed and approved to get the last price, using only the closed would not provide that last price.
    Thx!

    I tried a relationship from ITEM to POLINE/your custom view using the same view and I get the same results.:-(

    Original Message


  • 4.  RE: Maximo Hover

    Posted 06-28-2021 13:24
    I am assuming this is my issue https://www.ibm.com/support/pages/adding-hover-dialogs-additional-fields-maximo-76

    "Please note that the hover dialogue only works when there is a field validation class, or a table domain connected to the attribute. If you add hover functionality to an attribute which doesn't have a field validation class, such as the ASSET.CHANGEBY, or SR.ENTEREDBY, then the hover dialog will display but it is blank, it does not show any data."  although I get binding issues

    ------------------------------
    Wes Williams
    Northrop Grumman
    ------------------------------

    Original Message


  • 5.  RE: Maximo Hover

    Posted 06-28-2021 15:01

    The IBM technote shouldn't be an issue as POLINE.ITEMNUM does have a field class. If nothing worked then that would be an issue, but because some attributes work that shouldn't be a problem.

    As for my reference about closed, what I intended to convey was that only 1 record can be displayed in a hover dialog even though a relationship might return more than 1 record. How the join from ITEM to POLINE is written could return the POLINE in question that a user is looking at which might be confusing to a user who is looking for past cost information. For example, if PO 1001 was the last approved PO and you looked for the last approved POLINE referencing that item, hovering on PO 1001 would return the data for PO 1001. As long as that is the intent, that's fine, but could be confusing. 


    I created my own record hover for testing (cloning the item_recordhover) and added contractline.linecost and altitem.altitemnum and confirmed that in both cases it got displayed on the hover when a reference existed. I'm not sure why yours isn't working. I'd check your relationship to make sure there isn't a syntax error preventing it from rendering. 



    ------------------------------
    Steven Shull
    Projetech Inc.
    ------------------------------

    Original Message


  • 6.  RE: Maximo Hover

    Posted 06-29-2021 07:07
    Edited by Wes Williams 07-06-2021 11:54
    ​I got you, yes that would be the intent as that would be the last cost. I am using a relationship from POLINE to my view.  I was able to get it to work using the following XML. Thx!
    <recordhoversection id="item_p_rhs_1" label="Item Details" relationship="lastprice">
			<recordhoversectioncol id="item_p_rhsc_1">
				<recordhoversection id="item_p_rhs_2">
					<recordhovermultiparttextbox dataattribute="itemnum" descdataattribute="description" id="item_p_rh_1" label="Item"/>
					<recordhovertextbox dataattribute="nsn" id="item_p_rh_3" label="NSN"/>
					 <recordhovertextbox dataattribute="poline.lastprice.unitcost" id="item_p_rh_6" label="Last Unit Cost"/>
					<recordhovertextbox dataattribute="poline.lastprice.lastdate" id="item_prh_5" label="Last Order Date"/>
				</recordhoversection>
			</recordhoversectioncol>
			<recordhoversectioncol id="item_p_rhsc_2">
				<recordhoversection id="item_p_rhs_3">
				    <recordhovertextbox dataattribute="buyer"  id="item_p_rh_2" label="Buyer"/>
					<recordhovertextbox  dataattribute="adminlt" id="item_p_rh_8" label="Admin Lead Time"/>
					<recordhovertextbox  dataattribute="partleadtime" id="item_p_rh_9" label="Part Lead Time"/>​


    ------------------------------
    Wes Williams
    Northrop Grumman
    ------------------------------

    Original Message


Related Content