Answers.Body: <p>If you haven't upgraded Civi to 5.28.4 than apply below patch</p>
  <p><a href="https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/617.patch" rel="nofollow noreferrer">https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/617.patch</a></p>
  <p><a href="https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/618.patch" rel="nofollow noreferrer">https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/618.patch</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-13T16:40:38.007Z
Answers.LastActivityDate: 2020-09-13T16:40:38.007Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I have a civicrm custom field for languages spoken like</p>
  <pre><code>English
  French
  German
  ...
  </code></pre>
  <p>You can have multiple selections.</p>
  <p>SO a contact might select</p>
  <pre><code>English
  French
  </code></pre>
  <p>from the listing.</p>
  <p>If I do a search for &quot;French&quot; in CiviCRM it returns contacts correctly.</p>
  <p>If I do it in Drupal via an exposed filter in a View, it returns no contacts.</p>
  <p>If I do a Drupal search for English, it returns the contact.</p>
  <p>It seems like it only returns a result if the item being searched is the first in the list - in this case English.</p>
  <p>Ive tried allow multiple selection in the View filter and so on, with no result.</p>
  <p>I want it to produce the correct results.</p>
  <p>Any ideas? Thanks as always.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-13T16:37:16.967Z
Comments.Text: What is your civi version?
Comments.UserDisplayName: Pradeep Nayak
Tags: <drupal-views><multiple-choice>
Title: Drupal View query for select fields produces different results that CiviCRM
ThreadText: # Drupal View query for select fields produces different results that CiviCRM
  
  (Asked by: username_0 on 2020-09-13)
  
  I have a civicrm custom field for languages spoken like
  
  ```
  English
  French
  German
  ...
  
  ```
  
  You can have multiple selections.
  
  SO a contact might select
  
  ```
  English
  French
  
  ```
  
  from the listing.
  
  If I do a search for "French" in CiviCRM it returns contacts correctly.
  
  If I do it in Drupal via an exposed filter in a View, it returns no contacts.
  
  If I do a Drupal search for English, it returns the contact.
  
  It seems like it only returns a result if the item being searched is the first in the list - in this case English.
  
  Ive tried allow multiple selection in the View filter and so on, with no result.
  
  I want it to produce the correct results.
  
  Any ideas? Thanks as always.
  
  **Tags:** drupal-views, multiple-choice
  
  > **Comments:**
  > **username_1**: What is your civi version?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-09-13. Score: 0
  
  If you haven't upgraded Civi to 5.28.4 than apply below patch
  
  <https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/617.patch>
  
  <https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/618.patch>
  
  
  ---
  
  