protected function selectBoundary4DatasetRequest(DataControllerCallContext $callcontext, AbstractDatasetQueryRequest $request, $datasetName, $columnName) {
// looking for an index where this instance is used. Rest of the queries will be ignored.
// Data for ignored queries will be calculated during subsequent requests to different instances of this class
$selectedIndex = NULL;
if (isset($request->queries)) {
foreach ($request->queries as $index => $query) {
foreach ($query as $values) {
foreach ($values as $value) {
if ($this->operatorHandler === $value) {
$selectedIndex = $index;
break 3;
}
}
}
}
}
$expressionRequest = new DatasetQueryRequest($request->getDatasetName());
// needs to be called before any additional methods are called
$expressionRequest->addOptions($request->options);
// returning only observing column
$expressionRequest->addColumn($columnName);
// excluding records with NULL value for the observing column
$expressionRequest->addQueryValue(
0,
$columnName, OperatorFactory::getInstance()->initiateHandler(NotEqualOperatorHandler::OPERATOR__NAME, NULL));
// adding support for queries except this operator handler
if (isset($selectedIndex)) {
foreach ($request->queries[$selectedIndex] as $name => $values) {
foreach ($values as $value) {
if ($this->shouldValueBeSkipped($value)) {
continue;
}
if ($this->operatorHandler === $value) {
continue;
}
$expressionRequest->addQueryValue(0, $name, $value);
}
}
}
else {
// we have this situation because we call this operator for a request where this operator is not used
}
// sorting data
$expressionRequest->addOrderByColumn(
ColumnBasedComparator_AbstractSortingConfiguration::assembleDirectionalColumnName($columnName, $this->isSortAscending()));
// limiting response to one record
$expressionRequest->setPagination(1, 0);
return $this->processDatasetExpressionRequest($callcontext, $expressionRequest, $columnName);
}
protected function selectBoundary4DatasetRequest(DataControllerCallContext $callcontext, AbstractDatasetQueryRequest $request, $datasetName, $columnName)
{
// looking for an index where this instance is used. Rest of the queries will be ignored.
// Data for ignored queries will be calculated during subsequent requests to different instances of this class
$selectedIndex = NULL;
if (isset($request->queries)) {
foreach ($request->queries as $index => $query) {
foreach ($query as $values) {
foreach ($values as $value) {
if ($this->operatorHandler === $value) {
$selectedIndex = $index;
break 3;
}
}
}
}
}
$expressionRequest = new DatasetQueryRequest($request->getDatasetName());
// returning only observing column
$expressionRequest->addColumn($columnName);
// excluding records with NULL value for the observing column
$expressionRequest->addQueryValue(0, $columnName, data_controller_get_operator_factory_instance()->initiateHandler(NotEqualOperatorHandler::$OPERATOR__NAME, NULL));
// adding support for queries except this operator handler
if (isset($selectedIndex)) {
foreach ($request->queries[$selectedIndex] as $name => $values) {
foreach ($values as $value) {
if ($value->isSubsetBased()) {
// skipping other instances which are based on subset of data if their weight is greater than of this operator
if (isset($value->weight) && $value->weight > $this->operatorHandler->weight) {
continue;
}
}
if ($this->operatorHandler === $value) {
continue;
}
$expressionRequest->addQueryValue(0, $name, $value);
}
}
} else {
// we have this situation because we call this operator for a request where thus operator is not used
}
// sorting data
$expressionRequest->addOrderByColumn(PropertyBasedComparator_DefaultSortingConfiguration::assembleDirectionalPropertyName($columnName, $this->isSortAscending()));
// limiting response to one record
$expressionRequest->setPagination(1, 0);
return $this->processDatasetExpressionRequest($callcontext, $expressionRequest, $columnName);
}
