get random results from service or entities (Medusa V2)

[docloulou]

Hello,
Is it possible to get random results from query graph or service module without fetching ALL results and sort ... ?
For example, get 10 random products...
Thanks

[srindom]

What are you looking to achieve?

[docloulou]

On the front: Let’s say I want to display 10 random products (with or without filters) before placing the order. The section would be called: "Have You Thought About This?"

I want to optimize the query by selecting only the 10 random products directly "at the SQL level", without fetching and sorting all products on the application side.

[docloulou]

i want something like that:

const query = req.scope.resolve(ContainerRegistrationKeys.QUERY);

const { data: products } = await query.graph({
  entity: "product",
  fields: ["id", "title"],
  pagination: {
    limit: 10,
    order: {
      $random: true
    },
  },
});

[damianr13]

This feature would be useful for me as well