Skip to content
This repository was archived by the owner on Apr 12, 2025. It is now read-only.
This repository was archived by the owner on Apr 12, 2025. It is now read-only.

Smart Browse Field IsInfoOnly check not working correctly in Range Parameters #1

@GLescalona

Description

@GLescalona

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

Image

it finds results:

Image

Change DateOrdered to be InfoOnly:

Image

Reset Cache and try again, it won't find anything:

Image

Check a DateOrdered_To that if earlier than some data and it find it:

Image

What it should do:

It should find everything without filtering by DateOrdered

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions