Why doesn't in work with more than one criteria or'd

Jay Dee

Description of problem:
I am constructing a filter on the example page to select those in the London office under 40 and all those in the Tokyo office
I expect to see only records for London or Tokyo offices and
I expect to see London office records be for persons with age less than 40.
What I get is records for Tokyo, London, San Francisco, New York, Edinburgh, and San Francisco
And ages of Londoners of 47, 41, and 38
I am asking whether I misunderstand how to build a custom search or whether this is well and truley broken because I added it to a piece of my code and it really didn't bring back the results I was expecting.
Building the example up on the page at https://datatables.net/extensions/searchbuilder/examples/api/rebuild

Office equals London gives 12 records, only London
Age less than 40 - gives 6 records for Londoners under 40
I indent the Age condition so that it is and'ed with the London office condition AND with the new condition
I change the outer And to an Or
It changes to 31 records AND the Londoners are no longer constrained to under 40.
Getting Details gives:

{
    "criteria": [
        {
            "condition": "=",
            "data": "Office",
            "type": "string",
            "value": [
                "London"
            ]
        },
        {
            "criteria": [
                {
                    "condition": "<",
                    "data": "Age",
                    "type": "num",
                    "value": [
                        "40"
                    ]
                }
            ],
            "logic": "AND"
        },
        {
            "condition": "=",
            "data": "Office",
            "type": "string",
            "value": [
                "Tokyo"
            ]
        }
    ],
    "logic": "OR"
}

allan

It looks like your logic nesting isn't quite right there. This appears to work for me:

{
    "criteria": [
        {
            "criteria": [
                {
                    "condition": "=",
                    "data": "Office",
                    "type": "string",
                    "value": [
                        "London"
                    ]
                },
                {
                    "condition": "<",
                    "data": "Age",
                    "type": "num",
                    "value": [
                        "40"
                    ]
                }
            ],
            "logic": "AND"
        },
        {
            "condition": "=",
            "data": "Office",
            "type": "string",
            "value": [
                "Tokyo"
            ]
        }
    ],
    "logic": "OR"
}

Allan

Jay Dee

Thank you so much! Seeing it I can see the logic is what I was trying for... Could not find a documentation page on this site, though there is a manual I consulted.