[TYPO3-core] RFC: #15969: Bug: Task Center - sys_action: setting labels_ignoreprefix from sql query is ignored

[Andreas Kiessling]

Hi,

This is an SVN patch request.

Type: Bugfix

BT reference: http://bugs.typo3.org/view.php?id=15969

Branches: 4_4, trunk

When setting up an advanced sql query, you can set a checkbox "Don't use 
original values in brackets as prefix for labelled results"

When you save the query to an action however, this setting is not used 
in the task center and so the uid is always prefixed like [12345] which 
makes this field hard to use as a sorting field in e.g. excel, because 
you would always sort by the uids and not the labels.

To reproduce: create a query for a table with a relation to another 
table (don't forget to select that field), tick the mentioned option, 
save that to an action and view it in the taskcenter.

Solution: The checkbox is saved in the t2_data of the query and must be 
applied to the $GLOBALS['SOBE']->MOD_SETTINGS so that class 
t3lib_fullsearch recognizes the setting.

The class t3lib_fullsearch itself contains a check for the setting, so i 
am a bit unsure if the setting should be set to "on" or "1" in the 
sysaction class.

 From class t3lib_fullsearch:
$GLOBALS['SOBE']->MOD_SETTINGS['labels_noprefix'] = 
$GLOBALS['SOBE']->MOD_SETTINGS['labels_noprefix'] == 1 ? 'on' :
						$GLOBALS['SOBE']->MOD_SETTINGS['labels_noprefix'];

Regards,
Andreas
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 15969_v2.patch
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20101025/3cc3fccf/attachment.txt>