0
201
ViewsHow to get Per Month data from firestore with JS
I want to get the Per month Water data from firestore for all the documents i try but nothing work i think i can get data by the help of timestamp and water field which are present in my database can anyone help me with it.
This is my database.
I try this from the last answer but nothing is showing in console
const cloudDb = app.firestore();
var time="1638297000"
var lasttime="1640845799"
cloudDb.collection('AKVO_RND')
.where('timestamp', '>=', time)
.where('timestamp', '<=', lasttime )
.orderBy('timestamp', 'desc')
.get().then(function(querySnapshot){
querySnapshot.forEach(function(doc){
water= (doc.data().water)
console.log(water);
})
})
·
Juan Pablo Isaza
1 answers
Answer question0
You can make query something like this with help of firebase functions:
firestore().collection('AKVO_RND')
.where('timestamp', '>=', time)
.where('timestamp', '<=', lastdate)
.orderBy('timestamp', 'desc')
.get();
Make sure of using runTimeOptions. It will allow your function to run more time than recommended time
·
Juan Pablo Isaza
Report
Answer question