Share via

modGetPermissionsJoinColumn

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns the name of the column that is used to identify uniquely the rows in a table for row-level permissions. Exists in the workflow-enabled database.

 [@TableName =] 'name', 
[@IndexColName =] 'index' output

Parameters

  • [@TableName =] 'name'
    Name of the table.
  • [@IndexColName =] 'index'
    Output parameter that holds the name of the column that joins the table with the permissions table.

Remarks

The column should be of type int or numeric. The procedure looks first for a single-column primary key and then for an identity column.

Example

The following example looks for the join column for the Category table. The value returned in @JoinColumn is CategoryID:

EXEC modGetPermissionsJoinColumn 'Category', @JoinColumn

See Also

Stored Procedures | Workflow Application Infrastructure | ModSystem Database Tables | Workflow-Enabled Database Tables | Views