javascript - Firestore orderBy Timestamp DESC - Stack Overflow

admin管理员组

文章数量:1344946

I'm trying to display the data from Firestore order by timestamp descending order, I follow the documentation but it seems that I did something wrong.

This is my try:

const outputSnapShot = {};

this.subscribe = firebase
  .firestore()
  .collection('orders')
  .where('restaurant_code', '==', this.state.restaurantCode)
  .orderBy('timestamp', 'desc')
  .onSnapshot((doc) => {
      doc.docs.map(function(documentSnapshot) {
        return (outputSnapShot[documentSnapshot.id] = documentSnapshot.data());
      });
      if (this._isMounted) {
        this.setState({ dataSource: Object.entries(outputSnapShot) });
      }
  }); 

the result from previous code is the data order by id ASC , Also I finish the INDEXING from Firebase console like so:

I'm trying to display the data from Firestore order by timestamp descending order, I follow the documentation but it seems that I did something wrong.

This is my try:

const outputSnapShot = {};

this.subscribe = firebase
  .firestore()
  .collection('orders')
  .where('restaurant_code', '==', this.state.restaurantCode)
  .orderBy('timestamp', 'desc')
  .onSnapshot((doc) => {
      doc.docs.map(function(documentSnapshot) {
        return (outputSnapShot[documentSnapshot.id] = documentSnapshot.data());
      });
      if (this._isMounted) {
        this.setState({ dataSource: Object.entries(outputSnapShot) });
      }
  }); 

the result from previous code is the data order by id ASC , Also I finish the INDEXING from Firebase console like so:

• javascript
• react-native
• sorting
• google-cloud-firestore

Share Improve this question Follow edited Feb 2 at 8:52 Dan Dascalescu 152k6565 gold badges333333 silver badges420420 bronze badges asked Jun 19, 2020 at 16:23 zippaxzippax 32433 gold badges55 silver badges1313 bronze badges 2

• Could you edit the question with the source data and specific results of the query that show they are in an order that you didn't expect? We should be able to duplicate the issue using what you show in the question. – Doug Stevenson Commented Jun 19, 2020 at 16:26
• Thanks for reply, the data and the result showing all data as I expected but it ordered by id number – zippax Commented Jun 19, 2020 at 16:33

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 8

With a help by my friend, we came with this solution and made the code work as we expected:

Going to share this:

this.subscribe = firebase
        .firestore()
        .collection('orders')
        .where('restaurant_code', '==', this.state.restaurantCode)
        .orderBy('timestamp', 'desc')
        .onSnapshot((docSnapshot) => {
            const dataSource = [];
            docSnapshot.forEach((doc) => {
                dataSource.push(doc.data());
            });
            if (this._isMounted) {
                this.setState({ dataSource });
            }
        });

I have faced the same problem, in my case the following way worked for me

 firebase.initializeApp(firebaseConfig);
 var db = firebase.firestore();


 var docRef = db.collection('Users').doc('001').collection('Data').orderBy("Date", "desc")
 ...

本文标签： javascriptFirestore orderBy Timestamp DESCStack Overflow