get values from firestore query

Question

I have this function:

 firestore.collection('customers').doc(userID).collection('subscriptions')
.where('status', 'in', ['trialing', 'active']).get()
  .then(activeSubscriptions => {


    // if this is true, the user has no active subscription.
    if (activeSubscriptions.empty === true) {
      console.log("line 31")
      {signOut(props.history)}
      subStatus = "inactive"
    } 
  });

Basically, in firestore, I have a customers collection, a doc with the user id, and then the subscriptions collection in which is created upon a user processing stripe. In the subscriptions collection, it has a doc which is the subscription id, and I have some fields I want to grab. See the attached picture:

I want to grab the current_period_end data so I can put it out on screen. how would I do this?

If you have only activeSubscriptions then you can use activeSubscriptions.data().current_period_end to get that data. — Supuna Warusawithana
– Supuna Warusawithana, Commented Apr 11, 2021 at 15:59
@suppa98 unfortunately that didn't work. any other suggestions? — Gianluca
– Gianluca, Commented Apr 11, 2021 at 19:13

Antonio Ramirez · Accepted Answer · 2021-05-26 22:39:24Z

1

If you are looking to access fields from a firestore document, you can do it by specifying the field in square brackets.

With a firestore structure like /customer/cus123/subscriptions/sub123 I was able to obtain a timestamp field of sub123 with this code:

let cusRef = db.collection('customer').doc('cus123').collection('subscriptions').doc('sub123');

cusRef.get()
.then(doc => {
  if (!doc.exists) {
    console.log('No such document!');
  } 
  else 
  {
    console.log('Name: ',doc.data()['name']);
    console.log('Tmsp: ',doc.data()['tmsp123']);
  }
});

I hope you find this useful.

answered May 26, 2021 at 22:39

Antonio Ramirez

1,0688 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

get values from firestore query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related