Ufdjrw

Brothers & sisters

Can a virus destroy the BIOS of a modern computer?

Anagram holiday

Does a druid starting with a bow start with no arrows?

AES: Why is it a good practice to use only the first 16bytes of a hash for encryption?

Is it unprofessional to ask if a job posting on GlassDoor is real?

Is the Joker left-handed?

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

What killed these X2 caps?

Is it possible to run Internet Explorer on OS X El Capitan?

How much of data wrangling is a data scientist's job?

What is going on with Captain Marvel's blood colour?

How do conventional missiles fly?

Is it canonical bit space?

Fully-Firstable Anagram Sets

Why do bosons tend to occupy the same state?

Why are electrically insulating heatsinks so rare? Is it just cost?

Why was the shrinking from 8″ made only to 5.25″ and not smaller (4″ or less)?

Should I tell management that I intend to leave due to bad software development practices?

How can saying a song's name be a copyright violation?

What about the virus in 12 Monkeys?

What to put in ESTA if staying in US for a few days before going on to Canada

Were any external disk drives stacked vertically?

1960's book about a plague that kills all white people

Using ORDER_BY when using Ecto embeds_many

Making a field unique in ectoEcto embeds_many without idEcto, Phoenix: How to update a model with an embeds_many declaration?Phoenix/Ecto - changeset error when updating embeds_many recordQuery in Ecto embeds_many associationEcto query - order_by field in jsonb columnQuery with `embeds_many`order_by with dynamic value on EctoPreload with order_by from another table with EctoEcto: Dynamic order_by with count query on virtual field

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have an embeds_many field in my schema and it's saving the data assigned to it.

query =
 from m in Users,
 select: m.settings,
 where: m.id == ^user_id,
 order_by: fragment("settings::jsonb[]"), *incomplete*
 limit: 1

Comments has:

embedded_schema do
field :status, :integer, default: 0
field :user_settings, :map
timestamps()
end

I would like the order_by to make use of inserted_at to give me the order in which the comments were added into the db. I haven't experimented with this to see if an update resets the inserted_at to a new time, still. I need a way to get the latest comment first for some processing.

postgresql elixir ecto

share|improve this question

asked Mar 8 at 0:23

ChurchillChurchill

97732234

add a comment | 

0

I have an embeds_many field in my schema and it's saving the data assigned to it.

query =
 from m in Users,
 select: m.settings,
 where: m.id == ^user_id,
 order_by: fragment("settings::jsonb[]"), *incomplete*
 limit: 1

Comments has:

embedded_schema do
field :status, :integer, default: 0
field :user_settings, :map
timestamps()
end

I would like the order_by to make use of inserted_at to give me the order in which the comments were added into the db. I haven't experimented with this to see if an update resets the inserted_at to a new time, still. I need a way to get the latest comment first for some processing.

postgresql elixir ecto

share|improve this question

asked Mar 8 at 0:23

ChurchillChurchill

97732234

add a comment | 

I have an embeds_many field in my schema and it's saving the data assigned to it.

query =
 from m in Users,
 select: m.settings,
 where: m.id == ^user_id,
 order_by: fragment("settings::jsonb[]"), *incomplete*
 limit: 1

Comments has:

embedded_schema do
field :status, :integer, default: 0
field :user_settings, :map
timestamps()
end

I would like the order_by to make use of inserted_at to give me the order in which the comments were added into the db. I haven't experimented with this to see if an update resets the inserted_at to a new time, still. I need a way to get the latest comment first for some processing.

postgresql elixir ecto

share|improve this question

asked Mar 8 at 0:23

ChurchillChurchill

97732234

query =
 from m in Users,
 select: m.settings,
 where: m.id == ^user_id,
 order_by: fragment("settings::jsonb[]"), *incomplete*
 limit: 1

embedded_schema do
field :status, :integer, default: 0
field :user_settings, :map
timestamps()
end

share|improve this question

asked Mar 8 at 0:23

ChurchillChurchill

97732234

share|improve this question

asked Mar 8 at 0:23

ChurchillChurchill

97732234

asked Mar 8 at 0:23

ChurchillChurchill

97732234

asked Mar 8 at 0:23

ChurchillChurchill

97732234