The BaseType parameter and ListTemplate parameter in the template type of the SharePoint list

Knowing the correspondence between the numbers of BaseType and ListTemplate and their meanings can help us make database queries more convenient.

For example:

View the Links List in all web applications.

select * from AllListswhere tp_ServerTemplate = 103

 

You can also directly load the list type you want to view in IE address Bar.

For example:

Http://yoursite.com/_layouts/viewlsts.aspx-you can view all lists, grouped by type.

Http://yoursite.com/_layouts/viewlsts.aspx? BaseType = 1-view all document libraries.

Http://yoursite.com/_layouts/viewlsts.aspx? BaseType = 0 & ListTemplate = 108-view all discussion groups

 

BaseType

• 0 -- GenericList

• 1 -- DocumentLibrary

• 3 -- DiscussionBoard

• 4 -- Survey

• 5-Issue

ListTemplate

• 100 Generic list 100 Generic list
• 101 Document library
• 102 Survey
• 103 Links list
• 104 Announcements list
• 105 Contacts list
• 106 Events list
• 107 Tasks list
• 108 Discussion board
• 109 Picture library
• 110 Data sources
• 111 Site template gallery
• 113 Web Part gallery
• 114 List template gallery
• 115 XML Form library
• 120 Custom grid for a list
• 200 Meeting Series list
• 201 Meeting Agenda list
• 202 Meeting Attendees list
• 204 Meeting Decisions list
• 207 Meeting Objectives list
• 210 Meeting text box
• 211 Meeting Things To Bring list
• 212 Meeting Workspace Pages list
• 300 Portal Sites list.
• 1100 Issue tracking
• 2002 Personal document library
• 2003 Private document library
• 101 Document library
• 102 Survey
• 103 Links list
• 104 Announcements list
• 105 Contacts list
• 106 Events list
• 107 Tasks list
• 108 Discussion board
• 109 Picture library
• 110 Data sources
• 111 Site template gallery
• 113 Web Part gallery
• 114 List template gallery
• 115 XML Form library
• 120 Custom grid for a list
• 200 Meeting Series list
• 201 Meeting Agenda list
• 202 Meeting Attendees list
• 204 Meeting Decisions list
• 207 Meeting Objectives list
• 210 Meeting text box
• 211 Meeting Things To Bring list
• 212 Meeting Workspace Pages list
• 300 Portal Sites list.
• 1100 Issue tracking
• 2002 Personal document library
• 2003 Private document library

 

Source:

ListTemplate Element

Http://msdn.microsoft.com/en-us/library/dd586520%28office.11%29.aspx

ListTemplate Element (List Template)

Http://msdn.microsoft.com/en-us/library/ms462947.aspx

SharePoint Gems: Quick Launch List Items

Http://www.techelixir.com/Lists/SharePoint%20Gems/DispForm.aspx? ID = 5