Does 9.0 supports pivot table auditing

[PrafullaKumarSahu]

Q	A
Bug?	no
New Feature?	yes
Framework	Laravel
Framework version	5.6
Package version	9.0
PHP version	7.2.10

Actual Behaviour

1. I just want to confirm if 9.0 supports auditing of pivots as documentation is still not updated to 9.0?
2. if yes, will it work with Laravel 5.6?
3. Is there any simpler way I can achive this with 8.0 and laravel 5.6?

[vpillinger]

Laravel does not fire eloquent events on pivots in 5.6 so not using the sync() or save() methods on relationships.

There is currently an open pull request in Laravel to do update this, but it will not be until Laravel 5.10 that it is likely released.

You must do 2 steps instead:

1. Create custom Pivot Model.
2. Update the pivot model directly instead of using relationship methods.

[PrafullaKumarSahu]

@vpillinger there is something on laravel 5.8 here > Intermediate Table / Pivot Model Events will this not help auditing?

[jonagoldman]

Related #58

[PrafullaKumarSahu]

@jonagoldman so now, if it is dispatching events, in laravel 5.8, we can audit many-to-may relations, right?

[vpillinger]

Sorry, it appears that in Laravel 5.8 this was indeed updated. The ticket in the Laravel repo was not closed so I did not realize that this was actually done. When I dived the code in 5.8, I did not see the events firing, but better to trust the documentation :).

So all you should need to do is create a custom pivot model and add auditable to it and your good to go.

[PrafullaKumarSahu]

@vpillinger It will not work for me right now, but as I had noticed you, thought to let you know, nothing else. I will try your solution, what I did is generated another table to get everything recorded and using that to create the report, but I will definitely try your solution and let you know.

[MortenDHansen]

v13 supports a way to audit pivots as properties of the auditable itself https://www.laravel-auditing.com/docs/13.0/audit-custom

[jezmck]

Above link is now https://laravel-auditing.com/guide/audit-custom.html