Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [drupal-views]

Questions about CiviCRM's integration with the Views module in Drupal.

Filter by
Sorted by
Tagged with
1 vote
1 answer
29 views

With CiviCRM and Drupal, how can members view their own past contributions?

I'm migrating a site from Drupal 7 and Ubercart into Drupal 10 with CiviCRM (with CiviCRM Entity). The integration is great so far. In Ubercart, members had an Orders tab on their profile where they ...
Kristi Wachter's user avatar
2 votes
1 answer
34 views

Leaflet Map has just stopped working

I have built a map in Drupal Views using Leaflet and it's worked fine but seems to have stopped recently. I didn't check it on the recent update so it may have been then. CiviCRM v5.73.1 Drupal v10.2....
Rose Lanigan's user avatar
  • 1,040
1 vote
1 answer
25 views

Custom views filter with civicrm_entity Drupal 9

Need a hint. With civicrm_entity (3.5) i haven't the possibility to get multiple items in a views row. So i wrote a custom field and now I want to filter it. I think this works for the contact type (...
ItsMe's user avatar
  • 133
3 votes
1 answer
35 views

Drupal 7 Views broken with upgrade to CiviCRM v5.69.2

We have a Drupal 7 site which is days away from being ready to migrate to Drupal 10. Mapping the final rollover process in a dev environment, I had planned to upgrade CiviCRM on the D7 site to current,...
AlexT's user avatar
  • 81
1 vote
0 answers
13 views

Activity tags not available in Drupal views Drupal 10.x, CiviCRM 5.66

Don't know if I'm being thick or if this is a bug. Creating an Activities view in Drupal and looking for Activity tag relationship to bring in activity tags to the display and they only show for ...
Tony Horrocks's user avatar
0 votes
0 answers
32 views

Drupal 9/10 Views requires 'View All Contact' permission even if 'Edit' ACL exists

I am recreating Views in Drupal 9 (well, 10 now!). Using CiviCRM 5.66 with Drupal Webform and the webform civicrm module etc. On my Drupal 7 site I have a Staff ACL group that has 'Edit' rights to see ...
ChumKui's user avatar
  • 777
1 vote
1 answer
46 views

Drupal 9 View unable to display logged in User

I have an issue that I think relates to this question: Drupal 9 View Shows Permission Denied For CiviCRM Tables and possibly this: Views integration error on D9 The Views I have recreated from my D7 ...
ChumKui's user avatar
  • 777
1 vote
1 answer
81 views

Getting aggregation to work in D9/D10 Views with CiviCRM relationships

Using CiviCRM Entity commit 5295af29e5bac4575f991683b1c061b96a0e0713 (HEAD -> 8.x-3.x, origin/HEAD, origin/8.x-3.x) Trying to get this to aggregate properly -> But this should only show 3 rows ...
KarinG - Semper IT's user avatar
2 votes
2 answers
91 views

SearchKit - can I return the first four characters of a string?

I would like to run a report of UK postcodes with aggregation. The first four characters of the postcode give an area of perhaps a few square miles, the last three characters are specific to a street ...
Rose Lanigan's user avatar
  • 1,040
0 votes
0 answers
26 views

Documentation for Drupal 9 Views Advanced Relationship usage

Looking for documentation on D9 Views integration using advanced relationship features. Finding it difficult to determine which outcomes are a result of not understanding the various id joins and ...
Dave T's user avatar
  • 1,239
1 vote
0 answers
32 views

Error in civicrm entity leaflet Drupal 9.5

I get this error on my installation with Drupal 9.5.0, PHP 8.1.12, drupal/leaflet 10.0.5, drupal/civicrm_entity 3.3.0, civicrm/civicrm-core 5.56.1 : `Error : Call to undefined method Drupal\...
Jipi's user avatar
  • 21
0 votes
1 answer
19 views

Transfer a D7 view sql query to a D9 view

We are converting a number of D7 views (for reports) to D9 version. Is it possible to copy the sql query from a D7 view to use in a D9 view. The fields in Civi are the same.
Dave T's user avatar
  • 1,239
0 votes
0 answers
35 views

Filtering states and counties in Drupal views

Drupal 9 site with CiviCRM 5.5 I've got a Drupal view that shows all the Contacts and a search block on the side for filtering those contacts - name and state. What I'd like to do is also include the ...
zip_000's user avatar
  • 53
0 votes
1 answer
67 views

Database Connection Only Works Some of the Time

I have a CiviCRM instance that has its database hosted in RDS Aurora. This has worked well for several years. Recently I needed to restore from a copy of the Aurora cluster and I changed the name of ...
Josh's user avatar
  • 887
2 votes
0 answers
38 views

Drupal contextual filters and Civi Arrays

I'm trying to work out how to use a Drupal contextual filter on a Civi field that holds an array. So the filter seems like it can search for table.field = 'value1' and it can search for table.field IN ...
zip_000's user avatar
  • 53
0 votes
2 answers
63 views

Is it possbile to use Drupal Views to relate Webform Submissions and CiviCRM Contacts and Cases?

We use Drupal (7) Webforms integrated with CiviCRM for various use cases, particularly recruitment forms. I can create a Drupal View of either Webform Submissions OR CiviCRM Cases, but I cannot ...
ChumKui's user avatar
  • 777
0 votes
1 answer
72 views

Check Group Permission in Drupal Views

I have a Drupal 7 Views that produces a case activities report. It has columns like scheduled activity date, contact id, notes, etc. The user can search by contact id and all activities related to ...
Kristine's user avatar
  • 1,173
1 vote
0 answers
13 views

How to add logging table to Views?

I would like to add one of the logging tables to Drupal Views. The list of CiviCRM tables that is provided does not include these tables. I've tried adding one in Drupal's settings.php but it doesn't ...
Andy Clark's user avatar
  • 4,845
1 vote
1 answer
63 views

Include a CiviCRM role into Drupal View (custom dashboard)

I want to create a custom Dashboard with Drupal Views to substitute the built-in CiviCRM dashboard (because CiviCase dashboard shows cases for invisible contacts ). I want to set a contextual filter ...
emma's user avatar
  • 493
1 vote
1 answer
82 views

Minimum requirement: driver://host/database Error

My CiviCRM database cannot connect to my database server when it is loading a Drupal page that accesses CiviCRM through Views. We have been having all sorts of trouble with our Amazon Aurora instance ...
Josh's user avatar
  • 887
0 votes
1 answer
68 views

Activity Time Incorrect in Drupal Views

I just created a Drupal 7 Views report to show the date and time when the user created a case activity. The date is correct. However, I entered this activity at 11:09 am this morning, but Views show ...
Kristine's user avatar
  • 1,173
2 votes
1 answer
73 views

Drupal Views: can I use only date and not time when using a date filter?

Stupid question but I'm still getting into the Drupal side of Civi. I've made a View to show the participants of events in different programme areas. One of the filters is the start date of the event, ...
Jbeamish's user avatar
0 votes
0 answers
23 views

Approach to hiding the CiviCRM Contacts: Text Link field from non admins in a Drupal view

This is a bit of a long running annoyance that I'd like to overcome one way or another that involves rendering a CiviCRM Contacts View with a CiviCRM Contacts: Text Link field in the results. Most of ...
Andrew Wasson's user avatar
1 vote
0 answers
30 views

Get Drupal View to Display Label from Numeric Custom Select Field

I have a custom field in Civi that is a numeric select field. The select field values are numeric but the associated labels are text. I have created a Drupal view that displays the select field but it ...
Ben's user avatar
  • 946
2 votes
2 answers
32 views

Case Activity Reporter vs Creator

We have a backlog of activities that we hope to enter into our CiviCRM cases. We hired an individual to do data entry, but we want to distinguish between the "case reporter" (person who ...
Kristine's user avatar
  • 1,173
0 votes
1 answer
18 views

On drupal I have installed civicrm module.I want to show civicrm contact on drupal view.I have created a view for it, but it is not displaying contact

on drupal, I have installed CiviCRM, view module. I want to display a CiviCRM contact on drupal view. for that, I have created a view for CiviCRM contact, but on view, it is not showing CiviCRM ...
Aniket rane's user avatar
3 votes
1 answer
372 views

Drupal 9 Views: rich text fields render with all HTML tags visible

HTML tags added by CiviCRM's rich text editor is generated as plain text in Views output for fields like CiviEvent description or custom rich text fields. Stripping tags in the Views output doesn't ...
Nic's user avatar
  • 530
3 votes
1 answer
106 views

Drupal 9 View Shows Permission Denied For CiviCRM Tables

I have my Drupal 9 database and my CiviCRM database in two separate databases on the same Amazon MySQL Aurora instance. The setup in our dev environment is identical and is working perfectly. However, ...
Josh's user avatar
  • 887
1 vote
1 answer
68 views

Drupal View Not Rendering HTML From Activity Email Details Field

I am trying to display in a Drupal (8) view the content of emails that have been sent to contacts using the contact Send Email action. I am using the details field from the activity to show the ...
Ben's user avatar
  • 946
0 votes
1 answer
67 views

Drupal Views and Case Relationships

I'm setting up a vew of cases of type "x" and using views relationships to pull in cases relationships such as "Case Worker for" Client- as well as client details. If, I have a ...
Craig Almond's user avatar
  • 2,037
1 vote
1 answer
140 views

CiviCRM Data not showing in Views - Drupal 9, Shared DB

After running into problems setting up Views integration with CiviCRM installed on a separate database, I gave up and started my project over with CiviCRM installed on the same database as Drupal 9. ...
Austin Zumbro's user avatar
0 votes
0 answers
84 views

Is it possible to group by a date in a Drupal view?

I'm building a Drupal 7 View in which I want to aggregate contribution records for the year, grouping by month. But View's native aggregation option happens after the query is generated, so it's not ...
lcdservices's user avatar
1 vote
1 answer
85 views

Troubleshooting SELECT Privileges Issue with Drupal 9 Views Integration

I'm having an almost identical problem to this person (https://www.drupal.org/project/civicrm_entity/issues/3198146) so I'm hoping to get an answer for both of us. It looks like this may also be the ...
Austin Zumbro's user avatar
3 votes
2 answers
96 views

Is it possible to view smart group membership in Views?

I have a view set up to display the content of groups but it only works for viewing manual group membership, not smart groups. (I have the form set to require input rather than the basic form style.) ...
RayWright's user avatar
  • 2,488
0 votes
1 answer
219 views

How to get Views to work in CiviCRM on Drupal9 with separate CiviCRM database

On based the answers on this question How to get CiviCRM Views to work in Drupal 8 with separate CiviCRM database I'm trying to get work Views on Drupal9. Drupal9 and CiviCRM has different databases, ...
Pál Rudan's user avatar
1 vote
0 answers
28 views

VBO (Views Bulk Operations) with civicrm based Views for d8 and d9

Just wondering if anyone has any evidence of this working with d8/d9
petednz - fuzion's user avatar
  • 28.3k
0 votes
1 answer
24 views

Display nth payment of a recurring series?

Is there any way to display "nth Payment" of a recurring series? I am looking for a way to display with a contribution and/or line item result that this is the 3rd, 4th, 5th payment in the ...
Iowa Boy's user avatar
  • 2,388
1 vote
1 answer
48 views

Reason for no Views Relationship from CiviCRM Contact to Event Participant

I am trying to write a Drupal View (with VBO) to show CiviCRM Contacts with the Event Participant records which they are related to. But there is no suitable Relationship in the standard list. I ...
user avatar
1 vote
1 answer
81 views

Can you use VBO to update activities on cases?

I'd like to be able to bulk update the status of activities (that happen to be on a case) from a view. I can get the status to update but the problem is it loses the Case ID along the way. For example,...
RayWright's user avatar
  • 2,488
1 vote
1 answer
15 views

Drupal View query for select fields produces different results that CiviCRM

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 &...
Tony Horrocks's user avatar
2 votes
1 answer
96 views

How would I expose weight for a custom select field to Drupal Views for sorting?

I have a custom select option field with about 35 options. I'd like to be able to sort the field in Drupal Views by weight instead of value or name. I looked around for the views integration in the ...
pmoz's user avatar
  • 1,821
0 votes
1 answer
89 views

How to display CiviCRM Custom Fields in a Drupal 8 View

I've been not very experienced with CiviCRM. I try to get CiviCRM custom fields displayed in Views. I've installed Drupal 8.9.3., CiviCRM 5.28.3, CiviCRM Entity 8.x-3.0-beta1. Drupal and CiviCRM run ...
paul77's user avatar
  • 11
0 votes
1 answer
22 views

modules, drupal, civicrm updates

I have multiple updates to perform modules, civicrm and drupal. In what order should I do these updates? Views (for Drupal 7) (Security update) 7.x-3.20 to 7.x-3.24 CKEditor - WYSIWYG HTML editor (...
Hock's user avatar
  • 189
1 vote
2 answers
106 views

Drupal 8 CiviCRM Entity and Views activities

We have been working on Views, with Civi Entity, on Drupal 8. We are having an issue a list of Activities and filters. We only want to load Activities where the source contact is a particular ...
Oliver Gibson's user avatar
1 vote
1 answer
32 views

How can I create a mailing report with drupal views?

I would like to give access mailing report to one of my user that was sent to specific GROUP. from drupal permission I am not able to figure out an option to facilitate that. Therefore drupal views ...
Tapash's user avatar
  • 3,004
2 votes
1 answer
71 views

I can see Age in a Contact Summary. How can I add Age to a Profile?

I can see Age for a contact in the Contact Summary screen, which is not a built-in field, but is apparently calculated from the Birth Date field. I can add the Birth Date field to a Profile. How can I ...
Joe McLaughlin's user avatar
1 vote
1 answer
24 views

How to access civicrm_subscription_history in Views?

I'd like to extract contacts who have been added to a certain group for a given date or date range. This information is in table civicrm_subscription_history which is included in my Drupal settings ...
Andy Clark's user avatar
  • 4,845
0 votes
1 answer
64 views

How do I hide or re-size the Event Calendar in a CiviCRM Dashboard?

I'm using CiviCRM 5.25 and Drupal 7. I've created two Views in Drupal and added them as Dashlets to my CiviCRM Dashboard. After adding those, I now see an Event Calendar at the bottom of my ...
Joe McLaughlin's user avatar
1 vote
2 answers
69 views

Baffled by Views database error on new install

Hours-old install of CiviCRM 5.25 under Backdrop 1.9. I've gotten as far as putting in the Board of Directors with dummy bio information, which I was trying to use to generate a View with a page ...
Jeff Porten's user avatar
1 vote
1 answer
27 views

In order to see Activities fields in Views - do I need to add/install CiviCRM Entity?

I want to add Activities fields or Relationships in Drupal Views. Do I need to add/install CiviCRM Entity?
Joe McLaughlin's user avatar

1
2 3 4 5 6