Issue Bug Closed

#86396search_result_labels setting ignored when executing System Action

Sascha Löffler 09/27/18, 00:39 updated 05/07/19, 12:17

Description

When creating a SQL Query Action for example to export a CSV, the setting `Use formatted strings, labels and dates instead of original values for results` is correctly used in the Query Editor, but when executing the Action, it is ignored and always enabled.

In /typo3/sysext/sys_action/Classes/ActionTask.php
on line 826

$GLOBALS['SOBE']->MOD_SETTINGS['search_result_labels'] = 1;

should be

$GLOBALS['SOBE']->MOD_SETTINGS['search_result_labels'] = $sql_query['qC']['search_result_labels'];

Also for TYPO3 v9 the settings should be correctly set for the QueryView.

See also #86336 for the same issue in TYPO3 v8

Reviews 2