Filtering in Variable Explorer needs tweaking (combination of search filters, topic filters and cohort filters, and how search filters behave)

[EleanorHyde-UMCG]

What version of EMX2 are you using (see footer)
Software version: v10.77.4

Describe the bug
When filtering on variables using search filters, cohort filters and topic filters, the combination is not applied correctly, meaning that too many variables are shown.

Agreed-upon query is:
(search bar criteria) AND (topic criteria) AND (cohort criteria)

The query within each place to filter is as follows:
search bar: additive, searchterm1 AND searchterm2
topics: topic1 OR topic2 (or both)
cohorts: cohort1 OR cohort 2 (or both)

To Reproduce
Steps to reproduce the behavior:

1. Go to https://data-catalogue-acc.molgeniscloud.org/testCatalogue/ssr-catalogue/all/variables
2. Choose subtopic ‘family and household structure’ and subtopic ‘language’ (under 'socio-demographic...'--> you get 12 vars
3. Add ‘birth’ in search bar --> list reduces to 3 vars
4. Select cohorts ‘NFBC1966’, ‘PELAGIE’ and ‘SEPAGES’ --> all 3 vars are still shown
5. Go to the Harmonisation Matrix (button 'Harmonisations'), see that all 3 vars are still shown
6. Remove the selection of cohort PELAGIE
7. See error: all 3 variables are still shown even though NFBC1966 and SEPAGES only have mappings to cohab_0.

Expected behavior
Only cohab_0 should be shown.
WILL FIND OTHER TEST DATA EXAMPLES LATER!

Screenshots

Desktop (please complete the following information):

• OS: Windows 10
• Browser Chrome

[EleanorHyde-UMCG]

@mswertz this is the bug we discussed yesterday. Currently in the backlog but definitely important enough to be done this sprint.

[EleanorHyde-UMCG]

see #3866

[EleanorHyde-UMCG]

In #3866 we said: cohorts which have been actively chosen are kept in the list, regardless of whether or not they have mappings to the variables in question.

This situation is subtly different but also rather similar. Do we need to say that we keep variables in the list which have been actively chosen, regardless of whether they have been mapped to by the selected cohorts? If so, this will throw an awful lot out of kilter...

[EleanorHyde-UMCG]

In #3866 we said: cohorts which have been actively chosen are kept in the list, regardless of whether or not they have mappings to the variables in question.

This situation is subtly different but also rather similar. Do we need to say that we keep variables in the list which have been actively chosen, regardless of whether they have been mapped to by the selected cohorts? If so, this will throw an awful lot out of kilter...

NO WE ARE NOT DOING THIS! Keep as is: only show variables with mappings. I have tested the search filter 'term A AND term B' and it looks good. Further testing in acc will most likely bear this out.