How to display the desired field from the cursor (pymongo)?

Question

Python

I'm trying to organize the output of a field from a random collection document. This code compiles without errors, but I need to modify it so that a specific field is retrieved from list(cursor) and displayed. I read the documentation but couldn't find a solution, how to implement this?

@client.command()
async def one(ctx):
    db = cluster['dbname']
    collection = db['collname']
    cursor = db.collection.aggregate([{ "$sample" : {"size" : 1}}])
    doc = list(cursor)
    await ctx.send(f’Output: {doc}’)

I tried to implement a dictionary access through ["field_name"] after aggregation:

@client.command()
async def one(ctx):
    db = cluster['dbname']
    collection = db['collname']
    cursor = egeinf1.aggregate([{ "$sample" : {"size" : 1}}])["field_name"]
    await ctx.send(embed = discord.Embed(description = f"{cursor}"))

Gives an error: TypeError: 'CommandCursor' object is not subscriptable
I read a lot of articles, I still don't know how to fix it
Please help

Answer 1

Try this: https://docs.mongodb.com/manual/reference/operator...
In theory:

db.collection.aggregate([
    {"$sample": {"size": 1}},
    {"$project": {
        "_id": 0,
        "<field>": <1 или "$_id.<field>" (не знаю)>
    }}
])