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

4 votes233 views2 answers
PHP Deprecated: Function create_function()
PHP
9 votes178 views3 answers
Make controller laravel 8 with resource
PHP Laravel
0 vote179 views2 answers
Laravel pdf export
PHP
0 vote193 views3 answers
Automatic get year for copyright html
PHP
0 vote199 views2 answers
Laravel get path to storage folder
PHP Laravel
0 vote162 views1 answer
Supprimer un cookie avec un input en php
PHP
2 votes167 views3 answers
Run artisan command from controller
PHP
1 vote196 views1 answer
Inrandomorder laravel
PHP Laravel
0 vote160 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP
-2 votes139 views1 answer
Laravel trait command
PHP