This answer was for another post...sorry.
Is this a general limitation of ADDT or is there a way around this?
Just being general:
Did you add the filter string for each new feild?
$tfi_listRecordset7 = new TFI_TableFilter($conn_Acct, "tfi_listRecordset7");
$tfi_listRecordset7->addColumn("id", "NUMERIC_TYPE", "id", "=");
**$tfi_listRecordset7->addColumn("ADD ME", "NUMERIC_TYPE", "ADD ME", "=");
Yes, it is in the filter.
I've found the problem. ADDT is doing what it needs to, it is a limitation of SQL. When creating an alias is SQL [e.g., (Field1 -Field2) as new_field], "new_field" cannot be referenced in a WHERE clause and ADDT is including the alias name in the WHERE clause for the filter it generates.
Solution is to either comment out the filter statement in the code for that column or rename from the alias to the name of the column that SQL generates, in this case, the actual field name is "(Field1 - Field2)".