Extending to what Craig said above, and if you want to check for current jobplan, you need to extend Craig's condition and add additional where clause - "and ownerid=:jobplanid". I am assuming jobplanid is used as ownerid in wfassignment table.
Original Message:
Sent: Tue March 26, 2024 12:10 PM
From: Souvik Dutta
Subject: How to restrict Job Plan Status Change for Workflow
Hi Craig,
Could you please help me to know how I can fetch the current jobplan dynamic way to use in the conditional expression manager
I have tried using like this but it is giving error
jpnum = :&jpnum&
------------------------------
Souvik Dutta
Original Message:
Sent: Mon February 19, 2024 05:24 PM
From: souvik dutta
Subject: How to restrict Job Plan Status Change for Workflow
Hi Craig,
Thanks.
After replying on yesterday I checked one blog and found this can be done by the creating condition in conditional manager and attaching the query with sig option. So I tried it by creating a query and with my query I am restricting on specific status. But I will try with your approach also and will update you on this.
------------------------------
souvik dutta
Original Message:
Sent: Mon February 19, 2024 01:09 AM
From: Craig Kokay
Subject: How to restrict Job Plan Status Change for Workflow
So, let's step back. What you're actually after (in my words) is the Change Status menu option in the Common Actions menu.
- You need to create a Conditional Expression that checks if the person is in the WFASSIGNMENT table for the current Job Plan with an active assignment. Along the lines of this conditional expression (sample - concept only).
- Open the Security group application.
- Select the Applications tab.
- Find the Job Plan application
- Ensure you have grants READ and SAVE (you may have to save before the next step is available).
- Select the Change Statis option.
- Enter the Conditional Expression name into the Condition field.
- Save.
- Exit
- Try it out
------------------------------
Regards, Craig Kokay
Principle Consultant, COSOL
https://cosol.global/
Ph: +61-411-682-040
email: craig.kokay@cosol.global
#IBMChampion
Original Message:
Sent: Mon February 19, 2024 12:11 AM
From: Juris Flugins
Subject: How to restrict Job Plan Status Change for Workflow
If I understtod correctly, then jobplan creates so called acctivities under workorder, and uses the same status what workorder is using. So, that is wostatus domain. It should be then possible to set condtions for each status value. Condition needs to be writed with some if else statement, to filter cases for workorder it self and activity.
https://bportaluri.com/2018/08/restrict-allowed-status-changes.html
------------------------------
Juris Flugins
Original Message:
Sent: Sun February 18, 2024 08:41 PM
From: souvik dutta
Subject: How to restrict Job Plan Status Change for Workflow
Hi Craig,
Thanks for the reply.
My requirement is to show or give the status change option for the Job Plan record only to those persons who are currently assigned to the Job Plan workflow.
Could you please let me know if this solution will meet this purpose.
Thanks,
Souvik
------------------------------
souvik dutta
Original Message:
Sent: Sun February 18, 2024 05:09 PM
From: Craig Kokay
Subject: How to restrict Job Plan Status Change for Workflow
You can control the ability to use/not use the status change when the record is in Workflow. There are three actions:
The easiest concept is to set the NOSTATUS to stop people changing the status and revoke the ability to change the status. Workflow will be able to override this and make a change providing that whenever further down the flow you want the status to change you need to issue:
- OKSTATUS
- The intended status change.
- NOSTATUS -- unless this is the last status to be changed to like for Job Plan it could be ACTIVE. Why ACTIVE? With JP revisioning, it is read-only and you can only revise the JP.
I'd advise never to issue a PVSTATUS. You cannot come back from this.
------------------------------
Regards, Craig Kokay
Principal Consultant, COSOL
https://cosol.global/
Ph: +61-411-682-040
email: craig.kokay@cosol.global
#IBMChampion
Original Message:
Sent: Fri February 16, 2024 03:24 PM
From: souvik dutta
Subject: How to restrict Job Plan Status Change for Workflow
I want to allow the Job Plan record status change option either visible or allowable only to those people who are currently assigned in the Job Plan Workflow.
How to achieve this.
------------------------------
souvik dutta
------------------------------