Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Tags Filter in Groups

 
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 05-23-2018, 06:05 AM
 
xgarb xgarb is offline
 

eXpert
  
Join Date: Jul 2004
Location: UK
Posts: 263
 

Default Tags Filter in Groups

I'm working on microsites within our main site. Each microsite features one range of our products and filters (like a product finder) to narrow down the products shown.

I'm using a custom version of the tags module along with an Itemlist module to show results.

The filters look something like this and work through the entire site...



I want to be able to show results (based on the above example) like
SELECT * WHERE animals=blue OR red AND liquid=Slurry OR Dirty Water OR Clean Water … etc

The problem is the tags aren't stored or referenced in groups (the block above is static HTML) so the normal Tags module query is more like:
SELECT * WHERE tag=blue OR red OR Slurry OR Dirty Water OR Clean Water

So this results in options being shown that don't match all the filters.

What approach should I take to putting the tags in groups and modifying my itemlist search? I can put the tag names or ids in arrays for each group and use that in a query or I could add the groups into a new table. I don't fully understand how X-cart creates an SQL query to do something like this.
__________________
Core version: 5.5.xx
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 11:46 PM.

   

 
X-Cart forums © 2001-2020