How to create a subquery using Laravel Eloquent?

by

This is how you do a subquery where:

$q->where('price_date', function($q) use ($start_date)
{
   $q->from('benchmarks_table_name')
    ->selectRaw('min(price_date)')
    ->where('price_date', '>=', $start_date)
    ->where('ticker', $this->ticker);
});

Unfortunately orWhere requires explicitly provided $operator, otherwise it will raise an error, so in your case:

$q->orWhere('price_date', '=', function($q) use ($start_date)
{
   $q->from('benchmarks_table_name')
    ->selectRaw('min(price_date)')
    ->where('price_date', '>=', $start_date)
    ->where('ticker', $this->ticker);
});

EDIT: You need to specify from in the closure in fact, otherwise it will not build correct query.

More Related Contents:

  1. Laravel Check If Related Model Exists
  2. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  3. Laravel Eloquent: How to order results of related models?
  4. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  5. How to set a default attribute value for a Laravel / Eloquent model?
  6. Laravel Eloquent – Attach vs Sync
  7. Update without touching timestamps (Laravel)
  8. Eloquent model mass update
  9. How can I query raw via Eloquent?
  10. Find or Create with Eloquent
  11. Laravel Many to many self referencing table only works one way
  12. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  13. Automatically deleting related rows in Laravel (Eloquent ORM)
  14. How to do this in Laravel, subquery where in
  15. Laravel Eloquent Query Using WHERE with OR AND OR?
  16. Download files in laravel using Response::download
  17. Laravel update model with unique validation rule for attribute
  18. Get the Query Executed in Laravel 3/4
  19. What does “Mass Assignment” mean in Laravel?
  20. How do I redirect after download in Laravel?
  21. Laravel Checking If a Record Exists
  22. laravel TokenMismatchException in ajax request
  23. Laravel 5 hasMany relationship on two columns
  24. Laravel: Validation unique on update
  25. Laravel Recursive Relationships
  26. Change name of Laravel’s created_at and updated_at
  27. Eloquent many-to-many-to-many – how to load distant relation easily
  28. Using namespaces in Laravel 4
  29. Laravel extend Form class
  30. Can’t make Laravel 4 to work on localhost

Leave a Comment