#11427Field Override for indexing
Description
It would be nice to have the possibility to override certain fields like item_crdate so you can filter entries by year.
A possible application of this might be tt_news.
This is what has to be added to the method submitPage in tx_indexedsearch_indexer
foreach($conf['overrideConfig.'] as $config) {
foreach($config as $key => $el) {
if($key == 'mapping.') {
foreach($el['override.'] as $k => $v) {
// Assume that ids that are passed are not deleted
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
$v,
$el['table'],
' '.$el['tableKey'].'='.$_GET[$el['extKey']][$el['var']]
);
$val = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
$this->conf[$k] = $val[$v];
}
}
}
}
And this is what has to be added to the method submitFilePage in tx_indexedsearch_indexed:
foreach($conf['overrideConfig.'] as $config) {
if($config['overrideFiles']) {
foreach($config as $key => $el) {
if($key == 'mapping.') {
foreach($el['override.'] as $k => $v) {
// Assume that ids that are passed are not deleted
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
$v,
$el['table'],
' '.$el['tableKey'].'='.$_GET[$el['extKey']][$el['var']]
);
$val = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
$this->conf[$k] = $val[$v];
}
}
}
}
}
This is what the config would look like
overrideConfig {
mapping {
tt_news {
table = tt_news
tableKey = uid
extKey = tx_ttnews
// Field to override
override.item_crdate = tt_news.datetime
// pi var
var = tt_news
}
}
overrideFiles = 1
}
Thanks for youre feedback.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.