MK-1214: Search query logic has to be rethought for variables double tagged

[ymarcon]

Jira issue originally created by user @Rima-B:

Dans cette requete,in(Mlstr_area.Diseases,Neoplasms)),in(Mlstr_area.Physical_measures,Anthropomeasures)))), Cliquer sur Advanced puis sur le 11 de Nutrition/Fréle=> ca donne 0 Le 11 et 24 de la colonne Nutrition viennent de Anthropometry (variables double taggué), Ce n'est pas correct. [Requete](https://nightly-mica.obiba.org/#/search?display=coverage&bucket=study&query=variable(and(in(Mlstrarea.Lifestyle_behaviours,(Nutrition)),in(Mlstr_area.Physical_measures,Anthropo*measures)))). Donc quand on récupère les données sur Anthropometry, il faut remplir uniquement sa colonne correspondante.

Un autre exemple est que Requete1,in(Mlstr_area.Social_environment,Socnetwork)))&display=coverage&bucket=study) ne retourne rien En ajoutant le critère "Food Frequency Questionnaire" on obtient la [Requête2](https://nightly-mica.obiba.org/#/search?query=variable(or(and(in(Mlstrarea.Lifestyle_behaviours,(Alcohol,Nutrition)),in(Mlstr_area.Social_environment,Soc_network)),in(Mlstr_habits.Nutrition,FFQ)))&display=coverage&bucket=study) avec des count dans les colonne Alcohol et Nutrition car il ya des variables double taggées AlcoholFFQ)&display=coverage&bucket=study) et NutritionFFQ)&display=coverage&bucket=study)

Note: pb dans Coverage/Study, Coverage/Dataset

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale[bot]]

This issue has been automatically closed because no further activity occurs. Feel free to re-open it if it is still relevant.