Another interesting idea is to execute sql code during the transition and if it returns zero, than transition will be done by Spira. Otherwise workflow transition should show the end user a string that sql returns (or a specific form similar to current custom reports) to help him understand why transition between statuses wasnt performed. Use-case: I want to allow some transition only for a rather complex condition: if this field has next value, than check that another value is filled, check that user, who executes the transition is from specific department and etc. It looks like it wont be too difficult to implement it, but benefits could be siginificant as it will give Spira, Jiras validation on transition. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/2459.aspxthreadId=2459Ilia Poliakov (ilya.polyakov@edetek.com)workflow transitions validation sql Another interesting idea is to execute sql code during the transition and if it returns zero, than transition will be done by Spira. Otherwise workflow transition should show the end user a string that sql returns (or a specific form similar to current custom reports) to help him understand why transition between statuses wasnt performed. Use-case: I want to allow some transition only for a rather complex condition: if this field has next value, than check that another value is filled, check that user, who executes the transition is from specific department and etc. It looks like it wont be too difficult to implement it, but benefits could be siginificant as it will give Spira, Jiras validation on transition. Thu, 05 Aug 2021 14:21:22 -04002022-01-19T08:07:26-05:00/Support/Forum/spirateam/issues-questions/2459.aspxmessageId=4056David J (adam.sandman+support@inflectra.com) We are looking at something similar, but not exactly the same. The idea is to allow you to have changes in workflow fire webhook notifications. They could then call JavaScript plugins that call API functions to perform certain business actions. So it wouldnt be SQL based, but would accomplish the same thing. Thu, 05 Aug 2021 20:54:06 -04002021-08-05T20:54:06-04:00/Support/Forum/spirateam/issues-questions/2459.aspx#reply4056messageId=4236Ilia Poliakov (ilya.polyakov@edetek.com) Amazing perspecive! Are there any news when it is going to be implemented? Wed, 19 Jan 2022 08:07:26 -05002022-01-19T08:07:26-05:00/Support/Forum/spirateam/issues-questions/2459.aspx#reply4236