i have data structured in firestore like this

users (collection)
  --> uid (document)
      --> profile (map field)
         --> status (field)

I want to query the data that matches to a value of status “Active” and wrote like below:

 const appColRef = db.collection("users"); 
 const querySnapshot = await appColRef.where("status", '=', 'Active').get()

above does not work and would work if status is at the same level at profile. so is there a way to query the status field inside profile map field.