List of everyone buried in specific cemetery #placedetails

#1 · 2023-06-25, 7:45 am

Note: Using RM7

I want to create a list of all people in my database who are buried in a specific cemetery. The cemetery names are stored in placedetails. I found a discussion in the forum called

Script help #placedetails

that might be similar to what I'm trying to do, but I couldn't really understand it or figure out how to apply it to my need. I used the script below, but only got a list of placeid numbers. How do I get a list of names?

SELECT PlaceID FROM PlaceTable
WHERE PlaceType = 2 -- Place Detail
AND Name LIKE '%Calvary%' -- % is the wildcard like * is in other systems
;

Can anyone tell me what the script would be for this?

Thanks as always to those who read and respond to my crazy posts!

Jaime

#2 · 2023-06-25, 10:58 am

This request seems unnecessary as it can be answered from within the RM7 UI. Create a Group and use the group to filter the Fact List or Individual List or People View...

kevync has reacted to this post.

#3 · 2023-06-26, 4:34 am

Thanks Tom. I need to study up on all of that. I use groups for different things - mainly exporting to share a portion of my tree - but haven't done much filtering. Back to school, Jaime!