Something went wrong while fetching related merge requests.
Tags: AND au lieu de OR
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
- Show closed items
GraphQL error: The resource that you are attempting to access does not exist or you don't have permission to perform this action
No child items are currently open.
Link issues together to show that they're related.
Learn more.
Activity
-
Newest first Oldest first
-
Show all activity Show comments only Show history only
- Contributor
Edit: La requête qui est générée quand on essaye de faire un join sur la même table deux fois.
SELECT tag_ref.id, tag_ref.tag_id, tag_ref.table_name, tag_ref.record_id, tag.id, tag.name, patient.id, patient.first_name, patient.last_name, patient.birth, patient.info, patient.id_label, patient.creator, patient.sample_set_id FROM tag_ref, tag, patient WHERE ( (patient.id > 0) AND ( ( ( (tag.name = 'blahlblah') AND (tag_ref.tag_id = tag.id) ) AND (tag_ref.table_name = 'patient') ) AND (tag_ref.record_id = patient.id) ) );
Edited by Ryan Herbert - Owner
@RyanHerb a peut-être une solution à base de
group by
et dehaving
en comptant que le nombre de tags différents recherchés correspond bien au nombre de recherche (attention aux cas où un même tag se trouve plusieurs fois dans la description). - Ryan Herbert mentioned in commit ba625d0b
mentioned in commit ba625d0b
- Ryan Herbert mentioned in merge request !77 (merged)
mentioned in merge request !77 (merged)
- Author Owner
@RyanHerb : c'est bien AND actuellement, pas très propre mais cela marche.
merci !
- Mathieu Giraud closed
closed
- Ryan Herbert mentioned in commit c422959e
mentioned in commit c422959e
- Ryan Herbert mentioned in commit c248d0d2
mentioned in commit c248d0d2
- Ryan Herbert mentioned in commit d2455f32
mentioned in commit d2455f32
Please register or sign in to reply