URL filtering 2 dates in range

[PvN94]

Hi, I'm trying to filter a list via url where I want to show all records where one of two date fields is in a certain range. So I use this:

table___date1[value][]={begin}&
table___date1[value][]={end}&
table___date1[condition]=BETWEEN&
table___date1[join][]=OR&
table___date2[value][]={begin}&
table___date2[value][]={end}&
table___date2[condition]=BETWEEN&
table___date2[join][]=OR

But this gives an error. Removing the second join statement produces a list showing only the records where both dates are in range.
What am I doing wrong?

 

[PvN94]

Anyone?

 

[troester]

You can enable Fabrik debug (in Fabrik Options) and append &fabrikdebug=1 to your URL to check the generated query

 

[PvN94]

Finally got it working using this:

table___date1[value][]={begin}&
table___date1[value][]={end}&
table___date1[condition]=BETWEEN&
table___date1[join]=OR&
table___date2[value][]={begin}&
table___date2[value][]={end}&
table___date2[condition]=BETWEEN&
table___date2[join]=OR

Turns out it's just

[join]

instead of

[join][]

Though the latter is how it's explained in the wiki.

 

[cheesegrits]

Would you consider editing the wiki? A wiki is by definition a community effort.

-- hugh