I have a Smartobject that I want to get rid of. Before doing so, I want to find out what other objects(workflow, forms, views) are using it? How can i do it?
Thanks
Solved
How to find where a SMO is being used?
+10Best answer by Vernon
NOTE: Direct db manipulation is not suported, dont delete directly from the db. Use the UIs.
In my tests on K2 Five and 4.7 P&D does show the worfklow unfer the SmartObjects "Used by" tab
You can use the PROCid from the server.proc tables ProcSetID to look up the process name in the server.procset. Note that its not clear to me what you mean with you have a prodID.
Select * from [Server].[Procset]
where [ID] in (Select [ProcSetID] from [Server].[Proc] where [ID] = <PROCID>)
HTH
Vernon
+14IMO the easiest way is if you have P&D MMC access. Create a new package selecting the SmartObject you want to delete. This will pull in all the references. If you then click on the SmartObject in the P&D app on the right there should be a used by tab, this should be the objects that have a dependency on that SmartObject.
HTH
Vernon
+10I tried creating a package in P&D but it didn't show me the Workflow that it's used in. I am almost sure that I have used that SMO in a workflow.
I was able to guess ProcID for my test instance (based on the date I created workflow). Is there a table I can query using ProcID to find the workflow name?
Thanks
+14NOTE: Direct db manipulation is not suported, dont delete directly from the db. Use the UIs.
In my tests on K2 Five and 4.7 P&D does show the worfklow unfer the SmartObjects "Used by" tab
You can use the PROCid from the server.proc tables ProcSetID to look up the process name in the server.procset. Note that its not clear to me what you mean with you have a prodID.
Select * from [Server].[Procset]
where [ID] in (Select [ProcSetID] from [Server].[Proc] where [ID] = <PROCID>)
HTH
Vernon
+10Thanks this query gave me the workflow name. That's what I needed. I wrote ProcID not ProDID.
Thanks for reminding about direct DB updates.
Assuming you have a backup, you can delete or rename a property of the SmartObject and publish. All the forms, views and flows using it should have a designer error. Make a list of them and put the SmartObject back. Kludgy but I am sure it works.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.