Solr search query using multiple fields
My objects have fields: Title, Image, Description, web, type, url, id and _version (collection of recipes). The type is the category of recipe (dessert, first course...). I want to find all elements with title or description containing "pasta pomodoro" only in the type: secondi-piatti (that is, second course). My query is:
(Title:pasta,pomodoro OR Description:pasta,pomodoro) AND (type:secondi-piatti).
The title and description queries are correct (because in this way it can find also elements containing only "pomodoro" or "pasta"), but I don't understand why in my results I have also recipes of type:primi-piatti (that is, first course), because I suppose that with an AND it will find only elements of that type. Does someone know what is the problem?
I have also to say that if I write the same query but instead of using type:secondi-piatti, I use type:dolci (desserts), it works because it displays only recipes containing "pasta" as desserts and not recipes of the first course. In summary this structure of the query follow the type that I want only if the type is dolci (dessert), with all other types (primi, secondi-piatti, antipasti, contorni) it doesn't work.
I found out the problem. Having a type with two terms it searches the types that contains one term or the other one, in fact piatti belongs both to primi-piatti and to secondi-piatti. I have to write:
(Title:pasta,pomodoro OR Description:pasta,pomodoro) AND type:(secondi AND piatti)
- HashMap with List of Objects as a Key
- Java 8 Distinct by property
- What is the most efficient way of getting an empty array in C# in terms of time and space?
- defaultdict of defaultdict?
- Verifying all objects in a Kotlin collection match without overriding equals
- json (which contains few objects) to TreeMap on java
- Symfony 4.4 how to start with 0 fields using a collectionType
- Using foreach loop on Dictionary<>
- Scala GroupBy preserving insertion order?
- Does C# Collection Initialization Syntax Avoid Default Initialization Overhead
- Reproducing the 'non-concurrent collections must have exclusive access' exception
- Is there a no-duplicate List implementation out there?
- What's the difference between natural ordering and total ordering?
- How to check if a list contains a sublist in a given order in Java
- Concurrent collection supporting random (FIFO) and specific Remove
- Difference between Pair and Hashmap?
- How to convert Set to Array?
- Why should I avoid using the increase assignment operator (+=) to create a collection
- Atomically taking everything from a ConcurrentQueue
- Adding multiple elements to a list in one line C#
- A pithy way to obtain the largest amongst a set of comparables
- Is there a typescript List<> and/or Map<> class/library?
- Thread-safe fixed-size circular buffer with sequence ids
- Best practice for parameter: IEnumerable vs. IList vs. IReadOnlyCollection
- How to convert int[] into List<Integer> in Java?
- Java Immutable Collections
- How to merge Dictionarys from typescript-collection?
- How can Python by used to support a record type? (i.e. mutable namedtuple)
- When to use LinkedList over ArrayList in Java?
- A Java collection of value pairs? (tuples?)