Created On:  14 Decemeber 2011

Problem:

Is it possible to query the StarTeam database to identify the type of views used in a project?

Resolution:

To get the View Types query the Flags property in the ST_VIEWS table.

The following SQL statement will return the ViewID, Name and Type of view being used.

SELECT id, name, flags 
FROM 
  st_views

The codes below define the view type in use:
 
View Types

VIEW_REFERENCE = 0x00000001,  
VIEW_ROOT = 0x00000002,
VIEW_BRANCH  = 0x00000004
VIEW_BLANK = 0x00000008, 

Initial branching

VIEW_BRANCHALL  = 0x00010000
VIEW_BRANCHNONE = 0x00020000

Other flags

VIEW_READONLY = 0x10000000