Phoenix query builder

User
|> QueryBuilder.where(firstname: "John")
|> QueryBuilder.where([{:age, :gt, 30}, city: "Anytown"])
|> QueryBuilder.order_by(asc: :lastname)
|> QueryBuilder.preload([:role, authored_articles: :comments])
|> QueryBuilder.offset(20)
|> QueryBuilder.limit(10)
|> Repo.all()

Source: hexdocs.pm

Similar codes

6 votes228 views2 answers
Nav active in laravel
PHP Laravel
1 vote206 views2 answers
Laravel has many with ids
PHP
10 votes217 views3 answers
Join array of strings php
PHP
0 vote232 views1 answer
Laravel get biggest id
PHP
16 votes223 views2 answers
Laravel create or update eloquesnt
PHP
37 votes247 views6 answers
Laravel order by
PHP Laravel
12 votes254 views6 answers
Laravel api routes
PHP
22 votes231 views6 answers
Laravel 6 auth
PHP
1 vote239 views1 answer
Wordpress change slug programmatically
PHP Wordpress
0 vote234 views1 answer
Laravel faker title
PHP Laravel