5 replies

Sorting by a translation field (ie, title)

Hi everyone, I feel like I must be missing something simple (as usual) or am making something overly complicated when trying to sort a query by my

title

title

translation field.

I have a

Product

Product

model that is linked to my

Brand

Brand

model via a

brand_id

brand_id

field, with the relationship in the

Product

Product

model as follows:

public function brand()
{
   return $this->belongsTo(\App\Models\Brand::class);
}

public function brand()
{
   return $this->belongsTo(\App\Models\Brand::class);
}

When I try to get the Products for a Particular brand, things start breaking. I had this query, but it breaks things on the front end, the

id

id

field gets overridden and breaks the relationships to translations, I can't use slugs, etc.

$brandProducts = Product::where('brand_id', '=', $brand->id)        
    ->join('product_translations', 'product_id','=', 'products.id', 'inner')
    ->orderBy('title', 'asc')->get();

$brandProducts = Product::where('brand_id', '=', $brand->id)        
    ->join('product_translations', 'product_id','=', 'products.id', 'inner')
    ->orderBy('title', 'asc')->get();

I feel like I am doing something obviously wrong here and I shouldn't have to keep adding more and more JOINs to get the fields I need to make this work properly. I suspect that I'm still relatively new to Laravel may be coming into play here as well. Is there an easier way to query using a field (

brand_id

brand_id

) and still have access to sorting via some of the "default" Repository associations like translations and slugs?

Twill CMS•4y ago•

5 replies

daniel

Sorting by a translation field (ie, title)

Hi everyone, I feel like I must be missing something simple (as usual) or am making something overly complicated when trying to sort a query by my

title

title

translation field.

I have a

Product

Product

model that is linked to my

Brand

Brand

model via a

brand_id

brand_id

field, with the relationship in the

Product

Product

model as follows:

public function brand()
{
   return $this->belongsTo(\App\Models\Brand::class);
}

public function brand()
{
   return $this->belongsTo(\App\Models\Brand::class);
}

When I try to get the Products for a Particular brand, things start breaking. I had this query, but it breaks things on the front end, the

id

id

field gets overridden and breaks the relationships to translations, I can't use slugs, etc.

$brandProducts = Product::where('brand_id', '=', $brand->id)        
    ->join('product_translations', 'product_id','=', 'products.id', 'inner')
    ->orderBy('title', 'asc')->get();

$brandProducts = Product::where('brand_id', '=', $brand->id)        
    ->join('product_translations', 'product_id','=', 'products.id', 'inner')
    ->orderBy('title', 'asc')->get();

brand_id

brand_id

) and still have access to sorting via some of the "default" Repository associations like translations and slugs?

Sorting by a translation field (ie, title)

Similar Threads

Sorting by a translation field (ie, title)

Similar Threads

Similar Threads

Similar Threads