Drupal views group filter is not working

When i create the Group filter for contact sub-type there are no results coming. The like query is being generated as "civicrm_contact.contact_sub_type LIKE '%%'" Please see the images below

added needs:concept approval triaged type:proposal labels

I am happy to have a look at this issue. Could someone assign it to me? Because I cannot assign myself.

I have checked this in Drupal 7 and it is working for me.

@vakeesan26 could you give some more info on which drupal version you are on? Which views version? Which civicrm version?

Drupal 7.60 , Views 7.x-3.20 and CiviCRM 5.6.0

Make sure you are choosing Group Filter on contact sub type exposed filter.

Thanks, I have fixed it with this PR: https://github.com/civicrm/civicrm-drupal/pull/548

Hi,

Thank you for raising an issue to help improve CiviCRM. We're sorry about this, but this particular issue has gone unnoticed for quite some time.

We would like to ask you to help us out and determine whether this issue should be kept open:

• If this issue is reporting a bug, can you attempt to reproduce on the latest version of CiviCRM?
• If this issue is proposing a new feature, can you verify whether the feature proposal is still relevant? Did it get the concept-approved label? Have other people also shown interest? Could it be implemented as an extension?

If yes,

• Is it something that you could help implement, either by sending a patch or hiring someone who can?
• Would you be willing to fund the work, either through a CiviCRM partner, or the Core Team?

Please feel free to comment or re-open the issue. We understand that automatic responses are annoying, but as the project evolves, we need a bit of help to triage and prioritise the most relevant issues.

Thank you for your help

P.S. This is an automated message. See infra/gitlab issue 20.

closed

@totten @josh do you know why this issue is closed? And why there accompanied PR is not merged nor got any feedback? This feels very inpolite to people, like me, who contribute to the community.

reopened

@jaapjansma This is how silly the bot is: https://lab.civicrm.org/infra/gitlab-reminders/-/blob/master/gitlab-reminders.php

as the message says though, it's a triage-helper bot. If the issue is still relevant, re-open it.

do you know why this issue is closed?

The bot closed it.

And why there accompanied PR is not merged nor got any feedback?

Because we have a shortage of reviewers in the community.

I share your feeling of frustration about that. I often have to ask/beg people to review my PRs. I don't know the solution, but that's the current situation.

Re the bot: I think it's a good idea to have a bot nudging us about old issues. There are probably many issues that are already fixed with merged PRs that we forgot to close.

@vakeesan26 it looks like you logged an issue & Jaap worked on a fix - but we missed the step where you test the fix & it got lost - I don't suppose you remember if you ever tested it. Obviously it was kind of Jaap to work on the issue you logged & it's a shame it fell between the cracks

Hi

I have tested this issue in 5.53.0 , The issue still persists.

Thank you

@vakeesan26 Does the issue persist with the PR applied to 5.53.0?

Hi , It is working as expected with PR applied on 5.53.0

changed milestone to %5.55.0

changed milestone to %5.54.0

Thank you @vakeesan26 @jaapjansma - the PR has been merged.

(I set the version as 5.54 because I think the RC has not been branched yet)

closed