Questions tagged [drupal-views]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
18 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 ...
user avatar
  • 1,109
1 vote
0 answers
11 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 ...
user avatar
  • 4,244
0 votes
0 answers
8 views

File attachment name passed to Views

Is there a way to get the name of a file that has been added via a custom field? We're adding attachments to an event and wanted to use the name of the file, as opposed to something generic like "...
user avatar
1 vote
1 answer
32 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 ...
user avatar
  • 379
1 vote
1 answer
20 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 ...
user avatar
  • 781
0 votes
1 answer
20 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 ...
user avatar
  • 1,109
2 votes
1 answer
18 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, ...
user avatar
0 votes
0 answers
19 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 ...
user avatar
1 vote
0 answers
21 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 ...
user avatar
  • 837
2 votes
2 answers
26 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 ...
user avatar
  • 1,109
0 votes
0 answers
24 views

CiviCrm Custom Field Sets With Multiple Records not able to use multiline formatting in Views (Drupal 9.2.2 Civi 5.39)

When using a custom field set with multiple records (this was on general contacts, but from what I can see multiple record field sets only work on contact type fields), something in the Entity module ...
user avatar
0 votes
1 answer
17 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 ...
user avatar
3 votes
1 answer
118 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 ...
user avatar
  • 530
3 votes
1 answer
62 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, ...
user avatar
  • 781
0 votes
0 answers
14 views

Include CiviCRM custom profile field in a Drupal view of event participants

Creating a Drupal view of Civi event participants. Custom fields for contacts are available for display but cannot find a way to list fields that are in profiles associated with event registrations. ...
user avatar
  • 1,139
1 vote
1 answer
43 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 ...
user avatar
  • 837
0 votes
1 answer
33 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 ...
user avatar
  • 1,839
1 vote
1 answer
72 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. ...
user avatar
0 votes
0 answers
28 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 ...
user avatar
1 vote
1 answer
48 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 ...
user avatar
3 votes
2 answers
41 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.) ...
user avatar
  • 2,366
0 votes
1 answer
102 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, ...
user avatar
1 vote
0 answers
17 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
user avatar
  • 26.9k
0 votes
1 answer
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 ...
user avatar
  • 2,252
1 vote
1 answer
32 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
67 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,...
user avatar
  • 2,366
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 &...
user avatar
2 votes
1 answer
67 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 ...
user avatar
  • 1,811
0 votes
1 answer
40 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 ...
user avatar
  • 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 (...
user avatar
  • 159
1 vote
2 answers
71 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 ...
user avatar
1 vote
1 answer
19 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 ...
user avatar
  • 2,836
2 votes
1 answer
61 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 ...
user avatar
1 vote
1 answer
21 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 ...
user avatar
  • 4,244
0 votes
1 answer
46 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 ...
user avatar
1 vote
2 answers
53 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 ...
user avatar
1 vote
1 answer
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?
user avatar
0 votes
2 answers
18 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, ...
user avatar
  • 4,244
1 vote
1 answer
26 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 ...
user avatar
0 votes
1 answer
21 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) ...
user avatar
  • 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' ...
user avatar
2 votes
0 answers
19 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 ...
user avatar
  • 1,561
1 vote
2 answers
31 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, ...
user avatar
2 votes
2 answers
57 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 ...
user avatar
  • 1,147
1 vote
0 answers
30 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. ...
user avatar
1 vote
2 answers
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 ...
user avatar
1 vote
1 answer
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 ...
user avatar
  • 113
2 votes
1 answer
89 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 ...
user avatar
  • 103
1 vote
1 answer
50 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 ...
user avatar
  • 4,244
2 votes
1 answer
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 ...
user avatar

1
2 3 4 5 6