Filter RecyclerView by date from datepicker- Android Studio

Question

Revisied Qustion:

[Firestore database structure screenshot][2]

Mr.Alex,

#1. Indexing done via Logcat

#2. date format is

 '2021-08-20 15:25:34.888 30176-30176/com.kasthu.prkeng D/TAG: Date is: Fri Aug 20 05:30:00 GMT+05:30 2021'

and my Firestore Timestamp format is

Firestore Timestamp format

Note: date is in "GMT" format and Timestamp is in "UTC" format--kindly advise on this and my simplified code code is -i am using "FirestoreRecyclerAdapter"

'FirestoreRecyclerOptions<model> options = new FirestoreRecyclerOptions.Builder<model>() 
.setQuery(df.orderBy("FullName", Query.Direction.ASCENDING) 
.whereEqualTo("TimeIn", date), model.class)
.build(); 
adapter = new fsattadapter(options); 
review.setAdapter(adapter);

if i include whereEqualTo("TimeIn", date) in query, Recyclerview doesn't show anything.Kindly advise

Please edit your question and add your database structure as a screenshot. — Alex Mamo, Aug 19 '21 at 06:20
Greetings Mr.Alex, i have attached Database structure .thank you — Elamurugan OG, Aug 19 '21 at 07:10
What's the value of `date` inside your query? Can you log it? — Alex Mamo, Aug 19 '21 at 07:29
2021-08-19 15:47:43.881 19468-19468/com.kasthu.prkeng D/TAG: Date is15-08-2021 — Elamurugan OG, Aug 19 '21 at 10:22
So the value of `date` inside `.whereEqualTo("TimeIn",date)` is **15-08-2021**, right? — Alex Mamo, Aug 19 '21 at 10:32
i think we are required to update recycler adapter everytime while the date changes. — Elamurugan OG, Aug 19 '21 at 10:37

score 0 · Accepted Answer · answered Aug 19 '21 at 10:55

0

There is a possibility for the existence of several problems in your code, but I found the two major ones.

The problems is that the following query:

 df.orderBy("FullName", Query.Direction.ASCENDING)
      .whereEqualTo("TimeIn",date)

Requires an index. Even if you create the corresponding index, the query will not work because you pass to the .whereEqualTo() method a date which is in String format (15-08-2021), while in the database is a Firestore timestamp. So you cannot use a String when querying the database instead of a Timestamp and expect to behave correctly. To solve this, you should pass instead of a String a Date object and your query will work perfectly fine.

answered Aug 19 '21 at 10:55

Alex Mamo

130,605
17
163
193

ok, Thank you so much, i try to rectify it – Elamurugan OG Aug 19 '21 at 11:01
Cool. Give it a try and tell me if it works ;) – Alex Mamo Aug 19 '21 at 11:01
Mr.Alex i have tried and simplified my code and i updated my question.kindly have a look – Elamurugan OG Aug 20 '21 at 10:35
To be able to get the desired result, the `date` object should contain the exact same value it exists in the database and in the same format. Otherwise, it won't work. – Alex Mamo Aug 20 '21 at 11:05
Thanks Mr.Alex for yor valuable input...✔️ done – Elamurugan OG Aug 20 '21 at 13:02

score 0 · Answer 2 · answered Aug 20 '21 at 02:58

i thing your filtering criteria is not working,


df.orderBy("FullName", Query.Direction.ASCENDING)
                               .whereEqualTo("TimeIn",edDatePick.getText().toString)
                                .get()                               
                            .addOnSuccessListener(newOnSuccessListener<QuerySnapshot>() {

score 0 · Answer 3 · answered Aug 21 '21 at 05:38

Hey Finaly i solved this filtering by date. But by storing Date as string in firestore as additional field.

 TVdatepick.addTextChangedListener(new TextWatcher() {
        @Override
        public void beforeTextChanged(CharSequence s, int start, int count, int after) {

        }

        @Override
        public void onTextChanged(CharSequence s, int start, int before, int count) {

        }

        @Override
        public void afterTextChanged(Editable s) {

            filter(s.toString());
        }
 private void filter(String text)
{
    List<model> filteredList = new ArrayList<>();

    for (model item : datalist) {
        if (item.getPunchDate().toLowerCase().contains(text.toLowerCase())) {
            filteredList.add(item);
        }
    }

    adapter.filterList(filteredList);
}

Adapter class:

  public void filterList(List<model> filteredList) {
    this.datalist=filteredList;
    notifyDataSetChanged();
}

Filter RecyclerView by date from datepicker- Android Studio

3 Answers3