Filtering repeating group by date

Hello everyone,
I am stuck on a situation where I need to filter RG by date and I am sending the date to the page URL and using Get data from page URL as a constraint in RG but it’s not working.

This is how my calendar look like :slight_smile:

Please guide me how I can overcome this situation.

Thanks in advance

Hi @jangidrahul0494

Edited
Try put a input element and put the get url value on the input. then on the constraint, get the value of that input.
if you don want display that input hide it somewhere or behind a group or elements and dont use the not visible feature it will not work

Thanks for reply but I am already using customizable calendar.
Can you suggest another way to filter?

try to do the filter where date formatted as and then use the same formatting you’re passing to the url … then it will be text vs text comparison

@basel.3adel I tried it but it didn’t work😐

can you share a screenshot?

Here is the workflow:


and here is the repeating group:

1- Can you inspect any element that is getting q from url?
I think you need to avoid using “/” in the url
2- Is available from and till are actually a text fields in your db?
3- Do you actually want to use filtering? or do search for?

2- Is available from and till are actually a text fields in your db? Yes they are text fields in DB
3- Do you actually want to use filtering? or do search for? I just want the items to be filtered in anyway, it’s the 3rd day I am stuck on this issue

1- Can you inspect any element that is getting q from url? Here is the screenshot : Screenshot by Lightshot

To debug the issue more,
If it’s already a text, can you try available from = get q from page url and remove the till(text) constrain?

Tried something new and getting 90% accurate answer.
Thank you so much @basel.3adel for your guidance

No worries! :pray:
You can actually change the datatype in the database to a date which will 100% because you will then be able to do greater than and less than operations if you want to do a date range

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.