Topics tagged ecto-query

Topic	Replies	Views	Activity
How do I solve pagination (Repo.aggregate(:count)) on query with group_by in the best way? Questions / Help ecto , troubleshooting , pagination , ecto-query	3	1000	September 25, 2024
Ecto IN clauses with tuples Questions / Help ecto , ecto-query	16	4765	July 26, 2024
Ecto query of a JSONB column Questions / Help ecto-query	5	256	July 16, 2024
SQL to ecto: custom order by getting (Postgrex.Error) ERROR 42601 (syntax_error) syntax error at or near "AS" Questions / Help ecto-query , ecto	3	80	July 10, 2024
How to make a query in Ecto that checks if a Schema is related to another schema in a One to Many relationship Questions / Help learning-elixir , ecto-schema , ecto-query , ecto	2	157	July 4, 2024
Ecto query into Plain SQL Questions / Help ecto-query , ecto	11	5859	June 19, 2024
Selecting parent records based on state of latest child record Questions / Help ecto_sql , ecto-query , phoenix , ecto	5	255	June 2, 2024
Ecto Query preloading complex association Questions / Help ecto-query , preload , ecto	3	206	April 29, 2024
How to select_merge with fragment? Questions / Help ecto_sql , ecto-query	4	273	February 21, 2024
Composite - a library for writing dynamic queries Libraries ecto , ecto-query , dynamic-query	4	1415	February 19, 2024
Performance implications of Ecto within-query preloads with postgres Questions / Help ecto , performance , ecto-query	3	1683	July 10, 2020
Ecto get records where association count is 0 Questions / Help ecto , associations , ecto-query	7	2429	November 30, 2023
Interpolate Ecto.Enum in fragment/1 Questions / Help ecto , ecto-query	3	255	October 9, 2023
Best practices when writing context functions with DB queries Questions / Help ecto , ecto-query , phonenix	2	389	September 30, 2023
Tracking down slow queries in Ecto Questions / Help ecto , performance , monitoring , ecto-query	22	1748	September 22, 2023
How to prevent LIKE-injections Questions / Help ecto-query , ecto	16	4547	August 29, 2023
Ecto doesn't use index when performing a query but should Questions / Help ecto , index , ecto-query	5	720	August 4, 2023
Struggling with Ecto, distinct, and sum Questions / Help ecto , ecto-query	5	615	July 25, 2023
Ecto Query Returns unwanted data Questions / Help ecto , ecto-query	6	315	July 12, 2023
How to query for villas with bedroom air-conditioning? Questions / Help ecto , ecto_sql , ecto-query	1	348	July 7, 2023
Querying deeply nested associations Questions / Help ecto , ecto-query	4	695	June 29, 2023
Ecto query order for preload Questions / Help ecto-query , ecto	16	3439	June 28, 2023
Getting stuck on more complex Ecto queries: combining conditions, preloading and selecting Questions / Help ecto , ecto-query , preload	11	1093	June 18, 2023
Cachex fallbacks vs. Ecto Sandbox process ownership Questions / Help cachex , ecto-query	5	545	June 12, 2023
Pagination with scrivener, join and order by Questions / Help ecto , ecto-query	10	2807	May 8, 2023
Ecto: Custom sort order using a fragment and stored function Questions / Help ecto , ecto-query	0	391	May 5, 2023
Query with time_bucket Questions / Help ecto , ecto-query	2	470	May 4, 2023
Case insensitive order_by with dynamic field Questions / Help ecto-query , ecto	5	2717	April 6, 2023
Protocol Ecto.Queryable not implemented for Item of type List Questions / Help ecto , ecto-query	4	1006	March 10, 2023
Use of binary_id in Ecto.Query Questions / Help ecto , phoenix , ecto-query	8	2893	February 22, 2023