Check if object is null and return null2019 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 does electrical safety system work on ISS?
"It doesn't matter" or "it won't matter"?
Why Shazam when there is already Superman?
What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?
What is the difference between lands and mana?
Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size?
Review your own paper in Mathematics
C++ check if statement can be evaluated constexpr
Will number of steps recorded on FitBit/any fitness tracker add up distance in PokemonGo?
Does the Linux kernel need a file system to run?
The IT department bottlenecks progress, how should I handle this?
Is there a RAID 0 Equivalent for RAM?
Is there a nicer/politer/more positive alternative for "negates"?
Make a Bowl of Alphabet Soup
How do I fix the group tension caused by my character stealing and possibly killing without provocation?
How to preserve electronics (computers, iPads and phones) for hundreds of years
How to make money from a browser who sees 5 seconds into the future of any web page?
Does "he squandered his car on drink" sound natural?
Why is so much work done on numerical verification of the Riemann Hypothesis?
Delete multiple columns using awk or sed
It grows, but water kills it
How much of a Devil Fruit must be consumed to gain the power?
How do I tell my boss that I'm quitting soon, especially given that a colleague just left this week
How could a planet have erratic days?
Check if object is null and return null
2019 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 yesterday
ebarebar
184
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 yesterday
ebarebar
184
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 yesterday
ebarebar
184
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 yesterday
ebarebar
184
asked yesterday
ebarebar
184
asked yesterday
ebarebar
184
asked yesterday
ebarebar
184
asked yesterday
ebarebar
184
184
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 yesterday
sfdcfoxsfdcfox
260k12207451
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
yesterday
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
yesterday
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 yesterday
Keith CKeith C
96.1k1094212
2
Or simply isEmpty() :)
– Eric
23 hours ago
@Eric I always forget that method...
– Keith C
19 hours ago
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 yesterday
Phil WPhil W
481210
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 yesterday
sfdcfoxsfdcfox
260k12207451
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
yesterday
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
yesterday
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 yesterday
sfdcfoxsfdcfox
260k12207451
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
yesterday
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
yesterday
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 yesterday
sfdcfoxsfdcfox
260k12207451
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 yesterday
sfdcfoxsfdcfox
260k12207451
edited yesterday
answered yesterday
sfdcfoxsfdcfox
260k12207451
answered yesterday
sfdcfoxsfdcfox
260k12207451
answered yesterday
sfdcfoxsfdcfox
260k12207451
260k12207451
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
yesterday
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
yesterday
add a comment |
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
yesterday
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
yesterday
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
yesterday
The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
– Jayant Das
yesterday
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
yesterday
@JayantDas That's what I meant, of course, but I went ahead and clarified.
– sfdcfox
yesterday
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 yesterday
Keith CKeith C
96.1k1094212
2
Or simply isEmpty() :)
– Eric
23 hours ago
@Eric I always forget that method...
– Keith C
19 hours ago
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 yesterday
Keith CKeith C
96.1k1094212
2
Or simply isEmpty() :)
– Eric
23 hours ago
@Eric I always forget that method...
– Keith C
19 hours ago
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 yesterday
Keith CKeith C
96.1k1094212
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 yesterday
Keith CKeith C
96.1k1094212
answered yesterday
Keith CKeith C
96.1k1094212
answered yesterday
Keith CKeith C
96.1k1094212
answered yesterday
Keith CKeith C
96.1k1094212
96.1k1094212
2
Or simply isEmpty() :)
– Eric
23 hours ago
@Eric I always forget that method...
– Keith C
19 hours ago
add a comment |
2
Or simply isEmpty() :)
– Eric
23 hours ago
@Eric I always forget that method...
– Keith C
19 hours ago
2
2
Or simply isEmpty() :)
– Eric
23 hours ago
Or simply isEmpty() :)
– Eric
23 hours ago
@Eric I always forget that method...
– Keith C
19 hours ago
@Eric I always forget that method...
– Keith C
19 hours ago
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 yesterday
Phil WPhil W
481210
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 yesterday
Phil WPhil W
481210
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 yesterday
Phil WPhil W
481210
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 yesterday
Phil WPhil W
481210
answered yesterday
Phil WPhil W
481210
answered yesterday
Phil WPhil W
481210
answered yesterday
Phil WPhil W
481210
481210
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
