While creating Features, Web Parts, Web Service calls or Site Templates or even basic DataViews at many places you required to have some short of reference chart mostly to write CAML related stuff. So after having my few hours I created this handy reference sheet useful at many places. You can use this sheet at many places like "BaseType" values (just below) are always useful as part of SPSiteDataQuery : <Lists BaseType='0′ MaxListLimit='0′/> or similar goes for "Server Template" <Lists ServerTemplate='303′ MaxListLimit='0′/> Another handy example is "FieldType" again which is useful in CAML queries. <FieldRef Name='MyLookupField'/><Value Type='Lookup'> Endless possibilities. Be patient to load this huge page (And sincere apology for SMALL fonts, hard to fit in screen) Don't forget to comment back If I am missing something that should be here too . Type Name Value Summary SPBaseType GenericList 0 Generic type of list template used for most lists. or DocumentLibrary 1 Document library. BaseType Unused 2 Unused. DiscussionBoard 3 Discussion board. Survey 4 Survey list. Issue 5 Issue-tracking list. UnspecifiedBaseType -1 SPListCategoryType None 0 Libraries 1 Communications 2 Tracking 3 CustomLists 4 SPListTemplateType GenericList 100 Custom list. or DocumentLibrary 101 Document library. Survey 102 Survey. Links 103 Links. Announcements 104 Announcements. Contacts 105 Contacts. Events 106 Calendar. Tasks 107 Tasks. DiscussionBoard 108 Discussion board. PictureLibrary 109 Picture library. DataSources 110 Data sources for a site. WebTemplateCatalog 111 Site template gallery. UserInformation 112 User Information. WebPartCatalog 113 Web Part gallery. ListTemplateCatalog 114 List template gallery. XMLForm 115 XML Form library. MasterPageCatalog 116 Master Page gallery. NoCodeWorkflows 117 No Code Workflows. WorkflowProcess 118 Custom Workflow Process. WebPageLibrary 119 Wiki Page Library. CustomGrid 120 Custom grid for a list. DataConnectionLibrary 130 WorkflowHistory 140 Workflow History. GanttTasks 150 Project Tasks. Meetings 200 Meeting Series (Meeting). Agenda 201 Agenda (Meeting). MeetingUser 202 Attendees (Meeting). Decision 204 Decisions (Meeting). MeetingObjective 207 Objectives (Meeting). TextBox 210 Text Box (Meeting). ThingsToBring 211 Things To Bring (Meeting). HomePageLibrary 212 Workspace Pages (Meeting). Posts 301 Posts (Blog). Comments 302 Comments (Blog). Categories 303 Categories (Blog). IssueTracking 1100 Issue tracking. AdminTasks 1200 Administrator Tasks. InvalidType -1 Not used. SPFieldType Invalid 0 Not used. or Integer 1 Contains positive or negative integer values. Value Type Text 2 Contains a single line of text. Note 3 Specifies a field that can contain multiple lines of text. DateTime 4 Contains date and time values. Counter 5 Contains an integer used for internal ID fields. Choice 6 Specifies a predetermined set of values that can be used to enter data into the field. Lookup 7 Contains references to values in other lists. Boolean 8 Contains Boolean values that are stored in the database as 1 or 0. Number 9 Contains floating point numbers. Currency 10 Contains currency values formatted based on a specific locale. URL 11 Contains hyperlinks. Computed 12 Specifies an abstract field type that depends on other fields for its content and definition. Threading 13 Specifies a field that is used in the creation and display of threaded Web discussions. Guid 14 Contains GUIDs. MultiChoice 15 Contains multiple values per list item. GridChoice 16 Specifies a Choice field for a data sheet. Calculated 17 Contains calculated values. File 18 Contains files. Attachments 19 Contains attachments. User 20 Specifies users of a SharePoint site. Recurrence 21 Specifies a field used in calendars for recurring events and, like computed fields, an abstract field type that depends on other fields for its content and definition. CrossProjectLink 22 Specifies a link between projects in a Meetings Workspace site. ModStat 23 Specifies Content Approval status. Error 24 Contains errors. ContentTypeId 25 PageSeparator 26 ThreadIndex 27 WorkflowStatus 28 AllDayEvent 29 WorkflowEventType 30 MaxItems 31 Contains the maximum number of items. SPListEventType Insert 0 A new document is saved to the library. Update 1 A document in the library is edited. Delete 2 A document in the library is deleted. Move 3 A document is moved or renamed in the library. Copy 4 A document is copied within the document library. If a document is copied to a location outside the document library, a Delete event occurs. CheckIn 5 A document is checked into the library. CheckOut 6 A document is checked out from the library. UncheckOut 7 The check-out of a document is undone. Invalid -1 Unused. DefaultItemOpen PreferClient 0 Open the item in a client application. Browser 1 Use the browser to open the item. DraftVisibilityType Reader 0 Reader. Value = 0. Author 1 Author. Value = 1. Approver 2 Approver. Value = 2. OfficialFileResult Success 0 MoreInformation 1 InvalidConfiguration 2 NotFound 3 FileRejected 4 FileCheckedOut 5 UnknownError 6 PAGETYPE PAGE_DEFAULTVIEW 0 Default view. Value=0. PAGE_NORMALVIEW 1 Normal view. Value=1. PAGE_DIALOGVIEW 2 File dialog box view. Value=2. PAGE_VIEW 3 View, including both default view and normal view. Value=3. PAGE_DISPLAYFORM 4 Display form for list items. Value=4. PAGE_DISPLAYFORMDIALOG 5 Display form for a file dialog box. Value=5. PAGE_EDITFORM 6 Edit form for list items. Value=6. PAGE_EDITFORMDIALOG 7 Edit form for a file dialog box. Value=7. PAGE_NEWFORM 8 New form for list items. Value=8. PAGE_NEWFORMDIALOG 9 New form for a file dialog box. Value=9. PAGE_SOLUTIONFORM 10 Solution form. Value=10. PAGE_MAXITEMS 11 Not used. Value=11. PAGE_INVALID -1 Not used. Value= -1. RequestResources None 0 UserInfoList 1 WebProperties 2 Features 4 NavigationStructure 8 SPAddFieldOptions Default 0 AddToDefaultContentType 1 AddToNoContentType 2 AddToAllContentTypes 4 AddFieldInternalNameHint 8 AddFieldToDefaultView 16 AddFieldCheckDisplayName 32 SPAlertFrequency Immediate 0 Send immediately when the list or list item changes. Daily 1 Send daily. Weekly 2 Send weekly. SPAlertStatus On 0 The alert is implemented. Off 1 The alert is not implemented. Error 2 The alert is not functional. SPAlertType List 0 Applies to a list. Item 1 Applies to a list item. Custom 2 Applies to a custom object. SPBasePermissions EmptyMask 0 Has no permissions on the Web site. Not available through the user interface. ViewListItems 1 View items in lists, documents in document libraries, and view Web discussion comments. AddListItems 2 Add items to lists, add documents to document libraries, and add Web discussion comments. EditListItems 4 Edit items in lists, edit documents in document libraries, edit Web discussion comments in documents, and customize Web Part Pages in document libraries. DeleteListItems 8 Delete items from a list, documents from a document library, and Web discussion comments in documents. ApproveItems 16 Approve a minor version of a list item or document. OpenItems 32 View the source of documents with server-side file handlers. ViewVersions 64 View past versions of a list item or document. DeleteVersions 128 Delete past versions of a list item or document. CancelCheckout 256 Discard or check in a document which is checked out to another user. ManagePersonalViews 512 Create, change, and delete personal views of lists. ManageLists 2048 Create and delete lists, add or remove columns in a list, and add or remove public views of a list. ViewFormPages 4096 View forms, views, and application pages. Enumerate lists. Open 65536 Allows users to open a Web site, list, or folder in order to access items inside that container. ViewPages 131072 View pages in a Web site. AddAndCustomizePages 262144 Add, change, or delete HTML pages or Web Part Pages, and edit the Web site using a Windows SharePoint Services-compatible editor. ApplyThemeAndBorder 524288 Apply a theme or borders to the entire Web site. ApplyStyleSheets 1048576 Apply a style sheet (.CSS file) to the Web site. ViewUsageData 2097152 View reports on Web site usage. CreateSSCSite 4194304 Create a Web site using Self-Service Site Creation. ManageSubwebs 8388608 Create subsites such as team sites, Meeting Workspace sites, and Document Workspace sites. Activate, deactivate, or edit properties of site collection-scoped Features. NoteÿÿÿThrough the user interface, to browse to the Site Collection Features page and activate or deactivate site collection-scoped Features, you must be the site collection administrator. CreateGroups 16777216 Create a group of users that can be used anywhere within the site collection. ManagePermissions 33554432 Create and change permission levels on the Web site and assign permissions to users and groups. BrowseDirectories 67108864 Enumerate files and folders in a Web site using Microsoft SharePoint Designer and Web DAV interfaces. BrowseUserInfo 134217728 View information about users of the Web site. AddDelPrivateWebParts 268435456 Add or remove personal Web Parts on a Web Part Page. UpdatePersonalWebParts 536870912 Update Web Parts to display personalized information. ManageWeb 1073741824 Grants the ability to perform all administration tasks for the Web site as well as manage content. UseClientIntegration 0 UseRemoteAPIs 0 Use SOAP, Web DAV, or Microsoft SharePoint Designer interfaces to access the Web site. ManageAlerts 0 Manage alerts for all users of the Web site. CreateAlerts 0 Create e-mail alerts. EditMyUserInfo 0 Allows a user to change his or her own user information, such as adding a picture. EnumeratePermissions 0 Enumerate permissions on the Web site, list, folder, document, or list item. FullMask -1 Has all permissions on the Web site. Not available through the user interface. SPCalendarOrderType MDY 0 Month-Day-Year DMY 1 Day-Month-Year YMD 2 Year-Month-Day SPCalendarType None 0 No type specified. Value=0. Gregorian 1 Gregorian. Value=1. Japan 3 Japanese Emperor Era. Value=3. Taiwan 4 Taiwan Era. Value=4. Korea 5 Korean Tangun Era. Value=5. Hijri 6 Hijri (Arabic lunar). Value=6. Thai 7 Thai. Value=7. Hebrew 8 Hebrew (lunar). Value=8. GregorianMEFrench 9 Gregorian Middle East French. Value=9. GregorianArabic 10 Gregorian Arabic. Value=10. GregorianXLITEnglish 11 Gregorian transliterated English. Value=11. GregorianXLITFrench 12 Gregorian transliterated French. Value=12. KoreaJapanLunar 14 Korean and Japanese lunar. Value=14. ChineseLunar 15 Chinese lunar. Value=15. SakaEra 16 Saka Era. Value=16. SPCheckinType MinorCheckIn 0 Incremented as a minor version. Value=0. MajorCheckIn 1 Incremented as a major version. Value=1. OverwriteCheckIn 2 Overwrite the file. Value=2. SPChoiceFormatType Dropdown 0 Drop-down list box. RadioButtons 1 Option buttons. SPEventReceiverType ItemAdding 1 An item is being added. ItemUpdating 2 An item is being updated. ItemDeleting 3 An item is being deleted. ItemCheckingIn 4 An item is being checked in. ItemCheckingOut 5 An item is being checked out. ItemUncheckingOut 6 An item is being unchecked out. ItemAttachmentAdding 7 An attachment is being added to the item. ItemAttachmentDeleting 8 An attachment is being removed from the item. ItemFileMoving 9 A file is being moved. FieldAdding 101 A field is being added. FieldUpdating 102 A field is being updated. FieldDeleting 103 A field is being removed. SiteDeleting 201 A site collection is being deleted. WebDeleting 202 A site is being deleted. WebMoving 203 A site is being moved. ItemAdded 10001 An item was added. ItemUpdated 10002 An item was updated. ItemDeleted 10003 An item was deleted. ItemCheckedIn 10004 An item was checked in. ItemCheckedOut 10005 An item was checked out. ItemUncheckedOut 10006 An item was unchecked out. ItemAttachmentAdded 10007 An attachment was added to the item. ItemAttachmentDeleted 10008 An attachment was removed from the item. ItemFileMoved 10009 A file was moved. ItemFileConverted 10010 A file was converted. FieldAdded 10101 A field was added. FieldUpdated 10102 A field was updated. FieldDeleted 10103 A field was removed. SiteDeleted 10201 A site collection was deleted. WebDeleted 10202 A site was deleted. WebMoved 10203 A site was moved. EmailReceived 20000 The list received an e-mail message. ContextEvent 32766 The list received a context event. InvalidReceiver -1 Invalid. SPEventType Add 1 Additions to the list or list item. Modify 2 All changes made in a list or list item. Delete 4 Deletion of a list or list item. Discussion 4080 Changes in Web discussions. All -1 All events pertaining to the list or list item. SPFeatureScope Farm 0 Specifies server farm. WebApplication 1 Specifies Web application. Site 2 Specifies site collection. Web 3 Specifies Web site. ScopeInvalid -1 Specifies that the scope is not valid. SPFieldType Invalid 0 Not used. Integer 1 Contains positive or negative integer values. Text 2 Contains a single line of text. Note 3 Specifies a field that can contain multiple lines of text. DateTime 4 Contains date and time values. Counter 5 Contains an integer used for internal ID fields. Choice 6 Specifies a predetermined set of values that can be used to enter data into the field. Lookup 7 Contains references to values in other lists. Boolean 8 Contains Boolean values that are stored in the database as 1 or 0. Number 9 Contains floating point numbers. Currency 10 Contains currency values formatted based on a specific locale. URL 11 Contains hyperlinks. Computed 12 Specifies an abstract field type that depends on other fields for its content and definition. Threading 13 Specifies a field that is used in the creation and display of threaded Web discussions. Guid 14 Contains GUIDs. MultiChoice 15 Contains multiple values per list item. GridChoice 16 Specifies a Choice field for a data sheet. Calculated 17 Contains calculated values. File 18 Contains files. Attachments 19 Contains attachments. User 20 Specifies users of a SharePoint site. Recurrence 21 Specifies a field used in calendars for recurring events and, like computed fields, an abstract field type that depends on other fields for its content and definition. CrossProjectLink 22 Specifies a link between projects in a Meetings Workspace site. ModStat 23 Specifies Content Approval status. Error 24 Contains errors. ContentTypeId 25 PageSeparator 26 ThreadIndex 27 WorkflowStatus 28 AllDayEvent 29 WorkflowEventType 30 MaxItems 31 Contains the maximum number of items. SPListEventType Insert 0 A new document is saved to the library. Update 1 A document in the library is edited. Delete 2 A document in the library is deleted. Move 3 A document is moved or renamed in the library. Copy 4 A document is copied within the document library. If a document is copied to a location outside the document library, a Delete event occurs. CheckIn 5 A document is checked into the library. CheckOut 6 A document is checked out from the library. UncheckOut 7 The check-out of a document is undone. Invalid -1 Unused. SPRights EmptyMask 0 Value: 0×00000000. Has no permissions on the Web site. Not available through the user interface. Groups: N/A. ViewListItems 1 Value: 0×00000001. View items in lists, documents in document libraries, view Web discussion comments, and set up e-mail alerts for lists. Groups: Reader, Contributor, Web Designer, Administrator. AddListItems 2 Value: 0×00000002. Add items to lists, add documents to document libraries, and add Web discussion comments. Groups: Contributor, Web Designer, Administrator. EditListItems 4 Value: 0×00000004. Edit items in lists, edit documents in document libraries, edit Web discussion comments in documents, and customize Web Part Pages in document libraries. Groups: Contributor, Web Designer, Administrator. DeleteListItems 8 Value: 0×00000008. Delete items from a list, documents from a document library, and Web discussion comments in documents. Groups: Contributor, Web Designer, Administrator. CancelCheckout 256 Value: 0×00000100. Check in a document without saving the current changes. Groups: Web Designer, Administrator. ManagePersonalViews 512 Value: 0×00000200. Create, change, and delete personal views of lists. Groups: Contributor, Web Designer, Administrator. ManageListPermissions 1024 Value: 0×00000400. Grant, deny, or change user permissions to a list. Groups: Administrator. ManageLists 2048 Value: 0×00000800. Approve content in lists, add or remove columns in a list, and add or remove public views of a list. Groups: Web Designer, Administrator. OpenWeb 65536 Value: 0×00010000. Open the SharePoint Web site and get metadata related to the site, as well as see the underlying navigation structure (not exposed in the user interface). Groups: Guest, Reader, Contributor, Web Designer, Administrator. ViewPages 131072 Value: 0×00020000. View pages in a Web site. Groups: Reader, Contributor, Web Designer, Administrator. AddAndCustomizePages 262144 Value: 0×00040000. Add, change, or delete ASPX pages, HTML pages, or Web Part Pages, and edit the Web site using a Windows SharePoint Services-compatible editor. Groups: Web Designer, Administrator. ApplyThemeAndBorder 524288 Value: 0×00080000. Apply a theme or borders to the entire Web site. Groups: Web Designer, Administrator. ApplyStyleSheets 1048576 Value: 0×00100000. Apply a style sheet (.CSS file) to the Web site. Groups: Web Designer, Administrator. ViewUsageData 2097152 Value: 0×00200000. View reports on Web site usage. Groups: Administrator. CreateSSCSite 4194304 Value: 0×00400000. Create a Web site using Self-Service Site Creation. Groups: Reader, Contributor, Web Designer, Administrator. ManageSubwebs 8388608 Value: 0×00800000. Manage or create subsites. Groups: Administrator. CreatePersonalGroups 16777216 Value: 0×01000000. Create, change, and delete site groups, including adding users to the site groups and specifying which rights are assigned to a site group. Groups: Contributor, Web Designer, Administrator. ManageRoles 33554432 Value: 0×02000000. Create, change, and delete site groups, including adding users to the site groups and specifying which rights are assigned to a site group. Groups: Administrator. BrowseDirectories 67108864 Value: 0×04000000. Browse directories in a Web site. Groups: Contributor, Web Designer, Administrator. BrowseUserInfo 134217728 Value: 0×08000000. View information about users. This right is not available through the user interface. Guest, Reader, Contributor, Web Designer, Administrator. AddDelPrivateWebParts 268435456 Value: 0×10000000. Add or remove Web Parts on a personalized Web Part Page. Groups: Contributor, Web Designer, Administrator. UpdatePersonalWebParts 536870912 Value: 0×20000000. Update Web Parts to display personalized information. Groups: Contributor, Web Designer, Administrator. ManageWeb 1073741824 Value: 0×40000000. Manage a site, including the ability to perform all administration tasks for the site and manage contents and permissions. Groups: Administrator. FullMask -1 Value: -1. Has all permissions on the Web site. Not available through the user interface. Groups: N/A. SPRoleType None 0 Has no rights on the Web site. Guest 1 Has limited rights to view pages and specific page elements. This site group is used for giving users access to a particular page, list, or item in a list, without granting them rights to view the entire site. Users cannot be explicitly added to the Guest site group, rather users who are given access to lists or document libraries by way of per-list permissions are automatically added to the Guest site group. The Guest site group cannot be customized or deleted. Reader 2 Has rights to view items, personalize Web parts, use alerts, and create their own top-level Web site using Self-Service Site Creation. Readers can only read a site; they cannot add content. Note that when a reader creates a site using Self-Service Site Creation, he or she becomes the site owner and a member of the Administrator site group for the new site. This does not affect the users site group membership for any other site. Rights included: CreateSSCSite, ViewListItems, ViewPages. Contributor 3 Has Reader rights, plus rights to add, edit, and delete items, manage list permissions, manage personal views, personalize Web Part Pages, and browse directories. Contributors cannot create new lists or document libraries, but they can add content to existing lists and document libraries. All rights included in the Reader site group, plus the following: AddDelPrivateWebParts, AddListItems, BrowseDirectories, CreatePersonalGroups, DeleteListItems, EditListItems, ManagePersonalViews, UpdatePersonalWebParts. WebDesigner 4 Has Contributor rights, plus rights to cancel checkout, delete items, manage lists, add and customize pages, define and apply themes and borders, and link style sheets. Web Designers can modify the structure of the site and create new lists or document libraries. All rights included in the Contributor site group, plus the following: AddAndCustomizePages, ApplyStyleSheets, ApplyThemeAndBorder, CancelCheckout, ManageLists. Administrator 5 Has all rights from other site groups, plus rights to manage site groups and view usage analysis data. The Administrator site group cannot be customized or deleted, and there must always be at least one member of the Administrator site group. Members of the Administrator site group always have access to, or can grant themselves access to, any item in the Web site. All rights included in the WebDesigner site group, plus the following: ManageListPermissions, ManageRoles, ManageSubwebs, ViewUsageData. MeetingListTemplateType MeetingEvents 200 Specifies the template for the list that displays the meeting events. MeetingEvents 200 Specifies the template for the list that displays the meeting events. MeetingAgenda 201 Specifies the template for the list that displays the agenda of the meeting. MeetingAttendees 202 Specifies the template for the list that displays the attendees of the meeting. MeetingDecisions 204 Specifies the template for the list that displays the meeting decisions. MeetingObjectives 207 Specifies the template for the list that displays the meeting objectives. MeetingTextbox 210 Specifies the template for the list that displays the meeting text box. MeetingThingsToBring 211 Specifies the template for the list that displays the things to bring for the meeting. MeetingEnd 212 Specifies the template for the list that displays the meeting end date. MeetingEnd 212 Specifies the template for the list that displays the meeting end date. MeetingMax 299 Specifies the template for the list that displays the meeting results. SPDateFormat DateTime 0 Both the date and the time are included. DateOnly 1 Only the date is included. TimeOnly 2 Only the time is included. ISO8601 3 ISO8601 time format converted to coordinated universal time (UTC) in the format YYYY-MM-DDTHH:MM:SSZ. MonthDayOnly 4 SPDataSourceMode List 0 ListOfLists 1 CrossList 2 Webs 3 ListItem 4 ViewType None 0 View is undefined. Grid 1 Display as a client ActiveX control. Html 2 Display as a server HTML view. Chart 3 Display as a graphical summary. Calendar 4 Gantt 5 SPWorkflowState None 0 Locked 1 Running 2 Completed 4 Cancelled 8 Expiring 16 Expired 32 Faulting 64 Terminated 128 Suspended 256 Orphaned 512 HasNewEvents 1024 NotStarted 2048 All 4095 SPWorkflowStatus NotStarted 0 FailedOnStart 1 InProgress 2 ErrorOccurred 3 StoppedByUser 4 Completed 5 FailedOnStartRetrying 6 ErrorOccurredRetrying 7 ViewQueryOverflow 8 Max 15 Published 1 Published. Value=1. Draft 2 Draft stage. Value=2. Checkout 255 Checked out. Value=255. GLOBAL#0 Global template (1033) STS#0 Team Site (1033) STS#1 Blank Site (1033) STS#2 Document Workspace (1033) MPS#0 Basic Meeting Workspace (1033) MPS#1 Blank Meeting Workspace (1033) MPS#2 Decision Meeting Workspace (1033) MPS#3 Social Meeting Workspace (1033) MPS#4 Multipage Meeting Workspace (1033) CENTRALADMIN#0 Central Admin Site (1033) WIKI#0 Wiki Site (1033) BLOG#0 Blog (1033) BDR#0 Document Center (1033) OFFILE#0 Records Center (1033) OFFILE#1 Records Center (1033) OSRV#0 Shared Services Administration Site (1033) SPS#0 SharePoint Portal Server Site (1033) SPSPERS#0 SharePoint Portal Server Personal Space (1033) SPSMSITE#0 Personalization Site (1033) SPSTOC#0 Contents area Template (1033) SPSTOPIC#0 Topic area template (1033) SPSNEWS#0 News Site (1033) CMSPUBLISHING#0 Publishing Site (1033) BLANKINTERNET#0 Publishing Site (1033) BLANKINTERNET#1 Press Releases Site (1033) BLANKINTERNET#2 Publishing Site with Workflow (1033) SPSNHOME#0 News Site (1033) SPSSITES#0 Site Directory (1033) SPSCOMMU#0 Community area template (1033) SPSREPORTCENTER#0 Report Center (1033) SPSPORTAL#0 Collaboration Portal (1033) SRCHCEN#0 Search Center with Tabs (1033) PROFILES#0 Profiles (1033) BLANKINTERNETCONTAINER#0 Publishing Portal (1033) SPSMSITEHOST#0 My Site Host (1033) SRCHCENTERLITE#0 Search Center (1033) SRCHCENTERLITE#1 Search Center (1033) SPSBWEB#0 SharePoint Portal Server BucketWeb Template (1033)
ServerTemplate
SPFileLevel
Template Name
Wednesday, February 17, 2010
SharePoint Reference Sheet
Posted by Rami Reddy Annapu Reddy at 4:03 AM 0 comments
Subscribe to:
Posts (Atom)