Evaluate expression in pre-filter

Hi

In ‘Field settings’ > ‘Prefilter records’ I was hoping to use this expression:

level = ${record.values.level} - 1

But the subtraction doesn’t get evaluated and ‘level = 2 - 1’ gets sent to the server in the query.

How to evaluate or is this not possible?

Thanks

Russ

Hi @russ0ne

I’m assuming that you are filtering on a record selector field?

If so, here is the reference in the docs, which should help troubleshoot your logic. Query Language :: Corteza Docs

Regards,
Mark

1 Like