Maximo

Expand all | Collapse all

Default WOTRACK query for all users?

  • 1.  Default WOTRACK query for all users?

    Posted 2 days ago
    Edited by User1971 6 hours ago
    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.



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

    Posted yesterday

    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
    ------------------------------



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

    Posted yesterday
    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
    ------------------------------



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

    Posted yesterday
    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