Its been baffling me but how do you quickly find a couple, such as
|Father|John Goodyer|
|Mother|Sarah|
Just too many John’s and the only other info is birth of daughter Christened in 1734 with no christian name
Using other database types such as mysql, I used to be able to enter “John Goodyer & Sarah” on command line, as a logic ‘and’. Is this possible with sqlite within Rootsmagic.
Thanks for quick response.
That search only gives one person. The Advanced search is also not quite there as it only searches one person. I am looking for a dual search ie father + (logical and) mother, like find all John’s and Sarah’s.
Similar Mysql command
SELECT * FROM MY FAMILY TREE
WHERE FatherChristianName LIKE ‘John’ AND MotherChristianName LIKE ‘Sarah’;
Also maybe
SELECT * FROM MY FAMILY TREE
WHERE FatherChristianName LIKE ‘John’ AND FatherSurnameName LIKE ‘Goodyer’ AND MotherChristianName LIKE ‘Sarah’;
You obviously can not do it from within Rootsmagic, but I am curious as to whether you have tried it using the SQLite CLI? I have never tried such a thing, and it may note be ideal but it is worth a try.
Yeah, I was just answering the “[a] couple” question which works.
Don’t believe you’ll find anything couple-related where Given name is the discriminant
search term. Additionally, most views and reports manifest name blocks as Surname, Given coupled together in a single field.
It can be done with SQLite. I use an SQLite manager rather than am SQLite command line interface, but the principal is the same. The query would be a little more complex than the example you gave. One row of RM’s FamilyTable includes RIN numbers for both the father and mother. You would need include a JOIN from the FatherID in the FamilyTable to the NameTable and also a JOIN from the MotherID in the FamilyTable to the NameTable - maybe four or five lines of SQL in all.
Discussions of SQLite should be moved to SQLite Tools For RootsMagic.
I’m fluent with SQLite and the RM database, but I really try to as much in RM itself without needing to resort to SQLite. The RM user interface doesn’t do everything you need, but it really is a function rich user interface. I can avoid using SQLite in a very high percentage of cases. In this case, I would use RM’s Couple List view. I would filter the list by typing "goodyer, john into the search box. I would then sort the filtered Couple List by the Mother column and it should be very easy to find Sarah.
The " at the beginning of the filter is probably not necessary in this case because goodyer is not a very common character string. But using the " at the beginning of the filter means, for example, that a filter of "smith will only find the Smith surname whereas a filter of smith without the " will find the Smith surname and also the Highsmith surname. I doubt that you have any Highgoodyer names in your database or anything similar.
Your observation that RM is weak on searching or filtering by family member names is accurate. For example, you can’t easily find John Smith who was the son of Sarah very easily as compared to John Smith who was the son of Elizabeth.
Thats a good response thejerrybryan
I will have a good read and understanding of that. I will also checkout SQLite Tools For RootsMagic
But in the mean time any ideas where the paths to db files within Rootsmagic.
The file with the rmtree extension is an SQLite database. It’s basically all one big file with multiple tables in the one big file. Media files are not in the database and the database only contains links to them. The schema is described at the SQLite Tools site.
Have you used the search box in Couple view?
thanks for all the excellent ideas. much appreciated.