{"id":40480,"date":"2022-07-25T16:54:28","date_gmt":"2021-09-28T15:16:30","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=40480"},"modified":"2022-07-25T16:54:28","modified_gmt":"2022-07-25T16:54:28","slug":"error-value-does-not-exist-or-does-not-match-filter-criteria","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/","title":{"rendered":"Error: Value does not exist or does not match filter criteria"},"content":{"rendered":"\n

When\/Why does it show up?<\/h2>\n\n\n\n

The Salesforce default error message for an invalid filter lookup data is “Value does not exist or does not match filter criteria”. When you attempt to save a record but the lookup field does not meet the filter criteria, you will receive this error. This can happen whether you create\/update the record manually, or by using the Salesforce API.<\/p>\n\n\n\n

Here is an example: Your custom Lookup Filter field to an Account has a filter that requires the Account to be of a specific record type: Patient. Now attempt to create\/edit a record while the account listed in your lookup field has a different record type, not Patient. This will cause the error to display.<\/p>\n\n\n\n

\"Filter<\/a><\/figure><\/div>\n\n\n\n
\n\n\n\n

How to solve this error:<\/h2>\n\n\n\n

Because the error does not list the field, just the object, the first thing you need to do is to identify which field generates the error.<\/p>\n\n\n\n

In Salesforce \u2192 Object Manager<\/b>, view the fields of the Object that returned the error and identify all the fields with Lookup type<\/b>. Check which one has a filter and review that filter.<\/p>\n\n\n\n

Afterward, the next step is easy:<\/p>\n\n\n\n

1. Delete the filter if it\u2019s not needed anymore, OR:<\/p>\n\n\n\n

2. Make sure that what you map in that specific field respects the filter criteria. If you are using a lookup result, the filter condition should be a part of the lookup condition too (e.g. Type = Patient).<\/p>\n","protected":false},"excerpt":{"rendered":"

When\/Why does it show up? The Salesforce default error message for an invalid filter lookup data is “Value does not exist or does not match filter criteria”. When you attempt to save a record but the lookup field does not meet the filter criteria, you will receive this error. This can happen whether you create\/update […]<\/p>\n","protected":false},"author":13,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[134],"tags":[],"class_list":["post-40480","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-123formbuilder-appexchange"],"yoast_head":"\nValues does not exist or does not match filter criteria<\/title>\n<meta name=\"description\" content=\"This error is triggered each time you try to save a record when the lookup field does not meet the filter criteria. Here's how to fix it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error: Value does not exist or does not match filter criteria\" \/>\n<meta property=\"og:description\" content=\"This error is triggered each time you try to save a record when the lookup field does not meet the filter criteria. Here's how to fix it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-28T15:16:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-25T16:54:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/LookupFilter.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Values does not exist or does not match filter criteria","description":"This error is triggered each time you try to save a record when the lookup field does not meet the filter criteria. Here's how to fix it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/","og_locale":"en_US","og_type":"article","og_title":"Error: Value does not exist or does not match filter criteria","og_description":"This error is triggered each time you try to save a record when the lookup field does not meet the filter criteria. Here's how to fix it.","og_url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2021-09-28T15:16:30+00:00","article_modified_time":"2022-07-25T16:54:28+00:00","og_image":[{"url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/LookupFilter.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#article","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/"},"author":{"name":"admin","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"headline":"Error: Value does not exist or does not match filter criteria","datePublished":"2021-09-28T15:16:30+00:00","dateModified":"2022-07-25T16:54:28+00:00","mainEntityOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/"},"wordCount":249,"commentCount":0,"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/LookupFilter.png","articleSection":["AppExchange"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/","name":"Values does not exist or does not match filter criteria","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#primaryimage"},"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/LookupFilter.png","datePublished":"2021-09-28T15:16:30+00:00","dateModified":"2022-07-25T16:54:28+00:00","author":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"description":"This error is triggered each time you try to save a record when the lookup field does not meet the filter criteria. Here's how to fix it.","breadcrumb":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#primaryimage","url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/LookupFilter.png","contentUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/LookupFilter.png"},{"@type":"BreadcrumbList","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-value-does-not-exist-or-does-not-match-filter-criteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/"},{"@type":"ListItem","position":2,"name":"Error: Value does not exist or does not match filter criteria"}]},{"@type":"WebSite","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/","name":"123FormBuilder Knowledge Base","description":"Search our documentation platform for answers, service specifications and 3rd-party integrations.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","caption":"admin"},"url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/40480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/comments?post=40480"}],"version-history":[{"count":9,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/40480\/revisions"}],"predecessor-version":[{"id":42244,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/40480\/revisions\/42244"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/media?parent=40480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/categories?post=40480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/tags?post=40480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}