Developer forum

Hi,

We want to do the following in the search index:

• We have an assortment for a customer where some of the products should always be shown and some should only be show on a specific location.
• Let's say we have products A, B and C that should always be shown and of these product C is on location Oslo. 
• Then we have products D and E which both are on location Oslo.

The problem with Dynamicweb's search seems to be that we are not able to show product "C" when you are not on Oslo since it can't handle that kind of logic. 

So for SQL this would be:

Select    *
From     Products
Where  AlwaysShow = TRUE
Or          Location = CurrentLocation

Note: this is for filters, so we would like to be able to do the above with filters. 

Anyone know if this can be done or not?

Thanks,
Marius