[TYPO3-commerce] fesearchintable showing DELIVERY and PAYMENT !!!!!!!!

[J.Bakshi]

Franz Koch wrote:
> Hi,
>
>   
>>> you can just index article_types 1.
>>>   
>>>       
>> Thanks Ingo.  could you kindly mention where I should enter this value ?
>>     
>
> in the TS that is generating the query in fesearchintable. But according 
> to the manual of fesearchintable that might not be possibe, because you 
> would have to include a second table (the articles table) in the query 
> to get a relation to the article_type.
>
> As the payment and delivery articles are not varying, you could simply 
> exclude their uids from the query:
>
> ----
> plugin.tx_fesearchintable_pi1 {
>    tx_commerce_products.selectAdditionalParams = AND uid NOT IN (1,2,3,4)
> }
> ----
>
> where '1,2,3,4' is the uid list you would like to exclude. Alternatively 
> you could try to use a very trick TS snipped here, because 
> selectAdditionalParams has stdWrap properties. You could create a 
> TSobject below selectAdditionalParams, perform a second query there, 
> that returns the uids that should not be included in the search and wrap 
> those uid with the propper WHERE condition.
>   

Dear friend Franz,

The typoscript has done the magic. Now the search word  *payment* and
*delivery*  don't display those categories.
 Many Many thanks. The explanation you have presented here is a valuable
piece of information and I request to include this in the wiki.
Specially the explanation will help to understand the typoscript in a
better way.

> I could tell you how that probably would work, but sorry, that's a bit 
> to much for now - you first have to try it yourself before I begin doing 
> your work. 

Yes it is working. I confirm it. I have been learning typoscript but I
admit that still there are a lot to know and understand.
Your explanation is really helpful.

> I write that, because I never used this extension before and 
> just had a look in the manual of that extension and the wiki to give you 
> the answer above. That's time I don't get paid for - but you do - and 
> therefor you have to show that you are willing to learn and not just 
> copy and paste.
>   
Showing my Respect to you .
with BEST WISHES

 
> --
> Greetings,
> Franz
> _______________________________________________
> TYPO3-project-commerce mailing list
> TYPO3-project-commerce at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-commerce
>
>   


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Joydeep Bakshi, Linux System Admin
Kolkatainfoservices Pvt Ltd,
23A Royd Street, Kolkata 700016, India
Work Phone 91 033 40014784
http://infoservices.in/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~