How to get user for audit?

[newave-ws]

I trying to get the relative user of the audit?

this is the audit.php
`<?php

return [

'enabled' => env('AUDITING_ENABLED', false),

/*
|--------------------------------------------------------------------------
| Audit Implementation
|--------------------------------------------------------------------------
|
| Define which Audit model implementation should be used.
|
*/

'implementation' => OwenIt\Auditing\Models\Audit::class,

/*
|--------------------------------------------------------------------------
| User Morph prefix & Guards
|--------------------------------------------------------------------------
|
| Define the morph prefix and authentication guards for the User resolver.
|
*/

'user'      => [
    'morph_prefix' => 'user',
    'guards'       => [
        'web',
        'api'
    ],
    'resolver'     => OwenIt\Auditing\Resolvers\UserResolver::class
],

/*
|--------------------------------------------------------------------------
| Audit Resolvers
|--------------------------------------------------------------------------
|
| Define the IP Address, User Agent and URL resolver implementations.
|
*/
'resolvers' => [
    'ip_address' => OwenIt\Auditing\Resolvers\IpAddressResolver::class,
    'user_agent' => OwenIt\Auditing\Resolvers\UserAgentResolver::class,
    'url'        => OwenIt\Auditing\Resolvers\UrlResolver::class,
],

/*
|--------------------------------------------------------------------------
| Audit Events
|--------------------------------------------------------------------------
|
| The Eloquent events that trigger an Audit.
|
*/

'events' => [
    'created',
    'updated',
    'deleted',
    'restored'
],

/*
|--------------------------------------------------------------------------
| Strict Mode
|--------------------------------------------------------------------------
|
| Enable the strict mode when auditing?
|
*/

'strict' => false,

/*
|--------------------------------------------------------------------------
| Global exclude
|--------------------------------------------------------------------------
|
| Have something you always want to exclude by default? - add it here.
| Note that this is overwritten (not merged) with local exclude
|
*/

'exclude' => [],

/*
|--------------------------------------------------------------------------
| Empty Values
|--------------------------------------------------------------------------
|
| Should Audit records be stored when the recorded old_values & new_values
| are both empty?
|
| Some events may be empty on purpose. Use allowed_empty_values to exclude
| those from the empty values check. For example when auditing
| model retrieved events which will never have new and old values.
|
|
*/

'empty_values'         => true,
'allowed_empty_values' => [
    'retrieved'
],

/*
|--------------------------------------------------------------------------
| Audit Timestamps
|--------------------------------------------------------------------------
|
| Should the created_at, updated_at and deleted_at timestamps be audited?
|
*/

'timestamps' => false,

/*
|--------------------------------------------------------------------------
| Audit Threshold
|--------------------------------------------------------------------------
|
| Specify a threshold for the amount of Audit records a model can have.
| Zero means no limit.
|
*/

'threshold' => 0,

/*
|--------------------------------------------------------------------------
| Audit Driver
|--------------------------------------------------------------------------
|
| The default audit driver used to keep track of changes.
|
*/

'driver' => 'database',

/*
|--------------------------------------------------------------------------
| Audit Driver Configurations
|--------------------------------------------------------------------------
|
| Available audit drivers and respective configurations.
|
*/

'drivers' => [
    'database' => [
        'table'      => 'audits',
        'connection' => null,
    ],
],

/*
|--------------------------------------------------------------------------
| Audit Queue Configurations
|--------------------------------------------------------------------------
|
| Available audit queue configurations.
|
*/

'queue' => [
    'enable'     => false,
    'connection' => 'sync',
    'queue'      => 'default',
    'delay'      => 0,
],

/*
|--------------------------------------------------------------------------
| Audit Console
|--------------------------------------------------------------------------
|
| Whether console events should be audited (eg. php artisan db:seed).
|
*/

'console' => false,

];
`

And this is the function that i'm trying to get the audits

$modelClass = 'App\\Models\\' . $request->model; $modelInstance = resolve($modelClass); $query = $modelInstance->query()->where('id', $request->id) ->with('audits', function ($query) { $query->orderBy('id', 'desc') ->select('id', 'auditable_id', 'auditable_type', 'user_id', 'event', 'new_values', 'old_values', 'ip_address', 'user_agent', 'created_at') ->with('user'); });

the response is the getting null user field

[willpower232]

What do the rows in your audit table look like? Are auditable_type and auditable_id filled in?

[newave-ws]

Yes, i'm getting the audit but the relational user is null
see the following image

[willpower232]

Your screenshot shows user_id 1, do you have that row in your users table?

[newave-ws]

Of course, it is my main user.

[willpower232]

Oh hang on, because you've requested specific columns, you've missed off user_type.

Some simpler version of your code would be

$query = $modelInstance->query()
    ->where('id', $request->id)
    ->with([
        'audits' => function ($query) { $query->orderBy('id', 'desc'); },
        'audits.user',
    ]);

[newave-ws]

Amazing, thank you for your insight.
I'm getting the user with the audits, can you explain what i have done wrong?

[newave-ws]

And can you answer another problem that i don't managed to solve?

[willpower232]

I eventually remembered that the user model was a morph relationship

laravel-auditing/src/Audit.php

Lines 48 to 53 in 22682dd

	public function user()
	{
	$morphPrefix = Config::get('audit.user.morph_prefix', 'user');
	return $this->morphTo(__FUNCTION__, $morphPrefix . '_type', $morphPrefix . '_id');
	}

As your initial code sample included select(), you were accidentally not selecting both fields in the database so when Laravel received the data it was not able to look up the user models.

Is it a related problem or should it be a different discussion?

[newave-ws]

First, can i get the user specific fields like name and email instead of all the data?
second, I've already opened discussion about that but i didn't got the answer yet? #927