- Go to Database Configuration. Fetch the WOCHANGESTATUS object. If you previously haven't done so for some other reason, you'll need to create a relationship to the WORKORDER table. Caveat: WOCHANGESTATUS does not have the SiteID or OrgID fields. I simply made the relationship to be defined upon wonum = :wonum --- this might be problematic in a multisite/multiorg environment, which is not my situation. In the example code below, I named this relationship pcc_workorder
- Go to Conditional Expression Manager. You'll end up creating 2 similar Expressions, one that you'll apply to WOCHANGESTATUS and another that you'll apply to WORKORDER. Sample code below -- here I am specifying what the current status must be, including a couple of custom statuses we added (with the purpose of excluding other custom statuses we use that otherwise would have been able to go to INPRG per the out-of-the-box design; and then making it so only the Work Order's Lead or Supervisor can change the status:
/*This is the code I would use on the WORKORDER object*/
:status in ('NEW', 'CNTRCTSIGN', 'WPCOND', 'APPR', 'WMATL', 'PAUSED') and (:&PERSONID& = :lead or :&PERSONID& = :supervisor )
/*This is the code I would use on the WOCHANGESTATUS object*/
:wostatus in ('NEW', 'CNTRCTSIGN', 'WPCOND', 'APPR', 'WMATL', 'PAUSED') and (:&PERSONID& = :pcc_workorder.lead or :&PERSONID& = :pcc_workorder.supervisor)
- Go to Domains. Fetch the WOSTATUS Domain. Continuing on from the previous step, we'll apply those conditions to the INPRG status. Find the row in the Domain where Value = INPRG. Then at the bottom of the dialog box, click View/Modify Conditions. Add a row, choose the Condition that you made for use with WORKORDER, and then put WORKORDER as the Object Name. Make a second row, this time choosing the other Condition and use WOCHANGESTATUS for the Object Name.
Pretty sure that's it. Well, except that I made my Conditions much more complex, and made custom Conditions for all the possible statuses. But the point is here, you can create restrictions that wouldn't allow the Technicians to Approve the Work Order -- either prevent them completely (that's what I do) or perhaps allow them to Approve it under some condition (e.g. it's been scheduled but not approved). You'd just have to define what your business process needs to look like.
But if you don't even want your users to see what hasn't been approved for them yet, then you should be using Security Groups --> Data Restrictions --> Object Restrictions instead.
------------------------------
Travis Herron
Pensacola Christian College
------------------------------
Original Message:
Sent: 04-15-2025 08:49
From: Amy Tellier-Briggs
Subject: Can you restrict WO visibility based on status?
Sounds like a good solution, Travis. The problem on our end is they know how to search for other stuff, and often WILL. It's interesting how they complain that they don't have enough time in their day to put their time and notes on a work order in Maximo, and yet seem to have lots of time to search for work that hasn't been assigned to them yet. ;)
How do you apply conditional expressions on the WOSTATUS and WOCHANGESTATUS objects?
Thanks,
Amy
------------------------------
Amy Briggs
Maintenance Planner
The Jackson Laboratory
Bar Harbor, ME
207-288-6356
Original Message:
Sent: 04-14-2025 09:47
From: Travis Herron
Subject: Can you restrict WO visibility based on status?
I achieve similar results with a combination of methods:
- Conditional expressions on the WOSTATUS and WOCHANGESTATUS objects that would only allow certain people (not Technicians) to Approve the Work Order.
- Setting Technicians up with a default query on the mobile app they use, so it only shows them Work Orders assigned to them that have been Approved.
The end result is, yes, they could "see" the Work Order that hasn't been approved yet, but they'd have to work for it. And even if they found it, they can't do anything with it.
I prefer this approach (read-only access to all Work Orders but edit access only if it is assigned to them and approved) so that, at least in theory, a Technician could observe some problem while out in the field and could see if a Work Order already exists for it.
------------------------------
Travis Herron
Pensacola Christian College
Original Message:
Sent: 04-11-2025 12:14
From: Amy Tellier-Briggs
Subject: Can you restrict WO visibility based on status?
Folks - We are having an issue with techs grabbing work orders that have not yet been approved to them or scheduled out and completing them outside their assigned work. I know, it sounds like it would be a good "problem" to have, but when new, "easier" jobs are being done almost immediately and there are 165 other WO's in the craft's backlog that existed WAY before this new request came in, it's an issue.
I'm wondering if there's a permissions setting in the Security Groups application that would allow us to restrict a technician from finding a Work Order that's in any other status except 'APPR', for example?
Thanks in advance,
Amy Briggs
The Jackson Laboratory
Bar Harbor, ME
#EverythingMaximo
#MaximoUserGroups
#WorkManagement
------------------------------
Amy Briggs
Maintenance Planner
The Jackson Laboratory
Bar Harbor, ME
207-288-6356
------------------------------