`where` condition isn't working properly

SQL++
1

Hello,

could someone help me with the query in order to get the max value or extract a list?

If the customer is participating, I’m saving to his document next object:

"lottery": {
    "activeLottery": 0,
    "lotteryInfoMap": {
      "58": {
        "id": 58,
        "currentLotteryTickets": 0,
        "reward": 0,
        "winPosition": 0,
        "collectedAt": 1656237645324
      }
    }
  }

Question:

how I can extract all participants where ID = 58 (I mean lottery → lotteryInfoMap → 58 → id = 58)+ in the extract list I need to see the currentLotteryTickets and winPosition

Thank you

2 
SELECT b.*
FROM mybucket AS b
WHERE ANY k:v IN b.lottery.lotteryInfoMap SATISFIES v.id = 58 END;

OR

SELECT u.*
FROM mybucket AS b
UNNEST OBJECT_VALUES(b.lottery.lotteryInfoMap) AS u
WHERE u.id = 58;