Filter Expression compound statement

[Segi]

Is it possible to create complex filter expressions that use compound conditions. I want to do something like this:

(Auths-ApprovalNeeded=1 AND Auths-ManagerApproval='') OR (Auths-ApprovalNeeded=0 AND Auths-FinalApproval='')

Clearly, you can't separate the conditions with parenthesis.

[Jon]

The documentation says that the expression:

- is valid syntax for FPL
- must evaluate to true or false
- can contain field or column names

It's a long time since I used FPL but I thought you could use brackets, you can certainly use AND and OR. You can certainly make the expression as complex as you like so long as it obeys the above rules.

[Segi]

Jon,

I don't normally use FPL as JavaScript is much more powerful. I tried using brackets but if you validate the FPL syntax when using brackets instead of parenthesis, the validator gives an error.

Now you've got me thinking that if Ebase could support Javascript filter expressions instead of FPL that would make it much more powerful