[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