TYPO3 Core

when creating a sql query via sys_actions task module it's not possible to have the pid field in the result table.

this is because t3lib_fullsearch that is being used to render the result excludes "pid" and "deleted" from the list of query fields as long there's no explicitly defined list of valid fields:

see t3lib/class.t3lib_fullsearch.php

1074         function resultRowTitles($row, $conf, $table) {
1075                 $SET = $GLOBALS['SOBE']->MOD_SETTINGS;
1076
1077                         $tableHeader = array();
1078
1079                         // Start header row
1080                 $tableHeader[] = '<thead><tr class="bgColor5">';
1081
1082                         // Iterate over given columns
1083                 foreach ($row as $fieldName => $fieldValue) {
1084                         if (t3lib_div::inList($SET['queryFields'], $fieldName) || (!$SET['queryFields'] && $fieldName != 'pid' && $fieldName != 'deleted')) {
1085                                 $THparams = (strlen($fieldValue) < 50) ? ' style="white-space:nowrap;"' : '';
1086

the attached patch adds all fields that were selected in the query editor to the list of valid queryFields so t3lib_fullsearch doesn't kick out "pid" and "deleted".