Project

General

Profile

Actions

Bug #16834

closed

task center (sys_action): SQL Query export does not respect "Use formatted strings, labels and dates" settings

Added by Pieter over 17 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2007-01-06
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.0
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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

bug_0004744.diff (802 Bytes) bug_0004744.diff Administrator Admin, 2007-01-07 22:28
Actions

Also available in: Atom PDF