19 Posts
web2e
9 years ago
Topic

Hi, I have created a "List and Search Type" with "Search Query Field Plugin". 

In my form, I have a "Select Multiple Field" - videotype. (the real form is more complecated, but this is only a example) 

In the "Seach Query Field Plugin", 

If I select only a videotype value and I use 

 [MATCH]vd.videotype||$uri->getValue('vd.videotype')[/MATCH] 

the query working 

----------------------- 
select co.id, vd.type, co.title, co.alias, co.language, co.introtext 
from ipv_content co 
inner join ipv_cck_store_form_video vd on vd.id = co.id where co.state = 1 and 
[MATCH]vd.videotype||$uri->getValue('vd.videotype')[/MATCH] and 
[MATCH]co.title||$uri->getValue('art_title')[/MATCH] and 
[MATCH]co.language||$uri->getValue('art_language')[/MATCH] 
order by co.title; 
----------------------- 

But, If i select more videotype value (multiple select field) , in this case I would like: 

 vd.videotype IN ('youtube','vimeo') 

and so I've wrote: 

vd.videotype IN ($uri->getValue('vd_type')) 

but this don't working.

In your article there are only input with single value. 

http://www.seblod.com/resources/tutorials/using-the-search-query-field-plugin 

Is there a post or a tutorial where is explained how write the query to get multiple-select value ?

4 replies have been added to this thread, and the topic is marked as solved.
You should subscribe to a club in order to read all posts.