#16834task center (sys_action): SQL Query export does not respect "Use formatted strings, labels and dates" settings
Description
The advanced database search in Typo3 has the checkbox “Use formatted strings, labels and dates instead of original values for results”. This works fine in the advanced database search screen but not when the same query is used in the “task center”. A date, for example, is always shown as unix date and not as a formatted string. This makes it impossible to export dates.
A fix is available in the extension “joh_advbesearch” (but this extension has other problems). To apply this to the Typo3 core, some lines have to be added to /typo3/sysext/sys_action/class.tx_sysaction.php.
After the line:
$type = $sql_query[“qC”][“search_query_makeQuery”];
Add these lines:
$GLOBALS[‘SOBE’]->MOD_SETTINGS[‘search_result_labels’] = $sql_query[“qC”][“search_result_labels”];
if ($sql_query[“qC”][“search_result_labels”]==‘on’) {
$search_result_labels = ‘&SET[search_result_labels]=on’;
}
(issue imported from #M4744)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.