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
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· AI与.NET技术实操系列：向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列：如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· 震惊！C++程序真的从main开始吗？99%的程序员都答错了
· 【硬核科普】Trae如何「偷看」你的代码？零基础破解AI编程运行原理
· 单元测试从入门到精通
· 上周热点回顾（3.3-3.9）
· winform 绘制太阳，地球，月球 运作规律