ParamQuery grid support forum

General Category => Help for ParamQuery Grid (free version) => Topic started by: kjvjung on June 10, 2017, 08:02:18 pm

Title: filter problem - multi query : left outer join or alias table question.
Post by: kjvjung on June 10, 2017, 08:02:18 pm

hi.

--- remote.php --------------------------------------

    $sql = "Select OrderID, left(CustomerName, 4) as CustomerName4  from invoices ".
            $where.
            " order by OrderID limit ".$skip." , ".$pq_rPP;

--- index.php -----------------------

        var colM = [
            { title: "Order ID", width: 100, dataIndx: "OrderID" },           
            { title: "Customer Name4", width: 130, dataIndx: "CustomerName4" }
        ];

.....
.....

        $("<select id='pq-filter-select-column'>\
        <option value='OrderID'>Order ID</option>\
        <option value='left(CustomerName, 4)'>Customer Name4</option>\
        </select>").appendTo($toolbar)
           .change(function () {
            pqFilter.search();
        });
        $("<span class='pq-separator'></span>").appendTo($toolbar);

-----------------------------------------
result : left(CustomerName, 4)   filter error.
Likewise, left outer join error. 


how changed coding?

thank you.