Xjyuk

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

The meaning of "scale" in "because diversions scale so easily wealth becomes concentrated"

Could an areostationary satellite help locate asteroids?

…down the primrose path

Can I enter a rental property without giving notice if I'm afraid a tenant may be hurt?

How does LIDAR avoid getting confused in an environment being scanned by hundreds of other LIDAR?

How do I get the =LEFT function in excel, to also take the number zero as the first number?

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

Premier League simulation

Why do proponents of guns oppose gun competency tests?

The Game of the Century - why didn't Byrne take the rook after he forked Fischer?

Traveling from Germany to other countries by train?

I am considering a visit to a Nevada brothel. What should I say at the US border?

What was the role of Commodore-West Germany?

Pronouns when writing from the point of view of a robot

Is the first page of a novel really that important?

In MTG, was there ever a five-color deck that worked well?

Plato and the knowledge of the forms

What does the ISO setting for mechanical 35mm film cameras actually do?

Is space radiation a risk for space film photography, and how is this prevented?

A verb for when some rights are not violated?

How to realistically deal with a shield user?

Vibration on the guitar when playing two strings

Why do cheap flights with a layover get more expensive when you split them up into separate flights?

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 9 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The ->anyStatus()-> was me just trying things to get this to work...
  
  – SublymeRick
  9 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 9 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The ->anyStatus()-> was me just trying things to get this to work...
  
  – SublymeRick
  9 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 9 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 9 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

share|improve this question

asked 9 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

asked 9 hours ago

SublymeRickSublymeRick

41222 silver badges1515 bronze badges

asked 9 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 9 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did the trick! thanks! (spelling is hard)
  
  – SublymeRick
  9 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 9 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did the trick! thanks! (spelling is hard)
  
  – SublymeRick
  9 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 9 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This did the trick! thanks! (spelling is hard)
  
  – SublymeRick
  9 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 9 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 9 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

answered 9 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges

answered 9 hours ago

Brandon KellyBrandon Kelly

30k5555 silver badges119119 bronze badges