CrudKit\Data\SQLDataProvider::getForeignValues PHP Method

getForeignValues() public method

public getForeignValues ( $localKey, $value )
    public function getForeignValues($localKey, $value)
    {
        $builder = $this->conn->createQueryBuilder();
        $exec = $builder->select($this->queryColumns('all', array(), 'exprAs', false, true))->from($this->tableName)->where("{$localKey} = " . $builder->createNamedParameter($value))->setMaxResults(10)->execute();
        return $exec->fetchAll(\PDO::FETCH_ASSOC);
    }