Re: AND-ing several JOINs

2025-03-13 Thread Josef Svoboda
Hello Mikhail, thank you very much! Your suggestion fixed the problem. Have a nice day, Josef Od: "Mikhail Khludnev" Komu: "users" Odeslané: Středa, 12. Březen 2025 19:58:23 Předmět: Re: AND-ing several JOINs It's hard to get to the core problem. Here'

Re: AND-ing several JOINs

2025-03-12 Thread Mikhail Khludnev
It's hard to get to the core problem. Here's just a blind guess: souldn't theses filters intersected before join avoiding cross-match? ie fq={!join fromIndex='authority' from='authority_str' to='authority_search_str_mv'}+occupation_facet:"básníci" +gender_facet:"žena"+full_text_str_mv:"Matrika naro

AND-ing several JOINs

2025-03-12 Thread Josef Svoboda
Hi all, I am using solr 9.3 (with VuFind). I want to use JOIN query to get a list of books written by certain authors (selected by facets). First, I do two preparatory steps to try this without JOIN and have some data to test. Step 1: Query authority DB (combining 4 facets) to get list of au