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

1 vote244 views2 answers
Laravel check if object is empty
PHP Laravel
14 votes219 views3 answers
Why use ob_start() in php
PHP
0 vote255 views1 answer
Drupal 9 custom blocks dependency injection
PHP Drupal
1 vote177 views1 answer
Php get browser info
PHP
0 vote258 views5 answers
Laravel 8 app with more than one database
PHP Laravel
1 vote217 views2 answers
Install laravel in ubuntu 20.04
PHP
0 vote246 views3 answers
Laravel query builder get last insert id
PHP Laravel
0 vote240 views1 answer
How to import in laravel excel command
PHP Laravel
2 votes181 views1 answer
Call to undefined function database seeders factory() laravel 8
PHP
5 votes229 views5 answers
Table drop foreign php laravel
PHP