21487 Posts in 5783 Topics by 2621 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 237 Views |
-
How to subtract DataObjects
10 July 2012 at 7:58am
I've found I can merge dataobjects just fine, but I need to subtract Dataobjects too. It says the method subtract does not exist.
Is there a way to subtract $alreadypicked ?
$enhancements = new DataObjectSet();
$alreadypicked = DataObject::get('Enhancement', 'ProjectsID != 0');
$enhancements->merge(DataObject::get('Enhancement', 'StatusLevelsID = 8')); // In Progress
$enhancements->subtract($alreadypicked);
$enhancements->merge(DataObject::get('Enhancement', "ProjectsID = {$this->ID}"));Thanks,
Brian -
Re: How to subtract DataObjects
10 July 2012 at 8:44pm Last edited: 10 July 2012 8:45pm
how about...
$enhancements = new DataObjectSet();
$alreadypicked = DataObject::get('Enhancement', 'ProjectsID != 0');
$enhancements->merge(DataObject::get('Enhancement', 'StatusLevelsID = 8')); // In Progress
if ($alreadypicked) foreach ($alreadypicked as $item) {
$enhancements->remove($item);
}but having looked again - what you are doing is crazy... why not just use a bit more SQL...
$enhancements = DataObject::get('Enhancement', 'StatusLevelsID = 8 AND ProjectsID != 0');
-
Re: How to subtract DataObjects
10 July 2012 at 11:31pm
Thanks!!! Your second option was what I was originally looking for. I entered it incorrectly as:
$enhancements->merge(DataObject::get('Enhancement', 'StatusLevelsID = 8' AND 'ProjectsID != 0'))
Which gave me all StatusLevelsID of 8 and all ProjectsID of 0.
I was also wanting to know how to subtract (remove) an item too, so thanks again.
Brian
| 237 Views | ||
|
Page:
1
|
Go to Top |
