#community-help

Searching Specific Contributor Type in Record

TLDR Greg needs to search for contributors who are authors only. Jason suggested multiple search queries filtered by types and aggregation of results on client-side.

15mo

Join the chat

Oct 03, 2022 (15 months ago)

Photo of md5-11c0f771a29e2aa8d72ae9544cc39017

Greg

04:59 PM

I have this contributor record

{
    "contributor1": {
        "bio": "",
        "firstName": "Lewis",
        "lastName": "Carroll",
        "type": "Author"
    },
    "contributor2": {
        "bio": "",
        "firstName": "Greg",
        "lastName": "Mascherino",
        "type": "Illustrator"
    },
    "contributor3": {
        "bio": "",
        "firstName": "Greg",
        "lastName": "Jamie",
        "type": "Illustrator"
    },
    "contributor4": {
        "bio": "",
        "firstName": "Jamie",
        "lastName": "Greg",
        "type": "Illustrator"
    },
    "contributor5": {
        "bio": "",
        "firstName": "Jamie",
        "lastName": "Mascherino",
        "type": "Illustrator"
    }
}

I want to search for Carroll and I only want to return this result if Carroll is an author. So Searching for Greg would not be a hit.

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

05:44 PM

You would have to use filter_by for this. Something like contributor1.type:=Author

05:45

Jason

05:45 PM

Typesense doesn’t support doing OR’s across multiple fields at the moment (though we’re actively working on adding support for this), so you would have to break the query out into multiple multi_search queries, with one contributor field per query

Greg

06:13 PM

The problem with filter_by is that it would return the record if any of the contributors is an author. It should only return if the query matches and the type is author. I assume that is not possible?

06:15

Greg

06:15 PM

My query by field would look like this:

contributors.contributor5.lastName,contributors.contributor5.firstName,contributors.contributor4.lastName,contributors.contributor1.firstName,contributors.contributor2.firstName,contributors.contributor4.firstName,contributors.contributor1.lastName,contributors.contributor2.lastName,contributors.contributor3.firstName,contributors.contributor3.lastName

Jason

06:33 PM

You could do

contributor1.type:=Author &amp;&amp; contributor2.type:!=Author &amp;&amp; contributor3.type:!=Author &amp;&amp; contributor4.type:!=Author

and so on

Greg

07:51 PM

I would have to know which contributor is an author 😕. I need to match only if the query matches and the type matches, but group them all into one result. I don’t think I can do it via query. I would need to parse the results of the query I think.

Jason

07:54 PM

If you have say 3 contributor fields, you’d run 3 search queries (in a multi_search request) like this:

Query1: 
q: carrol
filter_by: contributor1.type:=Author && contributor2.type:!=Author && contributor3.type:!=Author

Query2: 
q: carrol
filter_by: contributor1.type:!=Author && contributor2.type:=Author && contributor3.type:!=Author

Query3: 
q: carrol
filter_by: contributor1.type:!=Author && contributor2.type:!=Author && contributor3.type:=Author

And then aggregate the results on the client-side

Greg

07:55 PM

Yea, that was what I was thinking. Thank you for the help.

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3015 threads (79% resolved)

Join Our Community

Similar Threads

Integrating Semantic Search with Typesense

Krish wants to integrate a semantic search functionality with typesense but struggles with the limitations. Kishore Nallan provides resources, clarifications and workarounds to the raised issues.

11mo

Phrase Search Relevancy and Weights Fix

Jan reported an issue with phrase search relevancy using Typesense Instantsearch Adapter. The problem occurred when searching phrases with double quotes. The team identified the issue to be related to weights and implemented a fix, improving the search results.

111

8mo

Fixing Multiple Document Retrieval in Typesense

Phil needed an efficient way to retrieve multiple documents by id. Kishore Nallan proposed a solution available in a pre-release build. After some bug fixing regarding id matching by Jason and Kishore Nallan, Phil successfully tested the solution.

26mo

Moving from Algolia to Typesense: Questions and Answers

Juan sought advice from Kishore Nallan about moving from Algolia to Typesense, handling MultiSearch, setting parameters, checking imported documents, and a specific syntax query.

22mo

Docsearch Scrapper Metadata Configuration and Filter Problem

Marcos faced issues with Docsearch scrapper not adding metadata attributes and filtering out documents without content. Jason helped fix the issue by updating the scraper and providing filtering instructions.

8mo