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 vote346 views1 answer
Laravel inRandomOrder
PHP
6 votes349 views4 answers
Php check if string is integer
PHP
0 vote313 views1 answer
Wp get user meta
PHP
1 vote338 views1 answer
Convert date to reverse date in php
PHP
0 vote430 views1 answer
Get thumbnail alt wordpress
PHP Wordpress
2 votes333 views1 answer
Wordpress check user against user roles
PHP
1 vote374 views1 answer
How to return with open model popup in laravel
PHP Laravel
1 vote335 views2 answers
Php shorten string with dots
PHP
10 votes331 views6 answers
Php array_filter
PHP
4 votes292 views1 answer
Laravel model insert
PHP