Questions tagged [drupal-views]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
15 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 ...
0
votes
1answer
16 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 ...
1
vote
1answer
40 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
0answers
14 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 ...
1
vote
0answers
26 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
2answers
26 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.) ...
0
votes
1answer
41 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, ...
1
vote
0answers
9 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
0
votes
1answer
23 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 ...
1
vote
1answer
29 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 ...
1
vote
1answer
49 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,...
1
vote
1answer
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 &...
2
votes
1answer
43 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 ...
0
votes
1answer
21 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 ...
0
votes
1answer
20 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 (...
1
vote
2answers
44 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 ...
1
vote
1answer
17 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
votes
1answer
47 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 ...
1
vote
1answer
19 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 ...
0
votes
1answer
29 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 ...
1
vote
2answers
48 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 ...
1
vote
1answer
22 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?
0
votes
2answers
17 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, ...
1
vote
1answer
23 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 ...
0
votes
1answer
19 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) ...
1
vote
1answer
39 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
0answers
13 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
vote
2answers
22 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, ...
2
votes
2answers
46 views

Drupal views: text search in country name

When viewing CiviCRM contacts in a Drupal view, you can filter on the Address:Country , but the filter widget proposes you to filter on one or more of the 300+ countries in CiviCRM. When exposing ...
1
vote
0answers
20 views

Relative date filters in drupal views

Is it possible to use relative date filters as a drupal views filter. I mean filter on something like registration date = this.fiscal_year I am playing with it but do not seem to get it to work. ...
1
vote
2answers
10 views

Missing participant is_test field in drupal views

We would like to use the participant is_test field in drupal views but cannot seem to do so. 1. Would anyone be able to tell us how we can do so? or 2. Can anyone show us with an example that will ...
1
vote
1answer
12 views

Display different profile (in Drupal) based on CiviGroup (or tag)

Thanks in advance Drupal 7 / CiviCRM 5.13 I am looking for a way to display different profiles, in Drupal, based on different groups that the contact belongs to in Civi (or based on different tags if ...
2
votes
1answer
85 views

Issue with Drupal 8 CiviCRM Views + CiviCRM event

Does anyone know how to create a Drupal view to show only future/upcoming CiviCRM events in Drupal 8? I tried by adding the Event start date as filter but it doesn't provide the filtering options to ...
1
vote
1answer
47 views

How to embed or attach a list of contacts in an email?

My users want to send an email from Civi that will have a particular group of contacts embedded in it or as an attachment. The group is featured in a report, so emailing the report seems like the ...
2
votes
1answer
21 views

Drupal Views + Multiple CiviCRM relationships of same type

I see many stack exchange questions about views & relationships but none like this. A person may attend many schools in his/her lifetime. Contact A "is a student at" Contact B (college, active ...
2
votes
3answers
200 views

Prefill webform with civicrm activity data

I want to prefill a webform with data from a specific CiviCRM activity in order to edit the activity using the webform. I want to do this by having an "Edit" link in a Drupal View of CiviCRM ...
0
votes
0answers
49 views

Why is my Views display limited to 17 lines

One of my Views displays only 17 lines when I open it. I have to refresh the display to get all the lines. How can I fix that ? Screen 1 : parameterization : Screen 2 : display Screen 3 : after ...
0
votes
1answer
92 views

Quick and dirty decoupled CiviCRM with cron and export/import?

Working with an architecture of Drupal 8 running Open Social, and Backdrop running CiviCRM. Currently both virtual hosts on the same server, with separate mysql databases. The key issue: after tearing ...
0
votes
1answer
20 views

Drupal View adding trailing zeros to Activity ID

I have a Drupal View displayed as a block, which includes a link to a webform using the Activity ID and the Contact ID for logged in users. It's been working fine but now I find that it's adding ...
2
votes
2answers
41 views

Replacing the Contact Dashboard with Views

Has anyone started a project of creating views to replace the contact Dashboard that would show: Recurring Contributions Memberships Donations Event Attendance etc. I am considering starting this ...
1
vote
1answer
77 views

does anyone have a recipe for a Drupal 8 Views Calendar to show civi events or civi activities

Title pretty much says it. want a View Calendar for Civi Event and also for Civi Activity using drupal 8 Was following the second recipe at https://evolvingweb.ca/blog/creating-events-calendar-drupal-...
1
vote
1answer
33 views

Civi Campaign in views

When changing a campaign name it updates in civicrm but not in views anyone have any suggestions how to get it to update in drupal views? where is civicampaign name stored?
1
vote
0answers
24 views

Strange php error after updating old view

As part of our migration to latest civi for numerous sites, we had to make an adjustment to a drupal calendar views on the existing, live older civi site (4.0.5). (We're upgrading all sites to 5.12 -...
1
vote
0answers
25 views

View of CiviCRM Events containing CiviCRM Contact Data

I need to set up a list of Upcoming Events in Drupal 7 with a View of CiviCRM Events Entity. I need to redirect the logged user to a Drupal Custom Node after the user has selected a specific event to ...
1
vote
1answer
24 views

How to fix it? By pressing “Print Summary”, there are 2 extra blank pages printed

By pressing "Print Summary", there are 2 extra blank pages printed. One of them is before the content and the other is after. How can I make them disappear? I'm using CiviCRM version 5.10.4. Thanks.
1
vote
1answer
28 views

What is the grey box on selecting Webform Payment Processor?

Specific Issue I have a View that contains a Views Block Area as one of its rows. In each of these Views Block Areas I have a Webform that contains a CiviCRM Payment Processor. I want the Payment ...
4
votes
2answers
199 views

Calculate Contact age in a Drupal view

I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field. Anyone know of a module/ combination of modules that will allow me to calculate age in ...
1
vote
1answer
34 views

Can't see events

After recent update (I think to 5.10.2) events don't show up. Interestingly, I can see the pager (1 2 next last) but not the events themselves. I can see the events in the Event Dashboard. When I try ...
1
vote
1answer
40 views

VBO (Views Bulk Operations) - Bulk Operations field not showing in field list

Trying to use VBO in a view of CiviCRM contributions, but when I try to add the Bulk Operations field, it is not listed in the pop-up field list so can't be added. The rest of the view works (ie can ...
0
votes
1answer
25 views

How to access the crm files

We would like to change the minor changes in the content page and webform design, dont know how to access the file. How to get the FTP files from my site need to add custom css file. Any help please.

1
2 3 4 5