SearchBuilder: contact search for tags with child-tags broken when using '=' operator
Searching for contact tags using the '=' operator is broken, if they have child tags: you get an SQL error. This problem was probably introduced with #1795 (closed).
- Create tag A
- Create tag B as a child of tag A
- Go to the search builder
- Search for contacts, tag(s), '=', tag A (see screenshot)
- Got an error "Fatal error: DB error".
DB Error with a something like
civicrm_entity_tag-60659ba2e61bf`.tag_id IN ( )
in the generated SQL.
Search should work :)
Could reproduce this on dmaster, version
5.37.alpha1. Also reproduces on
I think I know the culprit and am working on a patch.