Bug #16834
closed
task center (sys_action): SQL Query export does not respect "Use formatted strings, labels and dates" settings
0%
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)
Files
Updated by Chris topher about 14 years ago
The taskcenter was rewritten for TYPO3 4.4.
Is this still an issue with TYPO3 4.4 or newer?
Updated by Georg Ringer about 14 years ago
this code stayed pretty much the same. still this patch is kind of impossible to change anything because $search_result_labels is set but never used in the whole file (checked 4.2 of course where sys_Actions haven't been touched)
Updated by Olaf Kolbig almost 13 years ago
- Target version deleted (
0)
The bug has changed behavior in Typo3 4.5.
Due to the hardcoded setting in line 820 (EXT:sys_action/task/class.tx_sysaction_task.php)
=> $GLOBALS['SOBE']->MOD_SETTINGS['search_result_labels'] = 1;
the query does not respect NOT checking the checkbox "Use formatted strings, labels and dates..." when related to an action.
It is not possible to export raw values from DB!
Updated by Alexander Opitz over 9 years ago
- Description updated (diff)
- Status changed from New to Needs Feedback
- PHP Version deleted (
4) - Is Regression set to No
Hi,
as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (6.2.5)?
Updated by Alexander Opitz over 9 years ago
- Status changed from Needs Feedback to Closed
No feedback within the last 90 days => closing this issue.
If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.