Will:

So the original SQL I submitted is the same as in your last message – the only change you suggested is to flip the formatter option to true in the setSelect statement – is that correct?

When I made those changes the CustomerFullName and Status columns in the grid are blank (looking at the rendered HTML they contain a non-breaking space  ). When I do a search I do get the drop-down list as I expect, but the search never finds any records.

I checked the Developer’s console for Chrome – the response to the AJAX query for main.php has all of the data in it:

{“records”:5,”page”:1,”total”:1,”rows”:[{“ID”:2,”CustomerFullName”:”Ginger Grant”,”Status”:”Active”},{“ID”:1,”CustomerFullName”:”Jonas Grumby”,”Status”:”Archived”},{“ID”:3,”CustomerFullName”:”Lovey Howell”,”Status”:”Inactive”},{“ID”:5,”CustomerFullName”:”Roy Hinkley”,”Status”:”Active”},{“ID”:4,”CustomerFullName”:”Thurston Howell III”,”Status”:”Active”}]}

I can’t figure out why I am seeing   in those two columns.

Ken

• This reply was modified 5 months ago by kgrogers. Reason: Added additional information

When I do that I no longer see the text values in the gird from the foreign table, I only get the IDs, and when I do a search I get no dropdown list.

Ken

Oh, I see – The ContactDate field in the pivot table is just text, so that’s why the ‘between’ oper didn’t work.  I changed the oper to ‘bw’ (begins with) and pass the year from the drop-down and it works perfectly.

All done!  Thanks again for your help.

Ken

• This reply was modified 8 months, 2 weeks ago by kgrogers. Reason: figured out the problem with using the search operator 'bt'

I did see that in your original reply.

I did some testing and it turns out that all of the things I want to filter on aren’t actually in the pivot data – when I initially wrote this I didn’t realize that the initial data was a one-shot thing.

Thanks for the help – I need to go back to the drawing board and come up with a different method to accomplish what I have in mind.

Ken

Hi Will:

I guess I should have been more specific – and perhaps I posted in the wrong forum too.

I have a PHP pivotGrid that I want to add filtering to, if that’s possible.

Here is my code:

index.php

<?php include(“leaderboard.php”); ?> </body> </html>

leaderboard.php

• This reply was modified 8 months, 3 weeks ago by kgrogers.

(For some reason the Code icon is missing from this compose window – sorry in advance for the ugly code block).

I made the changes you suggested:
<p style=”padding-left: 40px;”>// Set output format to json
$grid2->dataType = ‘json’;
$grid2->setTable = ‘tblLandOwners’;
$grid2->table = ‘tblLandOwners’;
$grid2->setPrimaryKeyID(‘LandOwnerID’);
$grid2->serialKey = true;
if ($grid2->oper == ‘add’) {
    $data = filter_input_array(INPUT_POST);
    $grid2->trans = false;
    if ($grid2->insert($data)) {
        // $sql = “select LAST_INSERT_ID()”;
        // $stmt = $conn->query($sql);
        // $lastInsertID = $stmt->fetch();
        $lastInsertID = $conn->lastInsertId();
        // Create a ‘blank’ record for this landowner in tblParcels
        $sql = “insert into tblParcels (LandOwnerID) values(“.$lastInsertID[0].”)”;
        $conn->query($sql);
    }
}
$grid2->add = false;</p>
<p style=”padding-left: 40px;”>// Let the grid create the model
$grid2->setColModel();</p>
The insert for tblLandOwners worked, but no record was created in tblParcels.

Ken

I added some test code based on what you said, but I never get any value with the $grid->getLastInsertId method.

Here’s what I added:

After I perform the insert, the text file I created (addloform.txt) contains:

Data: Array
(
[LandOwnerID] =>
[LandOwner] => Rogers, K&T
[LandOwnerNotes] => jj
[Status] => 1
[CurrentlyAssignedTo] => 26
[LandOwnerAddress1] => 86 Gruiver Rd
[LandOwnerAddress2] =>
[LandOwnerCity] => Branchburg
[LandOwnerState] => NJ
[LandOwnerZip] => 08876
[HowToContact] => kjh
[MailingSalutation] => lkjh
[AddressedTo] => lkjh
[oper] => add
)

Last insert LandOwnerID:

It looks like the $grid->getLastInsertId method is returning something (since the value got reset from “none set”), but it’s not the primary key from the insert.

The Help file for this method reads:

getLastInsertId( )

The method return the last inserted id when a add is performed and the primary key is serial. In order to have effect this method should be called after renderGrid, editGrid or insert methods – see below

API Tags:
Access: public