function prepareAndRunMergedDatasetQuery($select, $inputObj, $where, $groupby, $perPage, $pageNo) { $mergedDatasetQuery = new MergedDataSetQueryMaker($select, $inputObj, $where, $groupby, $perPage, $pageNo); $queryInfo = $mergedDatasetQuery->GetQuery(); $externalDBCredentials = new stdClass(); $externalDBCredentials->driver = $queryInfo->serverInfo->driver; $externalDBCredentials->user_name = $queryInfo->serverInfo->user_name; $externalDBCredentials->password = $queryInfo->serverInfo->password; $externalDBCredentials->source_database = $queryInfo->serverInfo->database; $externalDBCredentials->server_address = $queryInfo->serverInfo->server_address; $externalDBCredentials->port = $queryInfo->serverInfo->port; $externalDBCredentials->is_local = null; $externalDBCredentials->linked_server_name = null; return ExternalDBs::ExecuteQuery($queryInfo->finalQuery, $externalDBCredentials); }