Mitel YSE

[HAPE67]

I'm using Yoursite Explorer from Mitel. I want to delete a subroutine I'm not using anymore.
I get an error that another entity is still referring to this one, but without information which other entity this is.
Is there a way to find out what other entity is referring to the one I'm trying to delete?

 

[TJWW]

You should be able to step through the Workflows to locate where the subroutine is referenced. That's the only way I know. Anyone else have a better way?

 

[Billz66]

you can try and locate the other subroutine / workflow using some sql queries
replace ZZZZ-Delete with subroutine name

USE CCMData
Select Name from tblConfig_VWM_Callflow
Where pkey in (
Select FKCallflow from tblConfig_VWM_CallflowSubroutineMembers
Where FKSubroutine in (Select pkey from tblConfig_VWM_Subroutine
where Name = 'ZZZZ-Delete'))



Use CCMData
Select Name from tblConfig_VWM_Subroutine
where pkey in (
Select FKParent from tblConfig_VWM_SubroutineHierarchy
Where FKSubroutine in ( Select pkey from tblConfig_VWM_Subroutine
Where tblConfig_VWM_Subroutine.Name = 'ZZZZ-Delete'))


and another method thats similar

Search the Subroutine name in tblConfig_VWM_Subroutine

SELECT * FROM [CCMData].[dbo].[tblConfig_VWM_Subroutine]
Where Name = 'simple email sql query'

Then you can search the Subroutines PKey in the tblConfig_VWM_Callflow table
SELECT * FROM [CCMData].[dbo].[tblConfig_VWM_CallflowSubroutineMembers]
Where FKSubroutine = 'E36AB025-783D-456A-9BBC-EBC3EA7874A7'

This will return all callflows/Workflows that reference this sub.

Then take the FKCallflow values and search in the tblConfig_VWM_Callflow table

SELECT *
FROM [CCMData].[dbo].[tblConfig_VWM_Callflow]
Where Pkey = '082FA6DF-984E-4E1E-8069-FC19913591CB'

This will display ALL Callflow Names where the subroutine is referenced.