I want to use a left() function on a dropdown field content in the Invoices module, which I’ve created via studio. KReporter allows for sql statements to be added via the “CustomFunction” column. This code works on non-custom fields, but seems not to work on custom fields:
left({t}.{f}, 4)
I assume that’s because the custom field is located in the custom table invoices_cstm.
How can I access a custom field via the “CustomFunction” column in KReporter?