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
Telemetry for feature health
ContourPlot — How do I color by contour curvature?
Anime with legendary swords made from talismans and a man who could change them with a shattered body
What is this high flying aircraft over Pennsylvania?
What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?
Origin of pigs as a species
Alignment of six matrices
Why would five hundred and five be same as one?
How do I prevent inappropriate ads from appearing in my game?
Proving a complicated language is not a CFL
Limit max CPU usage SQL SERVER with WSRM
Can I cause damage to electrical appliances by unplugging them when they are turned on?
Personal or impersonal in a technical resume
How would a solely written language work mechanically
Typing CO_2 easily
How to make a list of partial sums using forEach
Why is the sun approximated as a black body at ~ 5800 K?
How do I tell my boss that I'm quitting in 15 days (a colleague left this week)
What the heck is gets(stdin) on site coderbyte?
Given this phrasing in the lease, when should I pay my rent?
Echo with obfuscation
Why is the principal energy of an electron lower for excited electrons in a higher energy state?
Why the "ls" command is showing the permissions of files in a FAT32 partition?
How do you justify more code being written by following clean code practices?
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 27 mins ago
ebarebar
132
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 27 mins ago
ebarebar
132
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 27 mins ago
ebarebar
132
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 27 mins ago
ebarebar
132
asked 27 mins ago
ebarebar
132
asked 27 mins ago
ebarebar
132
asked 27 mins ago
ebarebar
132
asked 27 mins ago
ebarebar
132
132
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
The syntax in your code throws a QueryException if you try it. 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 23 mins ago
sfdcfoxsfdcfox
260k12205450
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 24 mins ago
Keith CKeith C
96.1k1094212
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 23 mins ago
Phil WPhil W
471210
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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. 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 23 mins ago
sfdcfoxsfdcfox
260k12205450
add a comment |
The syntax in your code throws a QueryException if you try it. 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 23 mins ago
sfdcfoxsfdcfox
260k12205450
add a comment |
The syntax in your code throws a QueryException if you try it. 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 23 mins ago
sfdcfoxsfdcfox
260k12205450
The syntax in your code throws a QueryException if you try it. 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 23 mins ago
sfdcfoxsfdcfox
260k12205450
answered 23 mins ago
sfdcfoxsfdcfox
260k12205450
answered 23 mins ago
sfdcfoxsfdcfox
260k12205450
answered 23 mins ago
sfdcfoxsfdcfox
260k12205450
260k12205450
add a comment |
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 24 mins ago
Keith CKeith C
96.1k1094212
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 24 mins ago
Keith CKeith C
96.1k1094212
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 24 mins ago
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 24 mins ago
Keith CKeith C
96.1k1094212
answered 24 mins ago
Keith CKeith C
96.1k1094212
answered 24 mins ago
Keith CKeith C
96.1k1094212
answered 24 mins ago
Keith CKeith C
96.1k1094212
96.1k1094212
add a comment |
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 23 mins ago
Phil WPhil W
471210
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 23 mins ago
Phil WPhil W
471210
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 23 mins ago
Phil WPhil W
471210
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 23 mins ago
Phil WPhil W
471210
answered 23 mins ago
Phil WPhil W
471210
answered 23 mins ago
Phil WPhil W
471210
answered 23 mins ago
Phil WPhil W
471210
471210
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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
