query on how to limit the records in Business rules.

[snow57]

Hi,

I have a scenario like below:

for one CI we have to create only one active change request, if the change request is cancelled or closed then we can create a change for the CI. After creating the first change we have to stop the creation of change. how to achieve this scenario using Business rules ?

Thanks

[Ankur Bawiskar]

@snow57 

from where are you creating the Change?  Is it from UI action?

If yes then you can have condition in UI action

If not then you can use before insert BR on CHG table and see if there is any other CHG which is open for this CI; if yes then abort the insertion

If my response helped please mark it correct and close the thread so that it benefits future readers.