Home Search

DriveWorks Pro 21
SpGetTransitionsAndOperations

Send Feedback

SpGetTransitionsAndOperations

Will return a table of all transitions and operations on the active or given specification's current state.

Syntax

SpGetTransitionsAndOperations(Specification Id)

Where:

Specification Id (optional) is the Id of the specification to return the transitions and operations from. If left blank the current specification will be used.

Example

RuleResultMeaning
SpGetTransitionsAndOperations(){"Name","Title","Type","State Name","Target State Name","Is Available","All Teams","Team Names","Owner","Creator"; "Finish","Finish","Transition","Specify","Pending",True,True,"Administrators|Sales|Ops",True,True; "ReleaseLocal","Release","Transition","Specify","Completed",True,True,"Administrators|Ops",True,True; "ReleaseAutopilot","Release","Transition","Specify","Released To Server",True,True,"Administrators|Ops",True,True; "Save","Save","Transition","Specify","Saved",True,True,"Administrators|Sales|Ops",True,True}This will return a table showing the Transitions and Operations for the current specification.
SpGetTransitionsAndOperations("1"){"Name","Title","Type","State Name","Target State Name","Is Available","All Teams","Team Names","Owner","Creator"; "Edit","Edit","Transition","Completed","Specify",False,False,"",True,False; "Copy","Copy","Operation","Completed","",True,False,"",True,False; "Delete","Delete","Operation","Completed","",True,False,"",True,False; "Archive","Archive","Operation","Completed","",True,False,"",True,False}This will return a table showing the Transitions and Operations of the specification with the Id of 1.

Column Headers

The columns returned in the table and their meanings are listed below:

  • Name - The name of the Transition or Operation in the given specification.
  • Title - The title of the Transition or Operation in the given specification.
  • Type - Transition or Operation.
  • State Name - The name of the current State of the specification.
  • Target State Name - The name of the target state when the Transition or Operation is activated.
  • Is Available - True if the Transition or Operation is available, False if not.
  • All Teams - True if All is checked in the Specification Flow Security.
  • Team Names - A pipe delimited list will be returned of the teams that have permission to the Transition or Operation.

    The Team Names displayed are the Teams that have access to the Transition or Operation.

    In some circumstances this could differ from the Teams that have been set on the Transition or Operation itself.

    This is because subsequent Transitions could elevate a Team's permission to the Transition or Operation.

  • Owner - True if the Owner of the specification, as defined in the Specification Flow Security, has permission to the Transition or Operation.
  • Creator - True if the Creator of the specification, as defined in the Specification Flow Security, has permission to the Transition or Operation.

For more information on States and Specification Flow see Specification Flow

Table Result

The result from the function as displayed in a table (such as a Data Table).

Example 1:

NameTitleTypeState NameTarget State NameIs AvailableAll TeamsTeam NamesOwnerCreator
FinishFinishTransitionSpecifyPendingTrueTrueAdministrators|Sales|OpsTrueTrue
ReleaseLocalReleaseTransitionSpecifyCompletedTrueTrueAdministrators|OpsTrueTrue
ReleaseAutopilotReleaseTransitionSpecifyReleased To ServerTrueTrueAdministrators|OpsTrueTrue
SaveSaveTransitionSpecifySavedTrueTrueAdministrators|Sales|OpsTrueTrue

Example 2:

NameTitleTypeState NameTarget State NameIs AvailableAll TeamsTeam NamesOwnerCreator
EditEditTransitionCompletedSpecifyFalseFalseTrueFalse
CopyCopyOperationCompletedTrueFalseTrueFalse
DeleteDeleteOperationCompletedTrueFalseTrueFalse
ArchiveArchiveOperationCompletedTrueFalseTrueFalse