Find a string in a database

#1 · 2025-02-28, 2:25 pm

Hi

I have an RM database and have been trying to find one field in particular.

There is a residence facttype (29) . Once you enter that you can put the address details as well. I have tried to find where it appears in the database by looking at each table and looking for the field in question. I do this by looking at the record for say 1921 census and the address field is e.g. "25 Bull Street" .

I cant find it so my question is can I search for "25 Bull Street" in tyhe entire database so I can locate what field it is reported.

Failing that can anyone tell me where this field is reported. It will be better for me to get how to search entire database but any help appre4ciated

Many thanks for reading

#2 · 2025-02-28, 3:07 pm

There is no "address details" field for a fact so I surmise what you mean is "Place detail" in RM parlance. The RM "Find everywhere" function includes Place Details in its scope. If that's where you have stored "25 Bull Street", then Find Everywhere will find that string there and elsewhere in its scope that includes multiple columns from multiple tables.

Try that and see if you really need SQLite's FTS functionality as described in Search - wayfinding from data tables to RootsMagic screens.

#3 · 2025-02-28, 5:40 pm

Tom, thanks for that. I can find data in RM. What i want to do is to create an excel sheet using autofilter. I find thats a lot more flexible. I would like to pull out all Bull street data items

I will read as you suggest

Thanks for taking time to answer

#4 · 2025-02-28, 8:33 pm

I appreciate that RM does not provide a report format that would allow you to filter data for a given Place Detail. Perhaps this 15-yr old script might answer your need: Facts Having Place Details - Query. Rev 3 still works with RM10 databases.

#5 · 2025-03-01, 4:18 am

Tom, again thanks

It works great and as I am not a whizz I can use to create a table and get information by linking to it.

So grateful for your time - thanks

#6 · 2025-03-01, 6:27 am

You're welcome.

While all of the scripts on that page still function with a RM10 database, none of them support the Association fact type which can use Place Detail. If that's important to you, we could look into updating it.

#7 · 2025-03-01, 11:24 am

A script for RM10 with support for Associations has been added to Facts Having Place Details - Query.

#8 · 2025-03-01, 4:57 pm

Again, thanks. These are very useful.

#9 · 2025-03-03, 8:23 pm

Quote from Adrian Mullins on 2025-02-28, 5:40 pm
...want to do is to create an excel sheet using autofilter. I find thats a lot more flexible. ..

not exactly sure what you want do for results -- you can do stuff like that with Excel Data Connector or Power BI