+5Hello Community,
We have a complex data model in which the user must set three date filters (different source fields)Β withΒ the same date in order to get the desired result.
Like I said, he has to do it three times.
Is there a convenient solution (data picker) where the user only has to set the date filter once, and the filter is applied to all three source fields?
Best, Thomas
Β
Best answer by abhishek.chatu14
I think the cleanest approach would be to use a single Date Picker or Date Range component and store the userβs selection in variables. We can then reference those variables in the PQL filter logic across all three date fields.
The typical setup would be:
One Date Picker/Date Range component in the View
Store the selected values in variables such as start_date and end_date
Apply a custom filter condition that checks all three date columns against those variables
For example:
FILTER
"table"."date_1" >= {t ${start_date}}
AND "table"."date_1" <= {t ${end_date}}
AND
"table"."date_2" >= {t ${start_date}}
AND "table"."date_2" <= {t ${end_date}}
AND
"table"."date_3" >= {t ${start_date}}
AND "table"."date_3" <= {t ${end_date}}
This should allow one date selection to drive the filtering for all three date fields, rather than having separate date filters for each column.
+8I think the cleanest approach would be to use a single Date Picker or Date Range component and store the userβs selection in variables. We can then reference those variables in the PQL filter logic across all three date fields.
The typical setup would be:
One Date Picker/Date Range component in the View
Store the selected values in variables such as start_date and end_date
Apply a custom filter condition that checks all three date columns against those variables
For example:
FILTER
"table"."date_1" >= {t ${start_date}}
AND "table"."date_1" <= {t ${end_date}}
AND
"table"."date_2" >= {t ${start_date}}
AND "table"."date_2" <= {t ${end_date}}
AND
"table"."date_3" >= {t ${start_date}}
AND "table"."date_3" <= {t ${end_date}}
This should allow one date selection to drive the filtering for all three date fields, rather than having separate date filters for each column.
+5β
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.