SPQuery在引用field的时候要用internal name
来源:互联网 发布:淘宝网天天特价女鞋 编辑:程序博客网 时间:2024/06/05 17:43
SPQuery在引用field的时候要用internal name
使用SPQuery构建CAML查询的时候, 一定要用field的internal name, 否则就会报出如下的错误:
Exception caught Microsoft.SharePoint.SPException: One or more field types are not installed properly. Go to the list settings page to delete these fields. --->System.Runtime.InteropServices.COMException (0x81020014): One or more field types are not installed properly. Go to the list settings page to delete these fields.
这个错误给出的信息很具有迷惑性. 呵呵.
那么如何确定某个field的internal name呢?
1. 在界面上找到这个column. 可以从Site Content Type Gallery入手, 顺着content type找对应的column; 也可以从Site Columns里找到对应的column; 也可以从编辑List View的页面里找到Column.
2. 找到之后, 可以用鼠标悬停看状态栏的方式, 也可以选择右键单击column, 选属性, 查找field对应的internal的名字.
鼠标悬停法:
右键单击看属性法:
这里列出了所有的OOB的Field的显示名, 内部名, GUID, 和Type信息. 供快速参考:
Document Library fields
Display Name
Internal Name
GUID
Type
ID
ID
{1d22ea11-1e32-424e-89ab-9fedbadb6ce1}
Counter
Content Type ID
ContentTypeId
{03e45e84-1992-4d42-9116-26f756012634}
ContentTypeId
Content Type
ContentType
{c042a256-787d-4a6f-8a8a-cf6ab767f12d}
Text
Created
Created
{8c06beca-0777-48f7-91c7-6da68bc07b69}
DateTime
Created By
Author
{1df5e554-ec7e-46a6-901d-d85a3881cb18}
User
Modified
Modified
{28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f}
DateTime
Modified By
Editor
{d31655d1-1d5b-4511-95a1-7a09e9b75bf2}
User
Has Copy Destinations
_HasCopyDestinations
{26d0756c-986a-48a7-af35-bf18ab85ff4a}
Boolean
Copy Source
_CopySource
{6b4e226d-3d88-4a36-808d-a129bf52bccf}
Text
Approval Status
_ModerationStatus
{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}
ModStat
Approver Comments
_ModerationComments
{34ad21eb-75bd-4544-8c73-0e08330291fe}
Note
URL Path
FileRef
{94f89715-e097-4e8b-ba79-ea02aa8b7adb}
Lookup
Path
FileDirRef
{56605df6-8fa1-47e4-a04c-5b384d59609f}
Lookup
Modified
Last_x0020_Modified
{173f76c8-aebd-446a-9bc9-769a2bd2c18f}
Lookup
Created
Created_x0020_Date
{998b5cff-4a35-47a7-92f3-3914aa6aa4a2}
Lookup
File Size
File_x0020_Size
{8fca95c0-9b7d-456f-8dae-b41ee2728b85}
Lookup
Item Type
FSObjType
{30bb605f-5bae-48fe-b4e3-1f81d9772af9}
Lookup
Effective Permissions Mask
PermMask
{ba3c27ee-4791-4867-8821-ff99000bac98}
Computed
ID of the User who has the item Checked Out
CheckedOutUserId
{a7b731a3-1df1-4d74-a5c6-e2efba617ae2}
Lookup
Is Checked out to local
IsCheckedoutToLocal
{cfaabd0f-bdbd-4bc2-b375-1e779e2cad08}
Lookup
Checked Out To
CheckoutUser
{3881510a-4e4a-4ee8-b102-8ee8e2d0dd4b}
User
Name
FileLeafRef
{8553196d-ec8d-4564-9861-3dbe931050c8}
File
Unique Id
UniqueId
{4b7403de-8d94-43e8-9f0f-137a3e298126}
Lookup
ProgId
ProgId
{c5c4b81c-f1d9-4b43-a6a2-090df32ebb68}
Lookup
ScopeId
ScopeId
{dddd2420-b270-4735-93b5-92b713d0944d}
Lookup
Virus Status
VirusStatus
{4a389cb9-54dd-4287-a71a-90ff362028bc}
Lookup
Checked Out To
CheckedOutTitle
{9d4adc35-7cc8-498c-8424-ee5fd541e43a}
Lookup
Check In Comment
_CheckinComment
{58014f77-5463-437b-ab67-eec79532da67}
Lookup
Checked Out To
LinkCheckedOutTitle
{e2a15dfd-6ab8-4aec-91ab-02f6b64045b0}
Computed
Document Modified By
Modified_x0020_By
{822c78e3-1ea9-4943-b449-57863ad33ca9}
Text
Document Created By
Created_x0020_By
{4dd7e525-8d6b-4cb4-9d3e-44ee25f973eb}
Text
File Type
File_x0020_Type
{39360f11-34cf-4356-9945-25c44e68dade}
Text
HTML File Type
HTML_x0020_File_x0020_Type
{0c5e0085-eb30-494b-9cdd-ece1d3c649a2}
Text
Source Url
_SourceUrl
{c63a459d-54ba-4ab7-933a-dcf1c6fadec2}
Text
Shared File Index
_SharedFileIndex
{034998e9-bf1c-4288-bbbd-00eacfc64410}
Text
Edit Menu Table Start
_EditMenuTableStart
{3c6303be-e21f-4366-80d7-d6d0a3b22c7a}
Computed
Edit Menu Table End
_EditMenuTableEnd
{2ea78cef-1bf9-4019-960a-02c41636cb47}
Computed
Name
LinkFilenameNoMenu
{9d30f126-ba48-446b-b8f9-83745f322ebe}
Computed
Name
LinkFilename
{5cc6dc79-3710-4374-b433-61cb4a686c12}
Computed
Type
DocIcon
{081c6e4c-5c14-4f20-b23e-1a71ceb6a67c}
Computed
Server Relative URL
ServerUrl
{105f76ce-724a-4bba-aece-f81f2fce58f5}
Computed
Encoded Absolute URL
EncodedAbsUrl
{7177cfc7-f399-4d4d-905d-37dd51bc90bf}
Computed
Name
BaseName
{7615464b-559e-4302-b8e2-8f440b913101}
Computed
File Size
FileSizeDisplay
{78a07ba4-bda8-4357-9e0f-580d64487583}
Computed
Property Bag
MetaInfo
{687c7f94-686a-42d3-9b67-2782eac4b4f8}
Lookup
Level
_Level
{43bdd51b-3c5b-4e78-90a8-fb2087f71e70}
Integer
Is Current Version
_IsCurrentVersion
{c101c3e7-122d-4d4d-bc34-58e94a38c816}
Boolean
Select
SelectTitle
{b1f7969b-ea65-42e1-8b54-b588292635f2}
Computed
Select
SelectFilename
{5f47e085-2150-41dc-b661-442f3027f552}
Computed
Edit
Edit
{503f1caa-358e-4918-9094-4a2cdc4bc034}
Computed
owshiddenversion
owshiddenversion
{d4e44a66-ee3a-4d02-88c9-4ec5ff3f4cd5}
Integer
UI Version
_UIVersion
{7841bf41-43d0-4434-9f50-a673baef7631}
Integer
Version
_UIVersionString
{dce8262a-3ae9-45aa-aab4-83bd75fb738a}
Text
Instance ID
InstanceID
{50a54da4-1528-4e67-954a-e2d24f1e9efb}
Integer
Order
Order
{ca4addac-796f-4b23-b093-d2a3f65c0774}
Number
GUID
GUID
{ae069f25-3ac2-4256-b9c3-15dbc15da0e0}
Guid
Workflow Version
WorkflowVersion
{f1e020bc-ba26-443f-bf2f-b68715017bbc}
Integer
Workflow Instance ID
WorkflowInstanceID
{de8beacf-5505-47cd-80a6-aa44e7ffe2f4}
Guid
Source Version (Converted Document)
ParentVersionString
{bc1a8efb-0f4c-49f8-a38f-7fe22af3d3e0}
Lookup
Source Name (Converted Document)
ParentLeafName
{774eab3a-855f-4a34-99da-69dc21043bec}
Lookup
Title
Title
{fa564e0f-0c70-4ab9-b863-0177e6ddd247}
Text
Template Link
TemplateUrl
{4b1bf6c6-4f39-45ac-acd5-16fe7a214e5e}
Text
Html File Link
xd_ProgID
{cd1ecb9f-dd4e-4f29-ab9e-e9ff40048d64}
Text
Is Signed
xd_Signature
{fbf29b2d-cae5-49aa-8e0a-29955b540122}
Boolean
Merge
Combine
{e52012a0-51eb-4c0c-8dfb-9b8a0ebedcb6}
Computed
Relink
RepairDocument
{5d36727b-bcb2-47d2-a231-1f0bc63b7439}
Computed
Custom list fields
Display Name
Internal Name
GUID
Type
ID
ID
{1d22ea11-1e32-424e-89ab-9fedbadb6ce1}
Counter
Content Type ID
ContentTypeId
{03e45e84-1992-4d42-9116-26f756012634}
ContentTypeId
Content Type
ContentType
{c042a256-787d-4a6f-8a8a-cf6ab767f12d}
Text
Title
Title
{fa564e0f-0c70-4ab9-b863-0177e6ddd247}
Text
Modified
Modified
{28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f}
DateTime
Created
Created
{8c06beca-0777-48f7-91c7-6da68bc07b69}
DateTime
Created By
Author
{1df5e554-ec7e-46a6-901d-d85a3881cb18}
User
Modified By
Editor
{d31655d1-1d5b-4511-95a1-7a09e9b75bf2}
User
Has Copy Destinations
_HasCopyDestinations
{26d0756c-986a-48a7-af35-bf18ab85ff4a}
Boolean
Copy Source
_CopySource
{6b4e226d-3d88-4a36-808d-a129bf52bccf}
Text
owshiddenversion
owshiddenversion
{d4e44a66-ee3a-4d02-88c9-4ec5ff3f4cd5}
Integer
Workflow Version
WorkflowVersion
{f1e020bc-ba26-443f-bf2f-b68715017bbc}
Integer
UI Version
_UIVersion
{7841bf41-43d0-4434-9f50-a673baef7631}
Integer
Version
_UIVersionString
{dce8262a-3ae9-45aa-aab4-83bd75fb738a}
Text
Attachments
Attachments
{67df98f4-9dec-48ff-a553-29bece9c5bf4}
Attachments
Approval Status
_ModerationStatus
{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}
ModStat
Approver Comments
_ModerationComments
{34ad21eb-75bd-4544-8c73-0e08330291fe}
Note
Edit
Edit
{503f1caa-358e-4918-9094-4a2cdc4bc034}
Computed
Title
LinkTitleNoMenu
{bc91a437-52e7-49e1-8c4e-4698904b2b6d}
Computed
LinkFilenameNoMenu
Title
LinkTitle
{82642ec8-ef9b-478f-acf9-31f7d45fbc31}
Computed
Select
SelectTitle
{b1f7969b-ea65-42e1-8b54-b588292635f2}
Computed
Instance ID
InstanceID
{50a54da4-1528-4e67-954a-e2d24f1e9efb}
Integer
Order
Order
{ca4addac-796f-4b23-b093-d2a3f65c0774}
Number
GUID
GUID
{ae069f25-3ac2-4256-b9c3-15dbc15da0e0}
Guid
Workflow Instance ID
WorkflowInstanceID
{de8beacf-5505-47cd-80a6-aa44e7ffe2f4}
Guid
URL Path
FileRef
{94f89715-e097-4e8b-ba79-ea02aa8b7adb}
Lookup
Path
FileDirRef
{56605df6-8fa1-47e4-a04c-5b384d59609f}
Lookup
Modified
Last_x0020_Modified
{173f76c8-aebd-446a-9bc9-769a2bd2c18f}
Lookup
Created
Created_x0020_Date
{998b5cff-4a35-47a7-92f3-3914aa6aa4a2}
Lookup
Item Type
FSObjType
{30bb605f-5bae-48fe-b4e3-1f81d9772af9}
Lookup
Effective Permissions Mask
PermMask
{ba3c27ee-4791-4867-8821-ff99000bac98}
Computed
Name
FileLeafRef
{8553196d-ec8d-4564-9861-3dbe931050c8}
File
Unique Id
UniqueId
{4b7403de-8d94-43e8-9f0f-137a3e298126}
Lookup
ProgId
ProgId
{c5c4b81c-f1d9-4b43-a6a2-090df32ebb68}
Lookup
ScopeId
ScopeId
{dddd2420-b270-4735-93b5-92b713d0944d}
Lookup
File Type
File_x0020_Type
{39360f11-34cf-4356-9945-25c44e68dade}
Text
HTML File Type
HTML_x0020_File_x0020_Type
{4ef1b78f-fdba-48dc-b8ab-3fa06a0c9804}
Computed
Edit Menu Table Start
_EditMenuTableStart
{3c6303be-e21f-4366-80d7-d6d0a3b22c7a}
Computed
Edit Menu Table End
_EditMenuTableEnd
{2ea78cef-1bf9-4019-960a-02c41636cb47}
Computed
Name
LinkFilenameNoMenu
{9d30f126-ba48-446b-b8f9-83745f322ebe}
Computed
Name
LinkFilename
{5cc6dc79-3710-4374-b433-61cb4a686c12}
Computed
Type
DocIcon
{081c6e4c-5c14-4f20-b23e-1a71ceb6a67c}
Computed
Server Relative URL
ServerUrl
{105f76ce-724a-4bba-aece-f81f2fce58f5}
Computed
Encoded Absolute URL
EncodedAbsUrl
{7177cfc7-f399-4d4d-905d-37dd51bc90bf}
Computed
File Name
BaseName
{7615464b-559e-4302-b8e2-8f440b913101}
Computed
Property Bag
MetaInfo
{687c7f94-686a-42d3-9b67-2782eac4b4f8}
Lookup
Level
_Level
{43bdd51b-3c5b-4e78-90a8-fb2087f71e70}
Integer
Is Current Version
_IsCurrentVersion
{c101c3e7-122d-4d4d-bc34-58e94a38c816}
Boolean
资料来源:
Reminder: CAML requires internal names
http://www.thorprojects.com/blog/archive/2007/02/23/reminder-caml-requires-internal-names.aspx
Reference list for SharePoint internal field names
http://blogs.msdn.com/michael_yeager/archive/2008/11/03/reference-list-for-internal-field-names.aspx
Customizing the Content Query Web Part and Custom Item Styles
http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx
- SPQuery在引用field的时候要用internal name
- SPQuery在引用field的时候要用internal name
- 用SPQuery查询SPList的时候需要注意的几点
- SharePoint : 使用SPQuery对象时要注意的事项
- SharePoint : 使用SPQuery对象时要注意的事项
- SharePoint : 使用SPQuery对象时要注意的事项
- 在用eclipse开发bpel时,在引用外部服务的时候,出现的问题
- 读取内表的Field Name
- 读取内表的Field Name
- SharePoint internal Field Names
- PHP在上传文件的时候出现错误Internal Server Error
- 用堆空间初始化引用,在适当的时候释放堆空间
- 在AndroidStudio中引用jni的时候出错
- 在word写论文时候关于参考文献的引用
- 当你遇到internal的时候
- freemarker在用${user.name}时候 一定要在bean中有get方法 否则报错
- PowerDesigner怎样才能在修改表的字段Name的时候Code不自动跟着变
- PowerDesigner怎样才能在修改表的字段Name的时候Code不自动跟着变
- sql 优化之EXPLAIN PLAN
- android
- 发现很难做出任何快速的改变
- About The Platinum UPnP
- ORACLE基本查询
- SPQuery在引用field的时候要用internal name
- poj题目分类
- C#属性和字段的认识
- 测试驱动开发的经验教训
- 《大话数据结构》--学习笔记12 ***重点***
- Cscope在emacs中的配置与使用
- Linux make命令介绍
- [Linux]: ssh大致介绍
- 【转载】边缘检测算法的四个步骤