Is there a way in version 1.0.2005.1 to call a custom db function in a predicate expression?

I saw that this exists in version 2, but it looks like upgrading now is going to cost a lot more time that what I have to spend right now. (Always in a time crunch it seems )

I also saw the custom templates but those appear to be used in version 2 as well.

We have some CTEs in SQL2005 and I really need to be able to use that CTE in an expression.

jyoung wrote:

Is there a way in version 1.0.2005.1 to call a custom db function in a predicate expression?

Well, v2.0's code is based on 1.0.2005.1 code, so with enough effort, there is a way .

I saw that this exists in version 2, but it looks like upgrading now is going to cost a lot more time that what I have to spend right now. (Always in a time crunch it seems )

I also saw the custom templates but those appear to be used in version 2 as well.

We have some CTEs in SQL2005 and I really need to be able to use that CTE in an expression.

In short DBFunctionCall is an Expression subclass so it can appear in an Expression normally like any other expression element. The biggest hurdle you've to take is in adapter, where you've to inject the persistence info into the fields used in the dbfunctioncall.