I'm building a complex filter. How do I test a wo...
# 🤝help
w
want to do something like: $or: [{ Ledger: { $eq: workflow.ledger } }, { workflow.ledger $eq: false } ] Table has field: Ledger Thanks for any help
r
@worried-queen-393 only table columns can be used in the table filter expression. You could have two queries for whether workflow.ledger is false or true: eg.
Copy code
rows = await  MyTable.findRows({
filter: workflow.ledger ? { Ledger: workflow.ledger} : {}
})
w
Brilliant! I'll try that tonight... Thank you