MODext: Getting Values from Join Query into Grid?

- 80 Posts
smg6511v2 Reply #1, 13 years, 8 months ago
I've successfully altered the query in my getlist processor with:
```
public function prepareQueryBeforeCount(xPDOQuery $c) {
        if($_REQUEST['sort']=='fullname'){
            $this->setProperty('sort','lastname');
        } 
        $c->leftJoin('fmConversions');   
        return $c;
    }
```
But, I can't figure out how to access the values from the join ... or if the query is even being used to build the resulting object. Any insights?
- ☆ A M B ☆
- 181 Posts
jgulledge19 Reply #2, 13 years, 8 months ago

Assuming you are using the docs here: http://rtfm.modx.com/display/revolution20/Developing+an+Extra+in+MODX+Revolution%2C+Part+II. I would suggest reviewing the base class modObjectGetList starting on line 440: https://github.com/modxcms/revolution/blob/master/core/model/modx/modprocessor.class.php of what you can override if needed or put in some error trapping to see what it is doing.
MODX ebook | My Site