if a field with check "Range" is also IsInfoOnly the "_To" field generated is not marked as IsInfoOnly causing the Search to use it as a WHERE parameter as if it was the original field and the next query parameter will be evaluated as the "_To" field.
Example: if i enter a DateOrdered Range of '01/01/2025' To '31/01/2025' and a specific Business Partner it should only filter by Business Partner because the Date is InfoOnly and the SQL should look like this:
"AND C_Bpartner_ID = 1000001"
However it Generates:
"DateOrdered_To >= '31/01/2025' AND C_Bpartner_ID <= 1000001"
Steps to reproduce:
In any Smart Browse that uses a Range of date as a query criteria like Generate Invoice from Order Line check a range of date that gives results and the Date To make it in the future
it finds results:
Change DateOrdered to be InfoOnly:
Reset Cache and try again, it won't find anything:
Check a DateOrdered_To that if earlier than some data and it find it:
What it should do:
It should find everything without filtering by DateOrdered
if a field with check "Range" is also IsInfoOnly the "_To" field generated is not marked as IsInfoOnly causing the Search to use it as a WHERE parameter as if it was the original field and the next query parameter will be evaluated as the "_To" field.
Example: if i enter a DateOrdered Range of '01/01/2025' To '31/01/2025' and a specific Business Partner it should only filter by Business Partner because the Date is InfoOnly and the SQL should look like this:
"AND C_Bpartner_ID = 1000001"
However it Generates:
"DateOrdered_To >= '31/01/2025' AND C_Bpartner_ID <= 1000001"
Steps to reproduce:
In any Smart Browse that uses a Range of date as a query criteria like Generate Invoice from Order Line check a range of date that gives results and the Date To make it in the future
it finds results:
Change DateOrdered to be InfoOnly:
Reset Cache and try again, it won't find anything:
Check a DateOrdered_To that if earlier than some data and it find it:
What it should do:
It should find everything without filtering by DateOrdered