Promoting one of the documents on top

[Can_Uysal]

I have a similar goal to this question, which is closed.

Sort element with property: true to the top, but only one out of many

My app can search through a database of resources using MongoDB’s aggregation pipeline. Some of these documents have the property sponsored: true. I want to move exactly one of these sponsored entries to the top of the search results, but keep natural ordering up for the remaining ones (no matter if sponsored or not). Below is my code. My idea was to make use of addFields but change the logic so that it only applies to the first element that meets the condition. Is this possible? [...] const…

example document:
{
…
sponsor: true
…
}

Other fields of the document doesnt matter. I’m currently doing a complex aggregation pipeline with match, sort, facet, project and other stages. What I would like to do is pick only 1 random document from the results that has sponsored field, place it on top of the results, and leave the rest of the results intact without altering the query and sort.

I can’t do this after the aggregation because I’m paginating, and one of the sponsored documents might be on the other pages. Even if it’s one the third page, I want it to be on the first result. Is this possible?

Mongodb version: Latest atlas

[Can_Uysal]

I solved it by adding another facet stage, just the like OP I mentioned in the question.

"example_field_in_facet": [
                    {
                        "$match": {
                            "tier": {
                                "$gte": 300
                            }
                        }
                    },
                  {
                         $limit: 1
                  }
]

However, as OP said, this results in inaccurate pagination. I can just change the numbers in the pages and let them be 1-11, 1-9 etc, but if there is a way to make this organically, please let me know.