Filtering a RG by date using get URL

recker249 · 2024-10-14T00:24:15.650Z

Does anyone know, how I can filter a repeating group by date using get URL? Please check the photos, I have been looking through the forums but no answer has satisfied me yet. Please also check the link: Toasty

Screenshot 2024-10-13 at 8.20.40 PM1067×709 47.6 KB

Screenshot 2024-10-13 at 8.20.56 PM719×808 61.3 KB

Screenshot 2024-10-13 at 8.21.06 PM733×809 57.3 KB

Screenshot 2024-10-13 at 8.21.46 PM1221×777 111 KB

geesonofgee · 2024-10-14T08:49:00.563Z

Hi @recker249 ,
Since you have this “upcoming session” tap in a the same page?
why not try displaying the date in the RG directly instead of sending it to a url and then fetching it again from the url as reference for the RG

boston85719 · 2024-10-14T09:33:06.779Z

Everything looks fine, it’s all set up properly

recker249 · 2024-10-14T14:26:03.834Z

But it’s not showing anything whenever I click on the repeating group. Could I be missing a step?

boston85719 · 2024-10-14T14:37:29.867Z

Your constraint is using the equals sign, which would mean, the values in DB need to be exactly, down to the millisecond the same as the current date/time.

If you want to show matches based on the date, as in a single day from 12AM to 11:59PM, you can take the URL value and then use operators to manipulate it, or extract values from it, so maybe manipulate it so you can have some like two constraints, one for using the greater than or equal to sign and the other for the less than or equal to sign.

Your data field is the constraint, followed by the greater than or equal to sign, then value is get data from URL (as you have it) but add operators to change the hour value to 12AM. Then another constraint for the less than or equal to sign and again use operators after the get data from URL to manipulate the hour value to 11:59:59 (11th hour, 59th minute 59th second)

There may be some other operators that could be round down to day or something like that to get to the 12AM value.

recker249 · 2024-10-15T13:45:21.357Z

Toastly

I think I am getting close to the result I want, but I am not quite their yet. I tried both options. The first picture is giving me a result that close to what I want, but I want it filtered between 12am - 11:59pm. The 2nd picture is not giving me any results.

Anymore Ideas? How would I go about doing this?

Screenshot 2024-10-15 at 9.41.49 AM

Screenshot 2024-10-15 at 9.42.56 AM358×526 26.9 KB

recker249 · 2024-10-15T13:53:58.737Z

And exactly how would I filter between 12am - 11:59pm, I don’t know how.

boston85719 · 2024-10-15T14:17:16.293Z

Read about date operators to understand my post in terms of manipulating the date

recker249 · 2024-10-23T23:27:58.965Z

Anyone else want to help me solve this issue?

recker249 · 2024-10-24T00:00:04.763Z

Okay I will take a look

system · 2024-12-23T00:24:18.693Z

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