KReporter: Custom Function on Custom field

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?


You need to use {tc} for custom fields:
left({tc}.{f}, 4)

1 Like

Awesome! Thanks!

I want time difference between date_entered and date_created both are in different tables one. Kindly help me how can i get the difference using custom function.