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 vote140 views5 answers
Check if value change laravel
PHP Laravel
11 votes103 views4 answers
Php convert timestamp to datetime
PHP
12 votes94 views6 answers
Php array push with key
PHP
0 vote84 views1 answer
Laravel sanctum Protecting routes
PHP Laravel
-1 vote139 views1 answer
Laravel edit form select don't repeat a selected value
PHP Laravel
0 vote136 views1 answer
Fetch data from database withour restarting console php
PHP
150 votes183 views10 answers
Grepper
PHP
0 vote115 views1 answer
Referencing constant in config laravel
PHP
1 vote112 views1 answer
Validation not exists with this id laravel
PHP
0 vote102 views1 answer
Laravel @extends
PHP