Home / Questions / 215761
Accepted
Alberto Ortega
Asked: 2020-11-22 10:45:46 +0800 CST 2020-11-22 10:45:46 +0800 CST

Could you help me formulate these queries with eloquent?

  • 772

fetch n records

Modelo::where('llave', '>', $var)->take($n)->get();

it fails because it does not know which records to bring it is missing

latest()

Modelo::all()->take($n);

The same thing happens to this query as the one above is missing the lastest argument

Records between a and b

Modelo::whereIn('campo',[$a,$b])->take($n)->get();

This query should return the fields that are between a and b but it only returns those that match a and b

The queries, even though the parameters are already predefined, are variables for my API. Only when I try to run these queries it fails.

sql

1 Answers

  1. Best Answer

    You mention that in both cases you must include the method latest(), so I would rearrange your query like this:

    first consultation

    Modelo::where('llave', '>', $var)
       ->latest('llave')
       ->take($n)
       ->get();

    second consultation

    In the case of the second query, you cannot use take()the method at the same time, all()so I suggest you use the method select()to indicate which columns you want it to bring you; if you want all the columns you can do it like this

    Modelo::select('*')->latest('campo')->take($n)->get();

    third consultation

    Modelo::whereBetween('campo',[$a,$b])
      ->latest('campo')
      ->take($n)
      ->get();

    You pass the method latestas an argument; the name of the column by which you want to be sorted DESCand it should return the results

    In the case of the 3 queries, in the method latest()you must pass between quotes the name of the column by which you want to do the orderingDESC

    • 1