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
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
Everything looks fine, it’s all set up properly
But it’s not showing anything whenever I click on the repeating group. Could I be missing a step?
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.
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?
And exactly how would I filter between 12am - 11:59pm, I don’t know how.
Read about date operators to understand my post in terms of manipulating the date
Anyone else want to help me solve this issue?
Okay I will take a look
This topic was automatically closed after 70 days. New replies are no longer allowed.