Elasticsearch pinned query MongoDB equivalent exists?

[Pavel_Duchovny]

Hi @Mateusz_Spiewak ,

First maybe you can use 2 quaries in a $unionWith aggregation, first for the featured movies and second for the other search:

$unionWith (aggregation) — MongoDB Manual

Now to get items by an array order you can see an aggregation I helped with here :

Sort the mongo db collection based on values

I have a mongo db collection as described below: ({ ‘name’ : ‘rohan’, ‘dept’: ‘cse’ } , { ‘name’ : ‘aakash’, ‘dept’: ‘mech’ }, { ‘name’ : ‘kiara’, ‘dept’: ‘cse’ } ) Query: I have a list x = [mech, cse] which means that I want to see all dept=mech first and then cse and so on. How can I sort my collection based on the values ? Output: My collection should look like: ({ ‘name’ : ‘aakash’, ‘dept’: ‘mech’ }, { ‘name’ : ‘rohan’, ‘dept’: ‘cse’ } , { ‘name’ : ‘kiara’, ‘dept’: ‘cse’ } )

The second union part sort by title in its pipeline.

Let me know if that makes sense.

Thanks
Pavel