# Report on Events with or without filters **URL:** \ **Category:** Help\ **Created:** [October 4, 2020, 3:19am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779 "2020-10-04T03:19:20Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![les61](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@les61](https://gramps.discourse.group/u/les61)\ **Post date:** [October 4, 2020, 3:19am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/1 "2020-10-04T03:19:20Z")
GrampsAIO64-5.1.2-1 & Windows 10. I would like to be able to create a report on all my events in the database showing in particular the Event Type, Name and Role (although date and location would be useful). PDF or screen is OK but would prefer to csv. Also being able to filter by Event type would be even better. Have looked and cannot seem to fin anything suitable in Gramps or Third Party add ons. Many thanks in advance. Les ---
**Author:** ![anon9092048](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@anon9092048](https://gramps.discourse.group/u/anon9092048)\ **Post date:** [October 4, 2020, 3:37am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/2 "2020-10-04T03:37:17Z")
> [@les61](#): > > report on all my events in the database On most Category List Views, displayed data maybe be exported as a Spreadsheet or CSV file, choose via the [**Family Trees -\>Export View…**](https://gramps-project.org/wiki/index.php/Gramps_5.1_Wiki_Manual_-_Settings#Export_View) menu command. ---
**Author:** ![les61](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@les61](https://gramps.discourse.group/u/les61)\ **Post date:** [October 4, 2020, 3:53am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/3 "2020-10-04T03:53:57Z")
But I cannot find a view that shows that information. ☹ ---
**Author:** ![anon9092048](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@anon9092048](https://gramps.discourse.group/u/anon9092048)\ **Post date:** [October 4, 2020, 4:14am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/4 "2020-10-04T04:14:38Z")
> [@anon9092048](#): > > Category List Views This includes the [Events List View](https://gramps-project.org/wiki/index.php/Gramps_5.1_Wiki_Manual_-_Categories#Events_Category) and the other category list views mentioned [here](https://gramps-project.org/wiki/index.php/Gramps_5.1_Wiki_Manual_-_Categories#Categories_of_the_Navigator) ![](https://global.discourse-cdn.com/free1/uploads/gramps/original/1X/37979a6944229de0292587ba56760944e0c4237b.png) ---
**Author:** ![les61](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@les61](https://gramps.discourse.group/u/les61)\ **Post date:** [October 4, 2020, 8:56am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/5 "2020-10-04T08:56:17Z")
Thanks but this does not show the “Role” that I want to show. I want to make sure that there is a “bride” and “Groom” for each marriage event. ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [October 4, 2020, 8:56am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/6 "2020-10-04T08:56:31Z")
It doesn’t have Role as one of the columns though. That’s because you can have multiple participants on Shared Events. ---
**Author:** ![PLegoux](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/plegoux/32/413_2.png) [@PLegoux](https://gramps.discourse.group/u/PLegoux)\ **Post date:** [October 4, 2020, 12:08pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/7 "2020-10-04T12:08:58Z")
I’m not sure of that but it seems to me there it’s no people and events csv export displaying role of people in these events too ---
**Author:** ![DaveSch](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/davesch/32/40_2.png) [@DaveSch](https://gramps.discourse.group/u/DaveSch)\ **Post date:** [October 4, 2020, 12:11pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/8 "2020-10-04T12:11:32Z")
> [@les61](#): > > I want to make sure that there is a “bride” and “Groom” for each marriage event. Then you want the Family view. This will show the two people attached to each family and the Relationship of the Family. I have some Families where the Mother and Father are unknown and left empty. This happens when I know two or more people are siblings but have been unable to find the parents. I Tag these families as “Related Siblings (unknown) parents)” and color code the Tag as Red. This easily tells me that the parents are empty and I know why. I do the same for same-sex families with a color coded Tag. This tells me that the gender of the person will not match the category “Father” or “Mother”. ---
**Author:** ![GeorgeWilmes](https://avatars.discourse-cdn.com/v4/letter/g/c57346/32.png) [@GeorgeWilmes](https://gramps.discourse.group/u/GeorgeWilmes)\ **Post date:** [October 4, 2020, 4:35pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/9 "2020-10-04T16:35:54Z")
> [@les61](#): > > want to make sure that there is a “bride” and “Groom” for each marriage event. If what you really want is to identify events that are missing either the “Bride” or “Groom” **role** (or both), then you can create a custom filter in the Family view, I think something like this: Custom filter: “Families without a bride and/or groom role” (or whatever you wish to name it) Rule: “Families with events with the \” Role=“Bride”;Inverse=1 (Does NOT match with selected Role) Rule: “Families with events with the \” Role=“Groom”;Inverse=1 (Does NOT match with selected Role) Options: “At least one rule must apply” Personally I don’t use those two event roles, so I can’t test it without creating some other data, but it should at least get you started if that’s what you’re looking for. It might also return families that have no marriage event at all. Of course, you could add more rules to the custom filter. The logic starts to get tricky when you have a mix of positive and negative conditions. ---
**Author:** ![DaveSch](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/davesch/32/40_2.png) [@DaveSch](https://gramps.discourse.group/u/DaveSch)\ **Post date:** [October 4, 2020, 4:57pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/10 "2020-10-04T16:57:53Z")
I do not think it is a matter of an event with a particular role. In the Family editor, do the Father/partner1 and Mother/partner2 slots have people in them. I just a quick look and there is no filter in the Family Filter editor that checks for empty slots. I just do a sort on the Father field in the family list and then do the same for Mother. When the slot is empty, these records get sent to the top of the list. ---
**Author:** ![GeorgeWilmes](https://avatars.discourse-cdn.com/v4/letter/g/c57346/32.png) [@GeorgeWilmes](https://gramps.discourse.group/u/GeorgeWilmes)\ **Post date:** [October 4, 2020, 7:20pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/12 "2020-10-04T19:20:25Z")
> [@StoltHD](#): > > an easy way to see Events with multiple roles and what type of roles those was Would it help to have a new category view, in which the columns included participant (person name), event type, event date, role, etc.? It would be different than the existing Events view because there would be a separate row for each participant, for example: Type - Date - Participant - Role Baptism - 1900-01-01 - John Doe - godfather Baptism - 1900-01-01 - Jane Doe - godmother Baptism - 1900-01-01 - etc. (additional participants) As with other views, the columns could be reordered as desired, and custom filters could be applied. An alternative approach would be to enhance the existing Events view such that the Main Participants column included not only the person names but also the roles, for example: Type - Date - Main Participants Baptism - 1900-01-01 - John Doe (godfather), Jane Doe (godmother), etc. (additional participants) But that might be harder to filter? ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [October 4, 2020, 9:03pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/14 "2020-10-04T21:03:34Z")
> [@GeorgeWilmes](#): > > Would it help to have a new category view, in which the columns included participant (person name), event type, event date, role, etc.? Adding another Event View mode might be a good thing. The current Event view is not a flat list. It sub-groups ‘share’ references for an Event. But that is a composited alias of those References in the Main Participants. This creates a display ambiguity when Shared References have different Privacy setting for different Roles. Perhaps there should be a mode that displayd one reference per row. Such a View could also include a Role column. All the table views have filtered & customizable CSV & OpenDocument Spreadsheet formats in their Export View… option. So filtering, Configuration & that feature addresses a lot of the basic data interchange issues. ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [October 4, 2020, 9:30pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/17 "2020-10-04T21:30:25Z")
> [@StoltHD](#): > > Problem with the csv export of the view list are that there are no references in them, so without extensive work in excel or Openrefine, they cant be used to much… and it is no way to import changed data… I suppose if there was a _truly flat_ mode Event view, with 1 row per Reference & Role column, it would make sense to have a Reference ID column option in addition to the Event ID column. ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [October 4, 2020, 9:44pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/19 "2020-10-04T21:44:27Z")
> [@StoltHD](#): > > would be easier with export/import of an RDS/OWL standardized file Probably. But adding another View mode with no consolidation & 2 more columns would be dead simple. Adding a new format is a major development investment. ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [October 4, 2020, 10:03pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/21 "2020-10-04T22:03:35Z")
When you say ‘not that much’, you’re not thinking like a programmer. To make a modified mode, it just requires duplicating a module and maybe adding a half dozen lines of codes and changing values in probably 20 more. It wouldn’t even take any design work or crosswalk analysis. ---
**Author:** ![les61](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@les61](https://gramps.discourse.group/u/les61)\ **Post date:** [October 4, 2020, 10:38pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/22 "2020-10-04T22:38:51Z")
Well looks like I opened a can of worms with my question. In the short term I have a work around. If I create a “Complete Individual Report” it shows those with a “Marriage” event and also if they are “Bride”, “Groom”, etc or nothing. If the report is in pdf or text, etc I can search for the word “Marriage” and check it has Bride, Groom, etc. Long way but workable. ---
**Author:** ![les61](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@les61](https://gramps.discourse.group/u/les61)\ **Post date:** [October 4, 2020, 11:29pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/24 "2020-10-04T23:29:42Z")
Thing is I am NOT a programmer so am only looking at what works for me. If someone else can do something I would be most appreciated\> I tried to view in SQLite but the “Role” , “Event type”, etc does not show. On the basis that the software is free I am more than happy with what I have and what I can do now. We can all have a wish list but unless you want to pay for software or do the work yourself we should be thankful for what we have. I have only been a member for a few weeks so am not aware of the BLOBS you talk about. ---
**Author:** ![GeorgeWilmes](https://avatars.discourse-cdn.com/v4/letter/g/c57346/32.png) [@GeorgeWilmes](https://gramps.discourse.group/u/GeorgeWilmes)\ **Post date:** [October 5, 2020, 12:45am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/26 "2020-10-05T00:45:16Z")
> [@les61](#): > > I tried to view in SQLite but the “Role” , “Event type”, etc does not show. If you are referring to the SQLite export – see the notes [here](https://gramps.discourse.group/t/extracting-constants-from-python-code/675/6) for a way to fix it. ---
**Author:** ![les61](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@les61](https://gramps.discourse.group/u/les61)\ **Post date:** [October 6, 2020, 12:57am UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/27 "2020-10-06T00:57:12Z")
George I tried to make the changes you listed and have two issues: 1/ Could not find the section for : - Changed these lines in export\_data(): # the\_type[0], the\_type[1], change, the\_type[0], str(FamilyRelType(the\_type)), change, # handle, gid, the\_type[0], the\_type[1], handle, gid, the\_type[0], str(RepositoryType(the\_type)), # place\_type[0], place\_type[1], place\_type[0], str(PlaceType(place\_type)), 2/ When I did save the changes and restarted GRAMPS and tried to do an export the SQLite option did not show. Restored the original zip file and restarted and works fine (but naturally no changes). Any suggestions? Thanks Les ---
**Author:** ![GeorgeWilmes](https://avatars.discourse-cdn.com/v4/letter/g/c57346/32.png) [@GeorgeWilmes](https://gramps.discourse.group/u/GeorgeWilmes)\ **Post date:** [October 6, 2020, 1:14pm UTC](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779/28 "2020-10-06T13:14:44Z")
Les, sorry about that, it should say “exportData()” rather than “export\_data()”. I’m unable to edit the original post since it’s closed now. As to why the SQLite option didn’t show, there must be a typo or something causing it not load, and I don’t know how to debug other than trial and error. Did you add all of those “from gramps. … import …” lines right after the three that were already there? [Next page](https://gramps.discourse.group/t/report-on-events-with-or-without-filters/779.md?page=2)