Terry Lee
Terry Lee
PostsComments
AEAsh Elixir
Created by Terry Lee on 7/15/2023 in #support
Full debug SQL
It was a noob question. Answer: set config :logger, truncate: :infinity
2 replies
AEAsh Elixir
Created by Terry Lee on 7/9/2023 in #support
How do you sort by substring?
Again, my Ash arsenal expands! Thank you! PS. I wanted to say, my first Ash-driven LiveView app went live last week. -> theweighin.sejutakg.my
4 replies
AEAsh Elixir
Created by Terry Lee on 5/24/2023 in #support
JsonB sorting within Resource.actions
Somehow the generated Sql ended up double casting 
[debug] QUERY OK source="qb_customers" db=968.5ms idle=1582.0ms
SELECT q0."id", .... FROM "qb_customers" AS q0 WHERE (q0."isproject"::boolean = $1::boolean) ORDER BY (q0."metadata"::jsonb #>> ARRAY['CreateTime'])::timestamp::timestamp DESC [true]
[debug] QUERY OK source="qb_customers" db=968.5ms idle=1582.0ms
SELECT q0."id", .... FROM "qb_customers" AS q0 WHERE (q0."isproject"::boolean = $1::boolean) ORDER BY (q0."metadata"::jsonb #>> ARRAY['CreateTime'])::timestamp::timestamp DESC [true]
See the double ::timestamp::timestamp at the back
16 replies
AEAsh Elixir
Created by Terry Lee on 5/24/2023 in #support
JsonB sorting within Resource.actions
thank you! works perfect!
16 replies
AEAsh Elixir
Created by Terry Lee on 5/24/2023 in #support
JsonB sorting within Resource.actions
How do you do in descending order with that?
16 replies
AEAsh Elixir
Created by Terry Lee on 5/21/2023 in #support
JSONB <=> Map fails on Array
My bad. I just found out I need a composite type. { :array, :map}
2 replies
AEAsh Elixir
Created by Terry Lee on 5/15/2023 in #support
Skip Migration for a Resource
Great! Thank you!
4 replies