Buy Now
Sign in

Filter Date range

Elitakey , January 27 2021, 14:36
E
Elitakey 333
January 27 2021, 14:36 #395767
Hi, struggling with the right syntax for Filter that would use two datepicker fields and returns filtered data for Connectivity6 table:
1st datepicker name - fromFilter
2nd datepicker name - toFilter
what should be the right PHP code for Read_data function
if this code works for those fields separately?
if (!empty($fromFilter)) {
echo 'Submission.izpildes_datums/>=:{data:fromFilter}';
}
?>
if (!empty($toFilter)) {
echo 'Submission.izpildes_datums/<=:{data:toFilter}';
}
?>
What is the right synatx for AND operator in PHP Rules list for data_read function?
Or how can I build the WHERE condition using CCv6 built-in Conditions and Operators considering that I need to check if field is not empty and ONLY if it is not empty proceed with where function?
Thanks!
Firstly I need the solution for CCv6, however it would be good to know if there are differences between CCv6 and CF7 in this.
Thanks for reading this and many thanks for the solution -
Elita
P.S. Sorry for the wrong tag; it should be Connectivity6 and Chronoforms7
E
Elitakey 333
January 27 2021, 15:02 #395768
Its crazy, but I figured it out -
echo
(
'Submission.izpildes_datums/>=:{data:fromFilter}
AND
Submission.izpildes_datums/<=:{data:toFilter}'
)
exactly how it is written - with AND and parentheses in separate lines. And WITHOUT curly braces!
E
Elitakey 333
January 27 2021, 15:30 #395770
After couple of hours try and trial I have figured out the code above;
What if I needded to add third field?!?!?!? What would the code looked like?
if (!empty($noFilter)&&($lidzFilter))
echo
(
'Submission.izpildes_datums/>=:{data:noFilter}
AND
Submission.izpildes_datums/<=:{data:lidzFilter}'
)
AND
else if (!empty($atbildigaisFilter))
echo
'Submission.atbildgais_uzdevums/like:%{data:atbildigaisFilter}%'
seems not to be working... got an error SYNTAX ERROR, UNEXPECTED 'ELSE' (T_ELSE)