How to display serial number in Laravel Nova?

Question

Laravel

I need to display the sequence number (#) of a record in a table in Laravel Nova.
No. | ID
5 | 1244
| 100
3 | 95
2 | 93
1 | 90

Answer 1

Added indexQuery to the resource, like the norms.

public static function indexQuery(NovaRequest $request, $query)
    {
        DB::statement(DB::raw('set @count=0'));
        return $query->select(DB::raw('*, (@count:[email protected]+1) AS serial'));
    }