Filtering list page on a lookup field

PHPMaker General Discussion (PHPMaker)
1

I have a table (Table A) where one of the fields is a lookup field to a date in another table (Table B).

Is there a way to filter the list page of Table A so that it only displays records where the date lookup field points to a date >= CURDATE() in Table B??

Thanks

2

Are the “Link field” and “Display field” same refer to date value?

3

The link field is an id field to find the record in the lookup table - not a date field.
The Display field is the actual date field from the lookup table.

4

You may query first in “Recordset_Selecting” server event to get the id based on the required date, and then use that id as the value that supplied into filter string, for example, put this code in that “Recordset_Selecting” event:

$sDate = “2020-05-28”;
$the_ID = ExecuteScalar(“SELECT id FROM table_B WHERE date = '” . $sDate . “'” );
AddFilter($filter, "Lookup_Field = " . $the_ID); // assume Lookup_Field is integer/numeric field type; adjust Lookup_Field to your actual field that lookup to table_B