Filter list by url

gatticlaudio

Claudio
Hi all
I am needing to filter a list by url, using a field of type date (). More precisely I need to get the list of data for the current month.
some help?
Thank you.
 
After replacing "your_table___date_element" with your element's name (3 times), please try:
Code:
?your_table___date_element[value][]=first%20day%20of%20this%20month&your_table___date_element[value][]=now&your_table___date_element[condition]=BETWEEN&resetfilters=1
Because that should work -- according to Wiki and strtotime() relative dates.

Though, while other relative date expressions are working for me, on my site this particular "first day of this month"is throwing the error
DateTime::__construct(): Failed to parse time string (first 00:00:00 of this month) at position 0 (f): The timezone could not be found in the database
But the site where I tested isn't the lastest Fabrik version... so, maybe it's working for you.
 
Hello, I put as you say but it did not work.
Filters are not set.
I need it by url since it is a list containing a Form to filter by month. If I set a pre-filter, I can't find the rest of the data.
The month and year selector is a birthday type.
Below I send an image of the form.
Thank you.
upload_2021-2-5_11-43-4.png
 

Attachments

  • upload_2021-2-5_11-42-15.png
    upload_2021-2-5_11-42-15.png
    125 KB · Views: 47
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top