Questions tagged [drupal-views]
Questions about CiviCRM's integration with the Views module in Drupal.
272
questions
0
votes
0
answers
10
views
CiviCRM SearchKit or Drupal Views to create exportable data that includes Grand Total Rows
I'm new to CiviCRM and Drupal and I'm trying to create a report for my end users which will contain the activities they have completed each month and will total some of the data captured in the ...
0
votes
0
answers
64
views
Drupal Views using CiviCRM Entity with relationships added takes too long to render results
I'm building a Drupal View to put ~1000 marker points with popup information on a Leaflet map using CiviCRM Entity and CiviCRM Entity Leaflet. The map is taking a very long time to render: over 3 ...
- 31
0
votes
0
answers
14
views
How do I display contact sub types in a View without the underscores?
I'm using CiviCRM 5.62.1, CiviRules 2.49, Drupal 7.98
I have created a View which creates a table with organisation name and contact sub type, grouped by region. However, on the display, the contact ...
- 11
1
vote
1
answer
31
views
Display CiviCRM user data alongside Drupal user data
Drupal 10 - CiviCRM 5.74.4
Using webform, authenticated users can create Drupal content of type 'Post'. The 'authored by' field is of course the logged in Drupal user.
I am using a view to display '...
- 359
1
vote
1
answer
49
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 ...
4
votes
1
answer
80
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....
- 1,070
1
vote
1
answer
33
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 (...
- 133
3
votes
1
answer
37
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,...
- 81
1
vote
0
answers
15
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 ...
- 1,322
0
votes
0
answers
36
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 ...
- 808
1
vote
1
answer
50
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 ...
- 808
1
vote
1
answer
84
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 ...
- 15.2k
2
votes
2
answers
97
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 ...
- 1,070
0
votes
0
answers
37
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 ...
- 1,239
1
vote
0
answers
33
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\...
- 21
0
votes
1
answer
20
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.
- 1,239
0
votes
0
answers
42
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 ...
- 53
0
votes
1
answer
71
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 ...
- 887
2
votes
0
answers
39
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 ...
- 53
0
votes
2
answers
74
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 ...
- 808
0
votes
1
answer
94
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 ...
- 1,183
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 ...
- 4,915
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 ...
- 493
1
vote
1
answer
93
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 ...
- 887
0
votes
1
answer
71
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 ...
- 1,183
2
votes
1
answer
93
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, ...
- 91
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 ...
- 697
1
vote
0
answers
33
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 ...
- 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 ...
- 1,183
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 ...
3
votes
1
answer
398
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 ...
- 530
3
votes
1
answer
107
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, ...
- 887
1
vote
1
answer
73
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 ...
- 946
0
votes
1
answer
68
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 ...
- 2,037
1
vote
1
answer
152
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. ...
0
votes
0
answers
117
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 ...
- 831
1
vote
1
answer
88
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 ...
3
votes
2
answers
108
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.) ...
- 2,488
0
votes
1
answer
227
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, ...
- 423
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
- 28.6k
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 ...
- 2,388
1
vote
1
answer
49
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 ...
user6274
1
vote
1
answer
82
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,...
- 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 &...
- 1,322
2
votes
1
answer
120
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 ...
- 1,821
0
votes
1
answer
93
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 ...
- 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 (...
- 189
1
vote
2
answers
108
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 ...
- 371
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 ...
- 3,014
2
votes
1
answer
73
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 ...
- 2,749