Bases 1.9.5 logical expressions causing

Steps to reproduce

With the 1.9.5 bases release, I am now getting Unable to parse formula: Unknown node type "LogicalExpression" in parsed formula errors for all of my logical OR and AND expressions, which were previously working, e.g. (formula.task_in_range || formula.event_in_range).

EXAMPLE:

filters:
  and:
    - 'if(formula.x, true, false)' # Change to 'true' to test 'Test' column.
formulas:
  x: '2 > 1' # ✅
             # ❌ '2 > 1 || 3 > 2'
             # ❌ '2 > 1 && 3 > 2'
             # ❌ 'if(2 > 1 || 3 > 2, true, false)'
             # ❌ 'if(2 > 1 && 3 > 2, true, false)'
             # ❌ 'if(2 > 1, true, false) || if(3 > 2, true, false)'
             # ❌ 'if(2 > 1, true, false) && if(3 > 2, true, false)'
             # ✅ 'if(2 > 1, if(3 > 2, true, false), false)' [Mimicks 'AND']
             # ✅ 'if(2 > 1, true, if(3 > 2, true, false))' [Mimicks 'OR']
properties:
  file.name:
    displayName: 'Title'
  formula.x:
    displayName: 'Test'
views:
  - type: table
    name: Test
    order:
      - file.name
      - formula.x

Did you follow the troubleshooting guide? [Y/N]

Y

Expected result

Logical expressions to work

Actual result

Logical expressions didn’t work

Environment

Edition	Windows 11 Home
Version	24H2
Installed on	‎18/‎02/‎2025
OS build	26100.4652
Experience	Windows Feature Experience Pack 1000.26100.128.0
1 Like

Will be fixed 1.9.6

1 Like

For anyone landing here that needs a temp workaround, in the interim I backed up all bases and then asked Claude Sonnet to "Convert ALL logical AND/OR expressions, e.g. a || b and a && b to deeply nested if() functions, e.g. if(a, true, if(b, true, false)) (for OR) and if(a, if(b, true, false), false) (for AND).

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.