Questions tagged [drupal-views]
Questions about CiviCRM's integration with the Views module in Drupal.
262
questions
0
votes
1
answer
15
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 ...
- 569
1
vote
1
answer
67
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.1k
2
votes
2
answers
62
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 ...
- 980
0
votes
0
answers
21
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,209
1
vote
0
answers
26
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
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.
- 1,209
0
votes
0
answers
23
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
48
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 ...
- 857
2
votes
0
answers
32
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
44
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 ...
- 569
0
votes
1
answer
60
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,163
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,585
1
vote
1
answer
51
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 ...
- 463
1
vote
1
answer
59
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 ...
- 857
0
votes
1
answer
48
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,163
2
votes
1
answer
54
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, ...
- 81
0
votes
0
answers
20
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 ...
- 649
1
vote
0
answers
26
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 ...
- 934
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,163
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
320
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
94
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, ...
- 857
1
vote
1
answer
57
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 ...
- 934
0
votes
1
answer
55
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
111
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
51
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 ...
- 821
1
vote
1
answer
72
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
81
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
195
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, ...
- 401
1
vote
0
answers
22
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
- 28k
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,378
1
vote
1
answer
42
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 ...
- 823
1
vote
1
answer
73
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
14
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,282
2
votes
1
answer
73
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
70
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
21
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 (...
- 159
1
vote
2
answers
96
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
31
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 ...
- 2,908
2
votes
1
answer
69
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,729
1
vote
1
answer
22
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 ...
- 4,585
0
votes
1
answer
57
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 ...
- 2,729
1
vote
2
answers
62
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 ...
- 227
1
vote
1
answer
26
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?
- 2,729
0
votes
2
answers
19
views
Drupal Views needs settings file update for 5.24
I upgraded a client to 5.24 and it broke Drupal Views - my various views all had broken items. Views message was "This view has been automatically updated to fix missing relationships". However, ...
- 4,585
1
vote
1
answer
27
views
Expose CiviDiscount Fields to Drupal Views
I'm creating a Drupal view and would like to reference the discount end date field created by the CiviDiscount extension, but the only thing associated with that extension that's available as a field ...
- 325
0
votes
1
answer
26
views
Showing Financial Transaction Data with Contributions
I have created a drupal view of contributions. In this view i want it to show:
Date Contribution Created (CiviCRM Contributions: Date Received)
Financial Type (CiviCRM Contributions: Financial Type)
...
- 521
1
vote
1
answer
47
views
Base table not found for civicrm_contribution_page #201
On latest version of 8.x-3.x branch i get following error when try to add a view for contribution page
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'civicrmdb.civicrm_contribution_page' ...
2
votes
0
answers
24
views
Create a report or graph of the number of campaigns active in any particular month
In Civi + Drupal latest, we have a number of campaigns that last for a year or more. We know their start and end dates, but don't particularly want to manually change their status to show whether they ...
- 1,611
1
vote
2
answers
38
views
Auto-register people for events based on membership
We are going to introduce a new tier of membership to our organization that gives people unlimited access to certain category of events. So the event would typically cost $X, but if you are a member, ...
