A NOT Find in PHP

[Matthias Flury]

Hy

How can a find request be done with the php API which allows the following query:

"give all records where the field User is xxx an the Status is not released (there are other status like "in work" , "in test" , "accepted" etc)"

Any suggestion ?

[bcooney]

In FM you would Find with 2 requests: Find User = xxx, New Request, Status = Not Released Omit.

Another way is a Find, then a constrain. Same thing really.

You could call this script from PHP. Jonathan Stark's Blog

[Genx]

$req = $DB->newFindRequest('layout');

$req->addFindCriterion("userField","xxx");



$req2 = $DB->newFindRequest('layout');

$req2->addFindCriterion("status","released");

$req2->setOmit(true);



$find = $DB->newCompoundFindCommand('layout');

$find->add(1,$req);

$find->add(2,$req2);

$find_result = $find->execute();