Maximo

Maximo

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

 View Only

  • 1.  Default WOTRACK query for all users?

    Posted Tue May 04, 2021 02:19 PM
    Edited by System Admin Wed March 22, 2023 11:47 AM
    MAM 7.6.1.2:

    I have a saved WOTRACK query that filters WOs where they match the person's division (division is a custom field):

    ((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0 and siteid = 'SERVICES')
    and division in (select division from person where personid = '1234'  )

    As MAXADMIN, is there a way for me to make that query be the default WOTRACK query for all Maximo users?

    Thanks.


    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Default WOTRACK query for all users?

    Posted Wed May 05, 2021 02:34 AM

    Hi,

    Isn't the solution to use something like this all our start centers are based on this type of query.
    One query fits all users

    (workorder.status IN ('APPR', 'EXEC', 'EXECINPRG', 'WPCOND', 'INPRG', 'INTRPT', 'WMATL', 'TECHCOMP') AND workorder.historyflag = 0 AND workorder.istask = 0 AND workorder.siteid = (SELECT a.defsite FROM maxuser a WHERE a.userid = :user) AND (EXISTS (SELECT 1 FROM assignment b WHERE b.laborcode = :user AND EXISTS (SELECT 1 FROM workorder c WHERE ((c.istask = 1 AND c.parent = workorder.wonum) OR (c.istask = 0 AND c.wonum = workorder.wonum)) AND b.wonum = c.wonum AND c.siteid = workorder.siteid) AND b.siteid = workorder.siteid)))



    ------------------------------
    Agron Basha
    ------------------------------

    Original Message


  • 3.  RE: Default WOTRACK query for all users?

    Posted Wed May 05, 2021 07:54 AM
    If you want, you could hardcode this into the app in Application Designer as a where clause which would apply when a user does NOT have a default query defined. Select the "presentation..." in the top left corner in Application Designer and provide it in the where clause and it will function as the default filter for users (that they will be able to adjust). This would function as a default for everyone while allowing them to change it (including having their own default query if they prefer). 

    The other option if you want to make it actually a user's default query automatically is to add the records to the DEFAULTQUERY table via some background process (probably a script). When someone marks a query as a default, it gets loaded into this table. You can only have 1 for a given user so you would have to write logic to ensure the user doesn't have an existing record for the app and then insert it into this table. Then as they navigate to this app this query will apply by default.

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

    Original Message


  • 4.  RE: Default WOTRACK query for all users?

    Posted Wed May 05, 2021 11:02 AM
    Thanks! I think the Presentation Properties option will work.

    For anyone else who's interested:

    Setting a Default Filter Where Clause for a Maximo Application


    Original Message


Related Content