Sphinx filter= OR !filter=

2013-12-01  Source: Original Site  Category:Sphinx  Views:0 


we've got 2 multi-value attribute columns and I'd like to be able to compose a query with
a filter part like this:

filter=columnA,1,2,3 OR !filter=columnB,99

From reading the forum and the docs it looks like the top level elements of the query
string are implicitly AND'd together ( query, filters, etc ).

Is there any way to, or any plans to allow this type of filter composition?

Related articles
  • Error Message: Filter [location-filter]: filter is unavailable. 2013-11-12

    all, i am trying to launch a WebSphere Application from the browser on a Windows box and i am getting this error below. The WebSphere is installed on Suse linux 9 box. Any ideas what is the root cause of this error? It seems to me that it is relating

  • Sphinx Large resultsets, filter after search 2012-03-06

    Hello, I hope anyone give me some tips on a special construction. I've a database with products, want to filter after search on some columns (through pulldowns with only values which exists in de total results). The current "SLOW" approach is: a. Sea

  • Sphinx Group By + Filter not giving expected results 2013-03-26

    I've built an index of user-entered (unstructured) descriptions for a particular object. Each description has a category_id and a user_id that is assigned (when indexed they are sql_attr_uint's). When a new object is added by a user, I'm trying to de

  • Sphinx RT and filter 2013-12-19

    Hello, I installed the latest version of sphinx on my server to handle the results of my blog, I added one rt_attr_string "category" for the blog's categories. ..... type = rt rt_mem_limit = 128M path = /var/sphinx/data/blog rt_field = title rt_field

  • Sphinx Full scan + filter + limit question 2014-06-22

    I'm using a full scan query to Sphinx to replace a WHERE...ORDER BY...LIMIT on a MySQL table with around 50k rows. Initial results show sphinx is much faster than the query (even with indices on the where and order by columns). However, when I use th

  • Sphinx Limits for Filter and attrb values 2014-07-23

    I'm dealing with a design problem in my DB, I have products and each product can have a lot of "facets" (and each facet can have differents values=tags). And I need to group the tags by facet, and filter by tags. e.g.: Product: Monitors Facets: Type

  • Sphinx How to filter by document ID 2012-08-18

    It is straightforward enough to filter by attributes but how can we filter the results to exclude specific document IDs? The next known method is just to list the ID a second time AS a different alias in the select query and set it as an attribute bu

  • Sphinx How to filter on join table value? 2014-10-20

    I have a problem that I am not sure how to solve. I basically have two tables. One "photos" table and one "likes" table. Each photo can contain multiple likes. Each like also saves the date of when the photo was liked. As it is today I join the photo

  • Sphinx how can filter my search using a particular column only in ror 2014-03-21

    consider that i am having a employee table and salary as column . i need to show the employee whose salary is 5000.75 or between 5000 and 7000.note salary in float i am using the below code ThinkingSphinx::Search.search :with => {:salary=>5000.

  • Oracle possible to have both filter + clear filter icon in a column header? 11gR2 2014-03-11

    From [new features doc for 11gR2|http://www.oracle.com/technetwork/developer-tools/jdev/jdev-11gr2-nf-404365.html] : "If a row header column is present in the filterable table, an icon will be displayed on the column header that will allow the user t

  • Filter the Filter 2015-02-18

    How can i filter something then turn it to filter again and one more time , like : SELECT * FROM Tbl1 WHERE BLABLA1 From those results WHERE BLABLA 2 And Finally , from all back results WHERE BLABLA 3. Real Example: Select all where : the year is bet

  • Error 500: Filter [ThreadLocalCleanupFilter]: filter is unavailable. 2012-03-09

    After deploying the Workplace application in Websphere. when i tried to run the application I am getting the below Error in IE. Please help me out to resolve this issue or inputs to look into like configuration files updation, adding any jars etc

  • how is PRIOMAP used in a CBQ without filter or filter match 2012-11-03

    according to the following HTML, http://lartc.org/howto/lartc.qdisc.classful.html section PRIO parameters & usage: it says: "If you do not provide tc filters to classify traffic, the PRIO qdisc looks at the TC_PRIO priority to decide how

  • Specifying the conditions for inner join at runtime using Filter 2012-01-04

    Say i have one-to-many relationship between Product and ProductNames Product ----> PID (PK) ProductNames------> PID, USECODE, STARTTIME as composite ID and ENDTIME is another normal column. Now i want to fetch product with PID='1' and USECODE='

  • Overlay Object in DirectShow Transform Filter 2012-02-19

    I'm 2 days beginner in DirectShow. I want to implement some image processing routines using DirectShow. So, I created custom transform filter using AppWizard found on the web. That's all ok, I can test the filter using GraphEdit and also implement it

  • Filter prints multiple lines 2012-03-11

    This is my first posting to this forum. I have list of about a thousand applications for which various outsourcing companies are supporting at different levels. I want to use the attached code to filter. For example, if I type "SOX", every row with "

  • jQuery MS filter:shadow and .Show() animation rendering issue 2012-03-27

    I seem to be having an issue using .Show(500) on a div block where the MS filter:shadow filter does not render. If I use .Show() without animation, the shadow filter works fine in IE, but as soon as I add the animation, the shadow does not render. Th

  • Filter Configuration in Websphere Application Server 6.1 2012-04-03

    We are facing an issue in Filter configuration to a Servlet. Basically, once the servlet filter is finished with its execution, it is not redirecting to the specified page. The response content after the servlet filter execution is null. We are using

  • jQuery Bringing filter support to live method 2012-04-24

    One of my live methods was not working. So I started looking into the code without realizing that live does not support filter method. Anyway I patched the code to make live support filter method. I am learning both JavaScript and jQuery and hence I

  • Windows Event Log equivalent to a nagios filter - scan for period of time 2012-06-09

    Nagios allows you to scan event logs for a period of time (e.g. last 24 hours). This can be useful for identifying problems when the nagios monitoring client was offline (e.g. password change in security log while client service was stopped). The fil