How to include data from related models/tables

[LemonPie22]

I have a Quote model which has several relationships, e.g:

public function organisation()
{
    return $this->belongsTo(Organisation::class);
}
public function customer()
{
    return $this->belongsTo(User::class);
}
public function author()
{
    return $this->belongsTo(User::class);
}

My audit trail for quotes shows the column names and values in the form author_id 1501 sales_organisation_id 1 sales_person_id 1501, which isn't too friendly for end users.

How can I display the name column values from my related tables so that the output is more informative?

Ideally, I'd like to display something like Author: Fred Jones, Sales organisation: Microsoft, Sales person: John Doe

[andreia]

Hi @LemonPie22

Thanks for this comment!
For now, a possible solution is to use audit transformation but it will save the extra data on database.

We had the same requirement a while ago. Working on a solution to allow modifying data for display. I'll let you know when it's available!
Suggestions are welcome! :)

[andreia]

@LemonPie22 Just created a PR for it: https://github.com/TappNetwork/filament-auditing/pull/26/files
I would love to hear what you think about it! Thanks!