public static function getValueReferenceDetails($reference)
{
list($keyCol, $valueColumn) = explode("@", $reference);
list($sourceColumn, $sourceValue) = explode("=", $keyCol);
if (strpos($sourceValue, '[') !== false) {
list($sourceValue, $pathInStructure) = explode("[", $sourceValue, 2);
} else {
$pathInStructure = '';
}
return ['source-column' => $sourceColumn, 'source-value' => $sourceValue, 'value-column' => $valueColumn, 'path-in-structure' => $pathInStructure];
}