Order by newest/oldest is made by entity_id not by created_at

[savlo]

Preconditions (*)

1. Magento Open Source 2.4.6 without sample data is installed.
2. Page Builder version 2.2.4

Steps to reproduce (*)

1. Create 2-3 product and alter their created_at to not be in the same order as their entity_id
2. Use the page builder products and set the sort by to Newest first or Oldest first

Expected result (*)

1. The products should be in the right older based on their created_at date/time

Actual result (*)

1. The products are ordered based on their entity_id

[m2-assistant]

Hi @savlo. Thank you for your report.
To speed up processing of this issue, make sure that you provided sufficient information.
Add a comment to assign the issue: @magento I am working on this

---

Join Magento Community Engineering Slack and ask your questions in #github channel.

[savlo]

@magento I am working on this

[m2-assistant]

Hi @savlo! 👋
Thank you for collaboration. Only members of Community Contributors Team are allowed to be assigned to the issue. Please use @magento add to contributors team command to join Contributors team.

[savlo]

@magento add to contributors team

[m2-assistant]

Hi @savlo! 👋
Thank you for joining. Please accept team invitation 👉 here 👈 and add your comment one more time.

[savlo]

@magento I am working on this

[savlo]

Might need some ideas into this, because I also see why it should be by entity_id, since it will make the sorting faster, and the entity_id should guarantee the order is correct, but since created_at can be altered by product interface, this might be an edge case