[TYPO3-dev] A search query question
Tapio Markula
tapio.markula at xetpoint.fi
Wed Aug 20 17:37:25 CEST 2008
Steffen Kamper kirjoitti:
> Tapio Markula schrieb:
>> Hi
>>
>> Commonly there are queries like pid IN (...)
>>
>> But I would need opposite (list of pages, which must exclude from
>> seach) and pid NOT IN (...) didn't work - what's the correct
>
> Hi,
>
> NOT IN () is correct and works, so you may have an error anywhere else.
seemst that it can't be empty - I must add that conditional
if($this->conf['uidNoseachCatList'])
$uidNoseachCatList=' AND tx_abcourses_categorie.uid NOT IN
('.$this->conf['uidNoseachCatList'].')';
$searchApi->queryParts['WHERE'] = '(tx_abcourses_course.pid=pages.uid)
'.$uidNoseachCatList.'
now not 'NOT IN ()' will be generated
More information about the TYPO3-dev
mailing list