editor.where the filename doesn't seem to allow formulas

alexandr.yul

Looking at https://editor.datatables.net/manual/php/conditions#Complex-usage, all the document and support examples use the entire field name in the first argument. What if I want to use only part of the field name?

Example:
A date field in which I want to compare just the year portion to a value,
LEFT(expenses.exp_dt, 4) = "2017"
or YEAR(expenses.exp_dt) = "2017"

Any ideas?

allan

This should do it:

    ->where( function ($q) {
        $q->where( 'YEAR(expenses.exp_dt)', '2017' );
    } )

It isn't explicit documented that you do that yet, as I'm still working on aspects of functions in the first parameter, but that one will work no problem (just tested locally).

Allan