Question 120537 in Firebase Question posted in
An extensive official documentation can be found here.

How to Query By Firebase Timestamp (from – to)?

i want to query my data by time stamp

let date = new Date();
var today = new Date();
var yesterday = date.setDate(today.getDate() - 1);
console.log(date)
const dataTable = collection(db, 'sales')
let mquery = query(dataTable, where('createdDate', "<", yesterday))
const qSnap = await getDocs(mquery)
console.log(qSnap)

error : Uncaught (in promise) FirebaseError: Expected type ‘mc’, but it was: a custom xh object

Tags:

2

Answers


  1. 0

    You should use the query function and create Query instance.

    import {query} from "firebase/firestore";

let mquery = query(dataTable, where('createdDate', "<", yesterday))
const qSnap = await getDocs(mquery)

    Documentations to refer to:

    Login or Signup to reply.
  2. 0

    The error that you encountered was produced by not using the query() method as pointed out by @AyseAsude. Now, after fixing the query, you should also convert the variable yesterday into a date format and iterate the items from the query. See code below:

    let date = new Date();
var today = new Date();
var yesterday = new Date(date.setDate(today.getDate() - 1));

const dataTable = collection(db, 'sales')
let mquery = query(dataTable, where('createdDate', "<", yesterday))
const qSnap = await getDocs(mquery)

qSnap.forEach((doc) => {
  // doc.data() is never undefined for query doc snapshots
  console.log(doc.id, " => ", doc.data());
});

    For more information, you check out this documentation.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search