Project

General

Profile

Actions
Copy link

Bug #16834

closed

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

Added by Pieter almost 18 years ago. Updated almost 10 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
Copy link
 #1

Updated by Chris topher over 14 years ago

The taskcenter was rewritten for TYPO3 4.4.
Is this still an issue with TYPO3 4.4 or newer?

Actions
Copy link
 #2

Updated by Georg Ringer over 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)

Actions
Copy link
 #3

Updated by Olaf Kolbig over 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!

Actions
Copy link
 #4

Updated by Alexander Opitz about 10 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)?

Actions
Copy link
 #5

Updated by Alexander Opitz almost 10 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.

Actions
Copy link

Also available in: Atom PDF