[TYPO3-english] wfqbe: problem removing where-in-clause

[sabine deeken]

I have found a workaround, maybe useful to somebody:
the where-in-clause is not removed by the hook, but i could solve it in 
the query:

SELECT .... WHERE termin.uid >= '0' AND lehrgang.lg_hauptgrup LIKE 
'%,###WFQBE_HAUPTGRUP###%' AND ( termin.begin_utimestamp > 
'###TS_WFQBE_TIMESTAMP###' OR termin.begin_utimestamp = '0' ) AND ( 
termin.mandant IN ( '###WFQBE_MANDANT###' ) OR termin.mandant < 
'###TS_WFQBE_KEINMANDANT###' )

plugin.tx_wfqbe_pi1.customQuery.11 {
TS_WFQBE_KEINMANDANT = TEXT
TS_WFQBE_KEINMANDANT.value = 9999
TS_WFQBE_KEINMANDANT.overrideAlways = 1
TS_WFQBE_KEINMANDANT.if.isFalse.data = GPvar:tx_wfqbe_pi1|MANDANT|0
}



sabine deeken schrieb:
> Dear List,
>
> I need a hint for wfqbe-extension. the Problem is as follows:
> I have a wfqbe-search with a set of checkboxes and a single select-box.
> the problem is the checkbox thing: in the results-query it is resolved 
> like this:
>
> WHERE termin.mandant IN ( '###WFQBE_MANDANT###' )
>
> when I want to ged rid of this where-clause by using the hook, the 
> where-in-clause is not removed.
> (the other search-option which is a where-like-clause gets removed, when 
> I change the where-in to a where-=-clause, it gets removed, too, but I 
> need multiple select.)
>
> is there a possibility to fix this?
>
> best regards and thousands of thanks,
> Sabine
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
>