{"id":910,"date":"2012-03-13T19:12:06","date_gmt":"2012-03-13T19:12:06","guid":{"rendered":"http:\/\/www.stuartroberts.net\/?p=910"},"modified":"2012-03-13T19:40:53","modified_gmt":"2012-03-13T19:40:53","slug":"quick-tip-6","status":"publish","type":"post","link":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/","title":{"rendered":"Get List Items by Field Value"},"content":{"rendered":"<p><strong>SharePoint Short #6<\/strong><br \/>\nTo retrieve all <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/microsoft.sharepoint.splistitem.aspx\" title=\"SPListItem\" target=\"_blank\">SPListItem<\/a> objects that have a specified field value, instead of writing a CAML query, use the following LINQ statement:<\/p>\n<pre lang=\"csharp\">\r\npublic List<SPListItem>  GetItemsContainingValue(SPList list, Guid fieldId, string match)\r\n{\r\n    List<SPListItem> matchingItems =\r\n        (from SPListItem listItem in list.Items\r\n         where\r\n             listItem.Fields.Contains(fieldId) &&\r\n             listItem[fieldId] != null &&\r\n             listItem[fieldId].ToString().Equals(match, StringComparison.InvariantCultureIgnoreCase)\r\n         select listItem).ToList<SPListItem>();\r\n\r\n    return matchingItems;\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SharePoint Short #6 To retrieve all SPListItem objects that have a specified field value, instead of writing a CAML query, use the following LINQ statement: public List GetItemsContainingValue(SPList list, Guid fieldId, string match) { List matchingItems = (from SPListItem listItem &hellip; <a href=\"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[44],"tags":[81,45],"class_list":["post-910","post","type-post","status-publish","format-standard","hentry","category-shorts","tag-sharepoint","tag-sharepoint-short"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"Get List Items by Field Value using LINQ quick tip\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Stu\"\/>\n\t<meta name=\"keywords\" content=\"sharepoint,sps,sp,tip,tips,quick tip,quick tips,splistitem,tolist,linq,shorts\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_GB\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Stuart Roberts on all things SharePoint |\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint\" \/>\n\t\t<meta property=\"og:description\" content=\"Get List Items by Field Value using LINQ quick tip\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2012-03-13T19:12:06+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2012-03-13T19:40:53+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@SharePointStu\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Get List Items by Field Value using LINQ quick tip\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@SharePointStu\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#article\",\"name\":\"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint\",\"headline\":\"Get List Items by Field Value\",\"author\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/503cb376bab10c66a6bde71d1514dcab2eab4ec44a2f82ef597ca87af61bf1cd?s=96&d=retro&r=g\",\"width\":96,\"height\":96,\"caption\":\"Stu\"},\"datePublished\":\"2012-03-13T19:12:06+00:00\",\"dateModified\":\"2012-03-13T19:40:53+00:00\",\"inLanguage\":\"en-GB\",\"commentCount\":2,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#webpage\"},\"articleSection\":\"Shorts, SharePoint, SharePoint Short\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.stuartroberts.net\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/category\\\/shorts\\\/#listItem\",\"name\":\"Shorts\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/category\\\/shorts\\\/#listItem\",\"position\":2,\"name\":\"Shorts\",\"item\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/category\\\/shorts\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#listItem\",\"name\":\"Get List Items by Field Value\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#listItem\",\"position\":3,\"name\":\"Get List Items by Field Value\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/category\\\/shorts\\\/#listItem\",\"name\":\"Shorts\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/#person\",\"name\":\"Stu\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/503cb376bab10c66a6bde71d1514dcab2eab4ec44a2f82ef597ca87af61bf1cd?s=96&d=retro&r=g\",\"width\":96,\"height\":96,\"caption\":\"Stu\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/author\\\/admin\\\/#author\",\"url\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/author\\\/admin\\\/\",\"name\":\"Stu\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/503cb376bab10c66a6bde71d1514dcab2eab4ec44a2f82ef597ca87af61bf1cd?s=96&d=retro&r=g\",\"width\":96,\"height\":96,\"caption\":\"Stu\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#webpage\",\"url\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/\",\"name\":\"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint\",\"description\":\"Get List Items by Field Value using LINQ quick tip\",\"inLanguage\":\"en-GB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/2012\\\/03\\\/13\\\/quick-tip-6\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/index.php\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2012-03-13T19:12:06+00:00\",\"dateModified\":\"2012-03-13T19:40:53+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/#website\",\"url\":\"https:\\\/\\\/www.stuartroberts.net\\\/\",\"name\":\"Stuart Roberts on all things SharePoint\",\"inLanguage\":\"en-GB\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.stuartroberts.net\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint","description":"Get List Items by Field Value using LINQ quick tip","canonical_url":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/","robots":"max-image-preview:large","keywords":"sharepoint,sps,sp,tip,tips,quick tip,quick tips,splistitem,tolist,linq,shorts","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#article","name":"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint","headline":"Get List Items by Field Value","author":{"@id":"https:\/\/www.stuartroberts.net\/index.php\/author\/admin\/#author"},"publisher":{"@id":"https:\/\/www.stuartroberts.net\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/503cb376bab10c66a6bde71d1514dcab2eab4ec44a2f82ef597ca87af61bf1cd?s=96&d=retro&r=g","width":96,"height":96,"caption":"Stu"},"datePublished":"2012-03-13T19:12:06+00:00","dateModified":"2012-03-13T19:40:53+00:00","inLanguage":"en-GB","commentCount":2,"mainEntityOfPage":{"@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#webpage"},"isPartOf":{"@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#webpage"},"articleSection":"Shorts, SharePoint, SharePoint Short"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.stuartroberts.net\/#listItem","position":1,"name":"Home","item":"https:\/\/www.stuartroberts.net\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.stuartroberts.net\/index.php\/category\/shorts\/#listItem","name":"Shorts"}},{"@type":"ListItem","@id":"https:\/\/www.stuartroberts.net\/index.php\/category\/shorts\/#listItem","position":2,"name":"Shorts","item":"https:\/\/www.stuartroberts.net\/index.php\/category\/shorts\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#listItem","name":"Get List Items by Field Value"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.stuartroberts.net\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#listItem","position":3,"name":"Get List Items by Field Value","previousItem":{"@type":"ListItem","@id":"https:\/\/www.stuartroberts.net\/index.php\/category\/shorts\/#listItem","name":"Shorts"}}]},{"@type":"Person","@id":"https:\/\/www.stuartroberts.net\/#person","name":"Stu","image":{"@type":"ImageObject","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/503cb376bab10c66a6bde71d1514dcab2eab4ec44a2f82ef597ca87af61bf1cd?s=96&d=retro&r=g","width":96,"height":96,"caption":"Stu"}},{"@type":"Person","@id":"https:\/\/www.stuartroberts.net\/index.php\/author\/admin\/#author","url":"https:\/\/www.stuartroberts.net\/index.php\/author\/admin\/","name":"Stu","image":{"@type":"ImageObject","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/503cb376bab10c66a6bde71d1514dcab2eab4ec44a2f82ef597ca87af61bf1cd?s=96&d=retro&r=g","width":96,"height":96,"caption":"Stu"}},{"@type":"WebPage","@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#webpage","url":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/","name":"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint","description":"Get List Items by Field Value using LINQ quick tip","inLanguage":"en-GB","isPartOf":{"@id":"https:\/\/www.stuartroberts.net\/#website"},"breadcrumb":{"@id":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/#breadcrumblist"},"author":{"@id":"https:\/\/www.stuartroberts.net\/index.php\/author\/admin\/#author"},"creator":{"@id":"https:\/\/www.stuartroberts.net\/index.php\/author\/admin\/#author"},"datePublished":"2012-03-13T19:12:06+00:00","dateModified":"2012-03-13T19:40:53+00:00"},{"@type":"WebSite","@id":"https:\/\/www.stuartroberts.net\/#website","url":"https:\/\/www.stuartroberts.net\/","name":"Stuart Roberts on all things SharePoint","inLanguage":"en-GB","publisher":{"@id":"https:\/\/www.stuartroberts.net\/#person"}}]},"og:locale":"en_GB","og:site_name":"Stuart Roberts on all things SharePoint |","og:type":"article","og:title":"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint","og:description":"Get List Items by Field Value using LINQ quick tip","og:url":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/","article:published_time":"2012-03-13T19:12:06+00:00","article:modified_time":"2012-03-13T19:40:53+00:00","twitter:card":"summary","twitter:site":"@SharePointStu","twitter:title":"Quick Tip #6 - Get List Items by Field Value | Stuart Roberts on all things SharePoint","twitter:description":"Get List Items by Field Value using LINQ quick tip","twitter:creator":"@SharePointStu"},"aioseo_meta_data":{"post_id":"910","title":"Quick Tip #6 - Get List Items by Field Value | #site_title","description":"Get List Items by Field Value using LINQ quick tip","keywords":[{"label":"SharePoint","value":"SharePoint"},{"label":"SPS","value":"SPS"},{"label":"SP","value":"SP"},{"label":"tip","value":"tip"},{"label":"tips","value":"tips"},{"label":"quick tip","value":"quick tip"},{"label":"quick tips","value":"quick tips"},{"label":"SPListItem","value":"SPListItem"},{"label":"ToList","value":"ToList"},{"label":"LINQ","value":"LINQ"}],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-08-03 13:50:55","updated":"2026-10-16 15:53:09","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.stuartroberts.net\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.stuartroberts.net\/index.php\/category\/shorts\/\" title=\"Shorts\">Shorts<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tGet List Items by Field Value\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.stuartroberts.net\/"},{"label":"Shorts","link":"https:\/\/www.stuartroberts.net\/index.php\/category\/shorts\/"},{"label":"Get List Items by Field Value","link":"https:\/\/www.stuartroberts.net\/index.php\/2012\/03\/13\/quick-tip-6\/"}],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/posts\/910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/comments?post=910"}],"version-history":[{"count":7,"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/posts\/910\/revisions"}],"predecessor-version":[{"id":936,"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/posts\/910\/revisions\/936"}],"wp:attachment":[{"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/media?parent=910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/categories?post=910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stuartroberts.net\/index.php\/wp-json\/wp\/v2\/tags?post=910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}