Mdthbs

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

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

Examples of hyperbolic groups

Why do dragons like shiny stuff?

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

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

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

Why private jets such as GulfStream ones fly higher than other civil jets?

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

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

How to switch an 80286 from protected to real mode?

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

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

Why did the US Airways Flight 1549 passengers stay on the wings?

If someone else uploads my GPL'd code to Github without my permission, is that a copyright violation?

How to check a file was encrypted (really & correctly)

Identify Batman without getting caught

What prevents ads from reading my password as I type it?

Why does capacitance not depend on the material of the plates?

What is an air conditioner compressor hard start kit and how does it work?

Changing Row Keys into Normal Rows

Is a switch from R to Python worth it?

Getting an entry level IT position later in life

Probably terminated or laid off soon; confront or not?

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