Search the Community
Showing results for tags 'custom php'.
Found 1 result
I have a script that performs a find based on related fields. Here's a very simplified version of script Go To Layout ["Primary_Table"] Enter Find Mode  Set Field [related_table::name] Perform Find I have the <<related_table::name>> field on the Primary_Table layout. If I run this within Filemaker Pro it works and finds desired subset. If I run it as a Server script it works and finds desired subset. But, if I trigger it from PHP it finds ALL the records in the Primary_Table. The following, however, does work and finds a subset of records from Primary_Table: Go To Layout ["Primary_Table"] Enter Find Mode  Set Field [Primary_Table::id] Perform Find In other words, I can trigger scripts with PHP that successfully do finds when all the find fields are native to the Primary_Table, but as soon as I try to add criteria that's in a related table to Primary_Table it finds ALL Primary Table records. I've tried authorizing all layouts to the php user so I don't think it's a permissions issue. Is this a known issue, or should it work in principal and I'm missing something? Hopefully not since otherwise it's going to mean a much longer script to find what I need (the actual script does a search using fields from 3 different related tables, 2 of which are 3 tables away from Primary_Table, so I'll need to do a ton of Go To Related Records steps. Thanks for the help!