Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 2910 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted (edited)

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 by doughemi
Consistency in variable names
Posted

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.

This topic is 2910 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.