Aggregated Methods

Learn about DataStore's aggregated methods

Original data
nameageincome
John 26 $50,000
Marry 29 $60,000
Peter 34 $100,000
Donald 28 $80,000
filter() 

$store = $this->dataStore("data")
        ->filter("income",">",50000);
nameageincome
Marry 29 $60,000
Peter 34 $100,000
Donald 28 $80,000
filter($callback) 

$store = $this->dataStore("data")
        ->filter(function($row){
            return $row["income"]>50000;
        });
nameageincome
Marry 29 $60,000
Peter 34 $100,000
Donald 28 $80,000
where() 

$store = $this->dataStore("data")
        ->where("income",60000);
nameageincome
Marry 29 $60,000
except() 

$store = $this->dataStore("data")
        ->except("income","age");
name
John
Marry
Peter
Donald
only() 

$store = $this->dataStore("data")
        ->only("name","income");
nameincome
John $50,000
Marry $60,000
Peter $100,000
Donald $80,000
whereIn() 

$store = $this->dataStore("data")
        ->whereIn("name",["John","Marry"]);
nameageincome
John 26 $50,000
Marry 29 $60,000
whereNotIn() 

$store = $this->dataStore("data")
        ->whereNotIn("name",["John","Marry"]);
nameageincome
Peter 34 $100,000
Donald 28 $80,000
Description