Newbies AJK Posted December 3, 2016 Newbies Posted December 3, 2016 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.
doughemi Posted December 3, 2016 Posted December 3, 2016 (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 December 3, 2016 by doughemi Consistency in variable names
webko Posted December 5, 2016 Posted December 5, 2016 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.
Recommended Posts
This topic is 2900 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 accountSign in
Already have an account? Sign in here.
Sign In Now