This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
The task is to perform this SQL-query:
Entity.Attribute("field").Function("REGEXP", "pattern") produces "REGEXP(field, pattern)" which is fail to execute. Need equivalent notation to Entity.Attribute("field").Like("pattern") (maybe called .RLike), or more universal way to inject not only custom functions, but any binary operators. |
|
|
This is not currently possible via .Function(). Like has its own implementation which allows for it to craft the required SQL, I will have a look at something similar for REGEXP and get back to you.
|
|
|
We have now added a solution for this - there is now a new method available named CustomOperator when constructing a query expression to use a custom database operator (e.g. REGEXP as desired above). Here is an example usage:
This will be available in the next nightly build.
|
|
|
Works fine. Thank you very much. |
|