Maximo Anywhere

Anywhere 764 - Resource filter in javascript code

  • 1.  Anywhere 764 - Resource filter in javascript code

    Posted Tue July 13, 2021 05:01 PM

    Hi,

    I would need to filter the asset lookup dynamically in the WODetailHandler.js.

    In order to do so, I have to modify the filterAssetForLookup() function.  (In case you were wondering, yes, I made an extension of my js class.)

    I would like to filter the asset this way:
    select * from asset where location in (select location from locations where description like '%TEST123');

    Would it be possible to :

    1.Filter the additionnallocations resource to get only the locations that the descriptions starts with my value?
    2.Filter the additionnalasset resource to get all asset with location in the additionallocations resrouce previously filtered?

    I found the function .setWhereClause() available in the resources but can't really figure out how this works.

    Thank you for your help.



    ------------------------------
    Mathieu Guilmette
    ------------------------------