Exploit your RootsMagic family tree database with SQLite Tools
Description One query lists all the media files in the RM4 Media Gallery and the ID of the Person, Family, Event, Source, Citation or Place to which each is linked. Used in conjunction with other queries, one can look up the media item or find the details about the item to which the media are…
2021-11-22 Compatible with #RM8 Have you ever wished to be able to look at all the facts in your family tree database that happened within a day’s horseride of a certain location? Until RootsMagic contains such a report, this adaptation of the LifeLines query helps you view your events for any geographic area in addition…
The LifeLines query lists all events for all persons whether in a database tree or not, including shared facts, date, fact detail, site and place, MRIN, other parties, duplication indicator and IsPrivate flag (new!). Sorted by RIN and Sort Date. With the right SQLite manager, can filter results for one person. It’s a successor to…
FactsHavingPlaceDetails3.sql Returns all Places with Place Details and the Persons or Families (couples) and their Facts, including Shared events, using the Place Detail. Results from FactsHavingPlaceDetails3 as displayed by SQLiteSpy FactsHavingPlaceDetails2.sql Returns all Places with Place Details and the Persons or Families (couples) and their Facts using the Place Detail. No shared events. A comprehensive…