Custom Metadata SOQL WHERE clause not workingSemi join sub-selects are not allowed with the 'OR' operator“Where” clause which removes alphanumeric characters?Search by '.' causes non-selective query exceptionQuerying / Managing Queries with Multiple PermutationsRelationship query on Custom Metadata Type giving wrong resultsWhy are where clause comparison operators case-sensitive when using SOQL to query custom metadata?Unable to query with cross-Object pick-list field filter on Custom Metadata SOQLDash Characters in Case Sensitive Deterministic Encryption Not Returned in SOQLSOQL OFFSET is adding Id to the ORDER BY: Expected behavior?selectivity threshold + OR condition in where clause
On the consistency of different well-polished astronomy software
…down the primrose path
What is it exactly about flying a Flyboard across the English channel that made Zapata's thighs burn?
What license to choose for my PhD thesis?
Drawing arrowtips at the end of each segment in a polygonal path
How to design an effective polearm-bow hybrid?
Awk to get all my regular users in shadow
Why did the US Airways Flight 1549 passengers stay on the wings?
Why wasn't interlaced CRT scanning done back and forth?
Has J.J.Jameson ever found out that Peter Parker is Spider-Man?
Is the first page of a novel really that important?
What is the right Bonferroni adjustment?
Can I enter a rental property without giving notice if I'm afraid a tenant may be hurt?
GFCI tripping on overload?
Is there a command-line tool for converting html files to pdf?
Is there a booking app or site that lets you specify your gender for shared dormitories?
Is a switch from R to Python worth it?
Is there a way to say "double + any number" in German?
How does Rust's 128-bit integer `i128` work on a 64-bit system?
What is the reason behind water not falling from a bucket at the top of loop?
Plotting Autoregressive Functions / Linear Difference Equations
Getting an entry level IT position later in life
Is space radiation a risk for space film photography, and how is this prevented?
How do I show and not tell a backstory?
Custom Metadata SOQL WHERE clause not working
Semi join sub-selects are not allowed with the 'OR' operator“Where” clause which removes alphanumeric characters?Search by '.' causes non-selective query exceptionQuerying / Managing Queries with Multiple PermutationsRelationship query on Custom Metadata Type giving wrong resultsWhy are where clause comparison operators case-sensitive when using SOQL to query custom metadata?Unable to query with cross-Object pick-list field filter on Custom Metadata SOQLDash Characters in Case Sensitive Deterministic Encryption Not Returned in SOQLSOQL OFFSET is adding Id to the ORDER BY: Expected behavior?selectivity threshold + OR condition in where clause
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm getting some weird behavior with a SOQL WHERE clause on a Custom Metadata Type query:
SELECT Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
The resulting dataset has about the right number of records, but it doesn't contain all the records where Version__c is "2020", and it contains some records whose Version__c is something other than "2020".
Thoughts? Ideas?
soql custom-metadata
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
|
show 1 more comment
I'm getting some weird behavior with a SOQL WHERE clause on a Custom Metadata Type query:
SELECT Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
The resulting dataset has about the right number of records, but it doesn't contain all the records where Version__c is "2020", and it contains some records whose Version__c is something other than "2020".
Thoughts? Ideas?
soql custom-metadata
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
2
Is it picklist feild?
– Pranay Jaiswal
9 hours ago
Good question -- no. It's Text(20).
– Matthew Souther
9 hours ago
2
Is it sandbox, prod or scratch org?
– Pranay Jaiswal
9 hours ago
It's a sandbox.
– Matthew Souther
9 hours ago
1
Can you try same query in prod? I think I somewhat saw similar in sandbox but it worked in prod.
– Pranay Jaiswal
9 hours ago
|
show 1 more comment
I'm getting some weird behavior with a SOQL WHERE clause on a Custom Metadata Type query:
SELECT Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
The resulting dataset has about the right number of records, but it doesn't contain all the records where Version__c is "2020", and it contains some records whose Version__c is something other than "2020".
Thoughts? Ideas?
soql custom-metadata
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
I'm getting some weird behavior with a SOQL WHERE clause on a Custom Metadata Type query:
SELECT Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
The resulting dataset has about the right number of records, but it doesn't contain all the records where Version__c is "2020", and it contains some records whose Version__c is something other than "2020".
Thoughts? Ideas?
soql custom-metadata
soql custom-metadata
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
edited 8 hours ago
Matthew Souther
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
asked 9 hours ago
Matthew SoutherMatthew Souther
1209 bronze badges
1209 bronze badges
2
Is it picklist feild?
– Pranay Jaiswal
9 hours ago
Good question -- no. It's Text(20).
– Matthew Souther
9 hours ago
2
Is it sandbox, prod or scratch org?
– Pranay Jaiswal
9 hours ago
It's a sandbox.
– Matthew Souther
9 hours ago
1
Can you try same query in prod? I think I somewhat saw similar in sandbox but it worked in prod.
– Pranay Jaiswal
9 hours ago
|
show 1 more comment
2
Is it picklist feild?
– Pranay Jaiswal
9 hours ago
Good question -- no. It's Text(20).
– Matthew Souther
9 hours ago
2
Is it sandbox, prod or scratch org?
– Pranay Jaiswal
9 hours ago
It's a sandbox.
– Matthew Souther
9 hours ago
1
Can you try same query in prod? I think I somewhat saw similar in sandbox but it worked in prod.
– Pranay Jaiswal
9 hours ago
2
2
Is it picklist feild?
– Pranay Jaiswal
9 hours ago
Is it picklist feild?
– Pranay Jaiswal
9 hours ago
Good question -- no. It's Text(20).
– Matthew Souther
9 hours ago
Good question -- no. It's Text(20).
– Matthew Souther
9 hours ago
2
2
Is it sandbox, prod or scratch org?
– Pranay Jaiswal
9 hours ago
Is it sandbox, prod or scratch org?
– Pranay Jaiswal
9 hours ago
It's a sandbox.
– Matthew Souther
9 hours ago
It's a sandbox.
– Matthew Souther
9 hours ago
1
1
Can you try same query in prod? I think I somewhat saw similar in sandbox but it worked in prod.
– Pranay Jaiswal
9 hours ago
Can you try same query in prod? I think I somewhat saw similar in sandbox but it worked in prod.
– Pranay Jaiswal
9 hours ago
|
show 1 more comment
1 Answer
1
active
oldest
votes
Since there are more than 200 results, it could be a variation of this known issue.
Try executing it as a script instead of a query:
List<My_Text_Content__mdt> myTextContents = [Select Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
ORDER BY Version__c];
for(My_Text_Content__mdt myTextContent: myTextContents)
//Inspect results here
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
Thanks! Same result, though, per System.debug. :-( I actually saw that Known Issue in my original search, but ruled it out since the workaround looks the same as what I'm currently doing.
– Matthew Souther
8 hours ago
Upon further testing on other custom metadata types in our orgs, the issue seems to crop up when the expected result set is over 200 rows. So although the script approach is not providing the hoped-for solution (and the official Salesforce workaround is useless from my perspective), I do agree these could be related issues.
– Matthew Souther
8 hours ago
The SFDC workaround doesn't pass the straight-face test - they should fix this.
– cropredy
5 hours ago
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f272415%2fcustom-metadata-soql-where-clause-not-working%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Since there are more than 200 results, it could be a variation of this known issue.
Try executing it as a script instead of a query:
List<My_Text_Content__mdt> myTextContents = [Select Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
ORDER BY Version__c];
for(My_Text_Content__mdt myTextContent: myTextContents)
//Inspect results here
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
Thanks! Same result, though, per System.debug. :-( I actually saw that Known Issue in my original search, but ruled it out since the workaround looks the same as what I'm currently doing.
– Matthew Souther
8 hours ago
Upon further testing on other custom metadata types in our orgs, the issue seems to crop up when the expected result set is over 200 rows. So although the script approach is not providing the hoped-for solution (and the official Salesforce workaround is useless from my perspective), I do agree these could be related issues.
– Matthew Souther
8 hours ago
The SFDC workaround doesn't pass the straight-face test - they should fix this.
– cropredy
5 hours ago
add a comment |
Since there are more than 200 results, it could be a variation of this known issue.
Try executing it as a script instead of a query:
List<My_Text_Content__mdt> myTextContents = [Select Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
ORDER BY Version__c];
for(My_Text_Content__mdt myTextContent: myTextContents)
//Inspect results here
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
Thanks! Same result, though, per System.debug. :-( I actually saw that Known Issue in my original search, but ruled it out since the workaround looks the same as what I'm currently doing.
– Matthew Souther
8 hours ago
Upon further testing on other custom metadata types in our orgs, the issue seems to crop up when the expected result set is over 200 rows. So although the script approach is not providing the hoped-for solution (and the official Salesforce workaround is useless from my perspective), I do agree these could be related issues.
– Matthew Souther
8 hours ago
The SFDC workaround doesn't pass the straight-face test - they should fix this.
– cropredy
5 hours ago
add a comment |
Since there are more than 200 results, it could be a variation of this known issue.
Try executing it as a script instead of a query:
List<My_Text_Content__mdt> myTextContents = [Select Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
ORDER BY Version__c];
for(My_Text_Content__mdt myTextContent: myTextContents)
//Inspect results here
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
Since there are more than 200 results, it could be a variation of this known issue.
Try executing it as a script instead of a query:
List<My_Text_Content__mdt> myTextContents = [Select Id, Label, DeveloperName, Version__c, Content__c
FROM My_Text_Content__mdt WHERE Version__c = '2020'
ORDER BY Version__c];
for(My_Text_Content__mdt myTextContent: myTextContents)
//Inspect results here
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
answered 8 hours ago
George S.George S.
1,76618 silver badges37 bronze badges
1,76618 silver badges37 bronze badges
Thanks! Same result, though, per System.debug. :-( I actually saw that Known Issue in my original search, but ruled it out since the workaround looks the same as what I'm currently doing.
– Matthew Souther
8 hours ago
Upon further testing on other custom metadata types in our orgs, the issue seems to crop up when the expected result set is over 200 rows. So although the script approach is not providing the hoped-for solution (and the official Salesforce workaround is useless from my perspective), I do agree these could be related issues.
– Matthew Souther
8 hours ago
The SFDC workaround doesn't pass the straight-face test - they should fix this.
– cropredy
5 hours ago
add a comment |
Thanks! Same result, though, per System.debug. :-( I actually saw that Known Issue in my original search, but ruled it out since the workaround looks the same as what I'm currently doing.
– Matthew Souther
8 hours ago
Upon further testing on other custom metadata types in our orgs, the issue seems to crop up when the expected result set is over 200 rows. So although the script approach is not providing the hoped-for solution (and the official Salesforce workaround is useless from my perspective), I do agree these could be related issues.
– Matthew Souther
8 hours ago
The SFDC workaround doesn't pass the straight-face test - they should fix this.
– cropredy
5 hours ago
Thanks! Same result, though, per System.debug. :-( I actually saw that Known Issue in my original search, but ruled it out since the workaround looks the same as what I'm currently doing.
– Matthew Souther
8 hours ago
Thanks! Same result, though, per System.debug. :-( I actually saw that Known Issue in my original search, but ruled it out since the workaround looks the same as what I'm currently doing.
– Matthew Souther
8 hours ago
Upon further testing on other custom metadata types in our orgs, the issue seems to crop up when the expected result set is over 200 rows. So although the script approach is not providing the hoped-for solution (and the official Salesforce workaround is useless from my perspective), I do agree these could be related issues.
– Matthew Souther
8 hours ago
Upon further testing on other custom metadata types in our orgs, the issue seems to crop up when the expected result set is over 200 rows. So although the script approach is not providing the hoped-for solution (and the official Salesforce workaround is useless from my perspective), I do agree these could be related issues.
– Matthew Souther
8 hours ago
The SFDC workaround doesn't pass the straight-face test - they should fix this.
– cropredy
5 hours ago
The SFDC workaround doesn't pass the straight-face test - they should fix this.
– cropredy
5 hours ago
add a comment |
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f272415%2fcustom-metadata-soql-where-clause-not-working%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Is it picklist feild?
– Pranay Jaiswal
9 hours ago
Good question -- no. It's Text(20).
– Matthew Souther
9 hours ago
2
Is it sandbox, prod or scratch org?
– Pranay Jaiswal
9 hours ago
It's a sandbox.
– Matthew Souther
9 hours ago
1
Can you try same query in prod? I think I somewhat saw similar in sandbox but it worked in prod.
– Pranay Jaiswal
9 hours ago