Check if object is null and return null The Next CEO of Stack Overflow2019 Community Moderator Electionhow to check if limit is approaching in my triggerRunning a child query on Person AccountsWhat reasons would the id in URL be null?deserializing JSON returns a null objectReturn SOQL for current record on Visualforce EmailBest Practices : Page Reference method return nullSOQL Select in test setup?Check isEmpty OR Catch ListException?Ajax REST Tooling Queries Return Null SymbolTable?“Attempt to de-reference a null object” on VF page
How to place nodes around a circle from some initial angle?
What connection does MS Office have to Netscape Navigator?
What did we know about the Kessel run before the prologues?
Does soap repel water?
I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
Why isn't acceleration always zero whenever velocity is zero, such as the moment a ball bounces off a wall?
What happens if you roll doubles 3 times then land on "Go to jail?"
Why, when going from special to general relativity, do we just replace partial derivatives with covariant derivatives?
Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?
Can MTA send mail via a relay without being told so?
What is the purpose of the Evocation wizard's Potent Cantrip feature?
unclear about Dynamic Binding
Domestic-to-international connection at Orlando (MCO)
Is micro rebar a better way to reinforce concrete than rebar?
Flying from Cape Town to England and return to another province
How to avoid supervisors with prejudiced views?
I want to delete every two lines after 3rd lines in file contain very large number of lines :
What flight has the highest ratio of time difference to flight time?
Unreliable Magic - Is it worth it?
Arranging cats and dogs - what is wrong with my approach
Why do remote US companies require working in the US?
Display a text message if the shortcode is not found?
Why the difference in type-inference over the as-pattern in two similar function definitions?
Check if object is null and return null
The Next CEO of Stack Overflow2019 Community Moderator Electionhow to check if limit is approaching in my triggerRunning a child query on Person AccountsWhat reasons would the id in URL be null?deserializing JSON returns a null objectReturn SOQL for current record on Visualforce EmailBest Practices : Page Reference method return nullSOQL Select in test setup?Check isEmpty OR Catch ListException?Ajax REST Tooling Queries Return Null SymbolTable?“Attempt to de-reference a null object” on VF page
I'm doing a query to an object. My question is if nothing returns is it technically null. I want to return null if it is.
People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];
if (person == null)
return null;
apex visualforce visualforce-component
asked Mar 20 at 21:19
ebarebar
234
add a comment |
I'm doing a query to an object. My question is if nothing returns is it technically null. I want to return null if it is.
People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];
if (person == null)
return null;
apex visualforce visualforce-component
asked Mar 20 at 21:19
ebarebar
234
add a comment |
I'm doing a query to an object. My question is if nothing returns is it technically null. I want to return null if it is.
People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];
if (person == null)
return null;
apex visualforce visualforce-component
asked Mar 20 at 21:19
ebarebar
234
I'm doing a query to an object. My question is if nothing returns is it technically null. I want to return null if it is.
People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];
if (person == null)
return null;
apex visualforce visualforce-component
apex visualforce visualforce-component
asked Mar 20 at 21:19
ebarebar
234
asked Mar 20 at 21:19
ebarebar
234
asked Mar 20 at 21:19
ebarebar
234
asked Mar 20 at 21:19
ebarebar
234
asked Mar 20 at 21:19
ebarebar
234
234
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:
People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1])
person = record;
return person; // will return null or a single record
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
Mar 20 at 21:53
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
Mar 21 at 0:50
add a comment |
One way to do this is to check for the number of records returned:
People[] persons = [...];
if (persons.size() == 0) return null;
as your code as written will generate this exception if no records match:
System.QueryException: List has no rows for assignment to SObject
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
2
Or simply isEmpty() :)
– Eric
Mar 21 at 4:10
@Eric I always forget that method...
– Keith C
Mar 21 at 8:04
add a comment |
Change the code to:
People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];
if (people.size() == 0)
return null;
else
return people[0];
answered Mar 20 at 21:23
Phil WPhil W
641210
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%2f254673%2fcheck-if-object-is-null-and-return-null%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:
People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1])
person = record;
return person; // will return null or a single record
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
Mar 20 at 21:53
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
Mar 21 at 0:50
add a comment |
The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:
People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1])
person = record;
return person; // will return null or a single record
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
Mar 20 at 21:53
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
Mar 21 at 0:50
add a comment |
The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:
People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1])
person = record;
return person; // will return null or a single record
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:
People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1])
person = record;
return person; // will return null or a single record
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
edited Mar 21 at 0:49
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
answered Mar 20 at 21:23
sfdcfoxsfdcfox
262k12209454
262k12209454
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
Mar 20 at 21:53
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
Mar 21 at 0:50
add a comment |
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
Mar 20 at 21:53
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
Mar 21 at 0:50
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
Mar 20 at 21:53
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
Mar 20 at 21:53
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
Mar 21 at 0:50
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
Mar 21 at 0:50
add a comment |
One way to do this is to check for the number of records returned:
People[] persons = [...];
if (persons.size() == 0) return null;
as your code as written will generate this exception if no records match:
System.QueryException: List has no rows for assignment to SObject
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
2
Or simply isEmpty() :)
– Eric
Mar 21 at 4:10
@Eric I always forget that method...
– Keith C
Mar 21 at 8:04
add a comment |
One way to do this is to check for the number of records returned:
People[] persons = [...];
if (persons.size() == 0) return null;
as your code as written will generate this exception if no records match:
System.QueryException: List has no rows for assignment to SObject
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
2
Or simply isEmpty() :)
– Eric
Mar 21 at 4:10
@Eric I always forget that method...
– Keith C
Mar 21 at 8:04
add a comment |
One way to do this is to check for the number of records returned:
People[] persons = [...];
if (persons.size() == 0) return null;
as your code as written will generate this exception if no records match:
System.QueryException: List has no rows for assignment to SObject
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
One way to do this is to check for the number of records returned:
People[] persons = [...];
if (persons.size() == 0) return null;
as your code as written will generate this exception if no records match:
System.QueryException: List has no rows for assignment to SObject
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
answered Mar 20 at 21:22
Keith CKeith C
96.3k1096214
96.3k1096214
2
Or simply isEmpty() :)
– Eric
Mar 21 at 4:10
@Eric I always forget that method...
– Keith C
Mar 21 at 8:04
add a comment |
2
Or simply isEmpty() :)
– Eric
Mar 21 at 4:10
@Eric I always forget that method...
– Keith C
Mar 21 at 8:04
2
2
Or simply isEmpty() :)
– Eric
Mar 21 at 4:10
Or simply isEmpty() :)
– Eric
Mar 21 at 4:10
@Eric I always forget that method...
– Keith C
Mar 21 at 8:04
@Eric I always forget that method...
– Keith C
Mar 21 at 8:04
add a comment |
Change the code to:
People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];
if (people.size() == 0)
return null;
else
return people[0];
answered Mar 20 at 21:23
Phil WPhil W
641210
add a comment |
Change the code to:
People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];
if (people.size() == 0)
return null;
else
return people[0];
answered Mar 20 at 21:23
Phil WPhil W
641210
add a comment |
Change the code to:
People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];
if (people.size() == 0)
return null;
else
return people[0];
answered Mar 20 at 21:23
Phil WPhil W
641210
Change the code to:
People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];
if (people.size() == 0)
return null;
else
return people[0];
answered Mar 20 at 21:23
Phil WPhil W
641210
answered Mar 20 at 21:23
Phil WPhil W
641210
answered Mar 20 at 21:23
Phil WPhil W
641210
answered Mar 20 at 21:23
Phil WPhil W
641210
641210
add a comment |
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%2f254673%2fcheck-if-object-is-null-and-return-null%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
