when you stored many documents with that field having the same value, you violated your condition of uniqueness. now you need to decide what makes the documents you want back to be unique among others with the same value.
without this decision, it is hard to make a query. so please make one. (newest, oldest, likes, date, etc.). then the rest would possibly follow an aggregation of “distinct, lookup, sort, limit 1, unwind”. sorting is impossible without criteria.
2 Likes