Hello,
Im working with invoices and Ive implemented a datepicker with different options: Due date, clearing date, etc.
If I want to filter by different dates, the attribute selection makes an AND operation between conditions. I would like to know if there is the option to have an OR condition.
E.g. I want to filter the invoices with clearing date OR due date in September, meaning that I want to include also invoices with only one of those conditions true.
Im working with invoices and Ive implemented a datepicker with different options: Due date, clearing date, etc.
If I want to filter by different dates, the attribute selection makes an AND operation between conditions. I would like to know if there is the option to have an OR condition.
E.g. I want to filter the invoices with clearing date OR due date in September, meaning that I want to include also invoices with only one of those conditions true.
Page 1 / 1
Hi @Alejandro,
thank you for reaching out and welcome to our community!
Could you please share your PQL Statement. This would make it easier to understand your use case and also it helps to fix the issue properly.
Best,
Justin
thank you for reaching out and welcome to our community!
Could you please share your PQL Statement. This would make it easier to understand your use case and also it helps to fix the issue properly.
Best,
Justin
Hi @j.stegmaier,
my question is related to the component date picker in the user interface, so there is no PQL statement. When a user selects different dates the filter is aggregated to the total number of cases of this analysis. The result of multiple filters is always that the number of cases selected have ALL the conditions true (AND logic) and it would be interesting to have cases selected where at least one of the conditions is true (OR logic)
Thanks
Alejandro
my question is related to the component date picker in the user interface, so there is no PQL statement. When a user selects different dates the filter is aggregated to the total number of cases of this analysis. The result of multiple filters is always that the number of cases selected have ALL the conditions true (AND logic) and it would be interesting to have cases selected where at least one of the conditions is true (OR logic)
Thanks
Alejandro
Hi Alejandro,
I think you can only resolve this using a filter statement (on a analysis, sheet or object level). You can find out how to use the OR operator in filters at the documentation page.
I hope this will help you.
Best regards,
Jan-peter
I think you can only resolve this using a filter statement (on a analysis, sheet or object level). You can find out how to use the OR operator in filters at the documentation page.
I hope this will help you.
Best regards,
Jan-peter
Hi @j.stegmaier,
my question is related to the component date picker in the user interface, so there is no PQL statement. When a user selects different dates the filter is aggregated to the total number of cases of this analysis. The result of multiple filters is always that the number of cases selected have ALL the conditions true (AND logic) and it would be interesting to have cases selected where at least one of the conditions is true (OR logic)
Thanks
Alejandro
my question is related to the component date picker in the user interface, so there is no PQL statement. When a user selects different dates the filter is aggregated to the total number of cases of this analysis. The result of multiple filters is always that the number of cases selected have ALL the conditions true (AND logic) and it would be interesting to have cases selected where at least one of the conditions is true (OR logic)
Thanks
Alejandro
Hi Alejandro,
I am in a similar situation as you have explained. It would be great if you could share us if there was any solution found for this question? Thanks in advance!
Hi Alejandro,
I am in a similar situation as you have explained. It would be great if you could share us if there was any solution found for this question? Thanks in advance!
Hi Pavan,
unfortunately it's not possible with the date picker. However, you may have the same outcome using variable input and filters with variables, although you need to write the dates manually
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.