How to write the following in OQL? select REPLACE(actual_label, 'Unmapped_', '') actual_label, count(*) from… Note the REPLACE() function is sql server. Does OQL have something similar? Or is there an alternative?
I think you can use CASE for this scenario: https://docs.mendix.com/refguide/oql-case-expression