I've created a compound found which works. I know need to constrain that foundset by omitting records which I would do with another find in FileMaker and the constrain with omit criteria.

Is it possible with the api to do this? I need to omit after I have found the records.

Yes, with the setOmit(TRUE) statement:

$theFind =$fm->newCompoundFindCommand('YourLayout');
$request1=$fm->addFindCriterion('yourField', $value1);
$request2=$fm->addFindCriterion('yourOtherField', $value2);
$request3=$fm->addFindCriterion('yourOmitField', $valueOmitted);
$request3=$fm->setOmit(TRUE);
$theFind->add(1,$request1);
$theFind->add(2,$request2);
$theFind->add(3,$request3);
// you could sort here with $theFind->addSortRule() statements
$foundSet = $theFind->execute();

 

Edited December 3, 20169 yr by doughemi
Consistency in variable names

My other method is to do the original find, and then drop the ones I don't want during the foreach loop used to display the records.