Mfcttrf

I was contacted by a private bank overseas to get my inheritance

Tile the chessboard with four-colored triominoes

How many years before enough atoms of your body are replaced to survive the sudden disappearance of the original body’s atoms?

Pronouns when writing from the point of view of a robot

How and where to get you research work assessed for PhD?

What could prevent players from leaving an island?

Which genus do I use for neutral expressions in German?

Traveling from Germany to other countries by train?

Purchased new computer from DELL with pre-installed Ubuntu. Won't boot. Should assume its an error from DELL?

Which pronoun to replace an infinitive?

Will a research paper be retracted if the code (which was made publically available ) is shown have a flaw in the logic?

Does a 4 bladed prop have almost twice the thrust of a 2 bladed prop?

Why does putting a dot after the URL remove login information?

What is it exactly about flying a Flyboard across the English channel that made Zapata's thighs burn?

How to sort List<T> in c#

How important is it to have a spot meter on the light meter?

New workplace asking for bank pin and account number

Plato and the knowledge of the forms

Whats the difference between <processors> and <pipelines> in Sitecore configuration?

Does a humanoid possessed by a ghost register as undead to a paladin's Divine Sense?

Entry element query missing user field data when user is suspended

Why is the Vasa Museum in Stockholm so Popular?

A verb for when some rights are not violated?

What's going on with an item that starts with an hbox?

Entry element query missing user field data when user is suspended

Setting a conditional for username in URL?How can I set an entry title automatically, based on a related entry?Multi-user blog “repost entry” functionalityGet related entry data within a plugin (ElementCriteriaModel) without extra queriesFetching Existing Users In Users Field Doesnt Work When entries.saveEntry Event Triggerred From FrontendEntry FieldType - Get the EntryModel of the entry chosen in the field?Edit entry, on the front end, with the entries fieldCraft 3 How to get custom user field valuesUser Account Form DropdownHow to pragmatically set registered user status to pending and then manually send activation email

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

3

I have a channel in which each channel entry has a "users" field type that is limited to one user. My code below works fine when the user is not suspended, however if I suspend the user, the then $entry->user field is null rather than set to the array of one user like its normally set to.

Here is my code:

 // do criteria code to get pending transfers from patients channel
 $account = $userIdentity->getFieldValue('account')->first();
 $entryQuery = Entry::find()
 ->section('networkAssets')
 ->relatedTo(['targetElement' => $account, "field" => "account"])
 ->orderBy('title asc');


 // Execute the query and get the results
 $entries = $entryQuery->anyStatus()->all();
 $assets = [];
 foreach($entries as $entry) 
 $user = $entry->user->one();
 $assets[] = [
 'id' => $entry->id,
 'slug' => $entry->slug,
 'title' => $entry->title,
 'email' => $user->email,
 'first_name' => $user->firstName,
 'last_name' => $user->lastName,
 'address1' => $entry->address1,
 'address2' => $entry->address2,
 'state_province' => $entry->stateProvince,
 'city' => $entry->city,
 'postal_code' => $entry->postalCode,
 'country' => $entry->country,
 'username' => $user->username,
 'password' => '',
 'status' => $user->getStatus(),
 'date_created' => $entry->dateCreated->format('m/d/Y') . "<br>" . $entry->dateCreated->format('H:i:s T'),
 'last_login' => $user->lastLoginDate ? $user->lastLoginDate->format('m/d/Y') . "<br>" . $user->lastLoginDate->format('H:i:s T') : 'Never',
 'phone' => $entry->phoneNumber
 ];
 

 return $assets;

You can see in the foreach loop that Im getting the user from the looped entry result and storing it in a $user variable.

When I try to use $user I get a notice because $user is null.

How can I force this code to return the linked user in the user field even when the user is suspended?

plugin-development craft3 entries

share|improve this question

asked 8 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The ->anyStatus()-> was me just trying things to get this to work...
  
  – SublymeRick
  8 hours ago
  

  
  
  
  

add a comment | 

3

I have a channel in which each channel entry has a "users" field type that is limited to one user. My code below works fine when the user is not suspended, however if I suspend the user, the then $entry->user field is null rather than set to the array of one user like its normally set to.

Here is my code:

 // do criteria code to get pending transfers from patients channel
 $account = $userIdentity->getFieldValue('account')->first();
 $entryQuery = Entry::find()
 ->section('networkAssets')
 ->relatedTo(['targetElement' => $account, "field" => "account"])
 ->orderBy('title asc');


 // Execute the query and get the results
 $entries = $entryQuery->anyStatus()->all();
 $assets = [];
 foreach($entries as $entry) 
 $user = $entry->user->one();
 $assets[] = [
 'id' => $entry->id,
 'slug' => $entry->slug,
 'title' => $entry->title,
 'email' => $user->email,
 'first_name' => $user->firstName,
 'last_name' => $user->lastName,
 'address1' => $entry->address1,
 'address2' => $entry->address2,
 'state_province' => $entry->stateProvince,
 'city' => $entry->city,
 'postal_code' => $entry->postalCode,
 'country' => $entry->country,
 'username' => $user->username,
 'password' => '',
 'status' => $user->getStatus(),
 'date_created' => $entry->dateCreated->format('m/d/Y') . "<br>" . $entry->dateCreated->format('H:i:s T'),
 'last_login' => $user->lastLoginDate ? $user->lastLoginDate->format('m/d/Y') . "<br>" . $user->lastLoginDate->format('H:i:s T') : 'Never',
 'phone' => $entry->phoneNumber
 ];
 

 return $assets;

You can see in the foreach loop that Im getting the user from the looped entry result and storing it in a $user variable.

When I try to use $user I get a notice because $user is null.

How can I force this code to return the linked user in the user field even when the user is suspended?

plugin-development craft3 entries

share|improve this question

asked 8 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The ->anyStatus()-> was me just trying things to get this to work...
  
  – SublymeRick
  8 hours ago
  

  
  
  
  

add a comment | 

I have a channel in which each channel entry has a "users" field type that is limited to one user. My code below works fine when the user is not suspended, however if I suspend the user, the then $entry->user field is null rather than set to the array of one user like its normally set to.

Here is my code:

 // do criteria code to get pending transfers from patients channel
 $account = $userIdentity->getFieldValue('account')->first();
 $entryQuery = Entry::find()
 ->section('networkAssets')
 ->relatedTo(['targetElement' => $account, "field" => "account"])
 ->orderBy('title asc');


 // Execute the query and get the results
 $entries = $entryQuery->anyStatus()->all();
 $assets = [];
 foreach($entries as $entry) 
 $user = $entry->user->one();
 $assets[] = [
 'id' => $entry->id,
 'slug' => $entry->slug,
 'title' => $entry->title,
 'email' => $user->email,
 'first_name' => $user->firstName,
 'last_name' => $user->lastName,
 'address1' => $entry->address1,
 'address2' => $entry->address2,
 'state_province' => $entry->stateProvince,
 'city' => $entry->city,
 'postal_code' => $entry->postalCode,
 'country' => $entry->country,
 'username' => $user->username,
 'password' => '',
 'status' => $user->getStatus(),
 'date_created' => $entry->dateCreated->format('m/d/Y') . "<br>" . $entry->dateCreated->format('H:i:s T'),
 'last_login' => $user->lastLoginDate ? $user->lastLoginDate->format('m/d/Y') . "<br>" . $user->lastLoginDate->format('H:i:s T') : 'Never',
 'phone' => $entry->phoneNumber
 ];
 

 return $assets;

You can see in the foreach loop that Im getting the user from the looped entry result and storing it in a $user variable.

When I try to use $user I get a notice because $user is null.

How can I force this code to return the linked user in the user field even when the user is suspended?

plugin-development craft3 entries

share|improve this question

asked 8 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

 // do criteria code to get pending transfers from patients channel
 $account = $userIdentity->getFieldValue('account')->first();
 $entryQuery = Entry::find()
 ->section('networkAssets')
 ->relatedTo(['targetElement' => $account, "field" => "account"])
 ->orderBy('title asc');


 // Execute the query and get the results
 $entries = $entryQuery->anyStatus()->all();
 $assets = [];
 foreach($entries as $entry) 
 $user = $entry->user->one();
 $assets[] = [
 'id' => $entry->id,
 'slug' => $entry->slug,
 'title' => $entry->title,
 'email' => $user->email,
 'first_name' => $user->firstName,
 'last_name' => $user->lastName,
 'address1' => $entry->address1,
 'address2' => $entry->address2,
 'state_province' => $entry->stateProvince,
 'city' => $entry->city,
 'postal_code' => $entry->postalCode,
 'country' => $entry->country,
 'username' => $user->username,
 'password' => '',
 'status' => $user->getStatus(),
 'date_created' => $entry->dateCreated->format('m/d/Y') . "<br>" . $entry->dateCreated->format('H:i:s T'),
 'last_login' => $user->lastLoginDate ? $user->lastLoginDate->format('m/d/Y') . "<br>" . $user->lastLoginDate->format('H:i:s T') : 'Never',
 'phone' => $entry->phoneNumber
 ];
 

 return $assets;

share|improve this question

asked 8 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

share|improve this question

asked 8 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

asked 8 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

asked 8 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

1 Answer
1

active

oldest

votes

3

User queries by default will only return active users, not pending or suspended ones.

To include suspended users, change this line:

$user = $entry->user->one();

to this:

$user = $entry->user->status(['active', 'suspended'])->one();

Or if you want to include pending users as well (users who haven’t activated their account yet), you can do this:

$user = $entry->user->anyStatus()->one();

share|improve this answer

answered 8 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did the trick! thanks! (spelling is hard)
  
  – SublymeRick
  8 hours ago
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "563"
;
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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcraftcms.stackexchange.com%2fquestions%2f31151%2fentry-element-query-missing-user-field-data-when-user-is-suspended%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

User queries by default will only return active users, not pending or suspended ones.

To include suspended users, change this line:

$user = $entry->user->one();

to this:

$user = $entry->user->status(['active', 'suspended'])->one();

Or if you want to include pending users as well (users who haven’t activated their account yet), you can do this:

$user = $entry->user->anyStatus()->one();

share|improve this answer

answered 8 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did the trick! thanks! (spelling is hard)
  
  – SublymeRick
  8 hours ago
  
  

  
  
  
  

add a comment | 

3

User queries by default will only return active users, not pending or suspended ones.

To include suspended users, change this line:

$user = $entry->user->one();

to this:

$user = $entry->user->status(['active', 'suspended'])->one();

Or if you want to include pending users as well (users who haven’t activated their account yet), you can do this:

$user = $entry->user->anyStatus()->one();

share|improve this answer

answered 8 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did the trick! thanks! (spelling is hard)
  
  – SublymeRick
  8 hours ago
  
  

  
  
  
  

add a comment | 

User queries by default will only return active users, not pending or suspended ones.

To include suspended users, change this line:

$user = $entry->user->one();

to this:

$user = $entry->user->status(['active', 'suspended'])->one();

Or if you want to include pending users as well (users who haven’t activated their account yet), you can do this:

$user = $entry->user->anyStatus()->one();

share|improve this answer

answered 8 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

$user = $entry->user->one();

$user = $entry->user->status(['active', 'suspended'])->one();

$user = $entry->user->anyStatus()->one();

share|improve this answer

answered 8 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

answered 8 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

answered 8 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges