Orchestrator Database Question

Help
1

For the input parameters in the orchestrator, we need to be able to find the Current version being used and in the PackageVersions table in the orchestrator database there is no column that flags if a Package version is currently being used.

Example: One process has two package versions. Package version 1 has 1 argument input. Package version 2 has 3 argument inputs. We later find we want to Rollback to Package version 1, but if we pull the InputArguments from the PackageVersions table, we have no way to identify which Package version is active and therefore no way to get the Input Arguments.

What can we do here?

2

@jman0119 - 1. Whenever an user sets desired version as current from Orchestrator, a new row is inserted into ReleaseVersions table. So ideally this can be retrieved using CreationTime desc…