find a way to identify what business process is connected to a specific code so it can be deleted.

While trying to clean up our code tables and deleting old out dated codes we got this error message: "This solicit code cannot be deleted because it is associated with a business process.".  It would be great if there was a way to identify the business process associated with that code - either via a front end query (or tool) or a back end sql script.

  • James Adams
  • Sep 7 2017
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) Boston Children's Hospital Trust
Reported Version 4.0
  • Attach files
  • Martin Porcas commented
    December 19, 2023 16:06

    Please can this be expanded to all code tables.

    The delete process can identify that it is in use, surely it can then tell us the name of the business process, query, export definition, etc. that is using it. Even if it only does this on the first error it meets, that's better than nothing. We'd have to manually amend where it's in use anyway.

    Alternatively, a button to search all instances and display them in a new form would be very useful.