getNavigationBadge()

This function is not working for me, what could be the reason?

public static function getNavigationBadge(): ?string
    {
        return static::getModel()::where('stock_minimo','>','stock')->count();
    }

public static function getNavigationBadge(): ?string
    {
        return static::getModel()::where('stock_minimo','>','stock')->count();
    }

Solution

This is what you need

whereColumn

whereColumn

public static function getNavigationBadge(): ?string
{
    return static::getModel()::whereColumn('stock_minimo', '<', 'stock')->count();
}

public static function getNavigationBadge(): ?string
{
    return static::getModel()::whereColumn('stock_minimo', '<', 'stock')->count();
}

Filament•2y ago•

19 replies

This function is not working for me, what could be the reason?

public static function getNavigationBadge(): ?string
    {
        return static::getModel()::where('stock_minimo','>','stock')->count();
    }

public static function getNavigationBadge(): ?string
    {
        return static::getModel()::where('stock_minimo','>','stock')->count();
    }

Solution

This is what you need

whereColumn

whereColumn

public static function getNavigationBadge(): ?string
{
    return static::getModel()::whereColumn('stock_minimo', '<', 'stock')->count();
}

public static function getNavigationBadge(): ?string
{
    return static::getModel()::whereColumn('stock_minimo', '<', 'stock')->count();
}