G2G: Is there a way to search for all Profiles with LNAB in the format "Jones Or Smith"?

Question

Especially in rural Westphalia, German surnames were often supplemented with a "known as" or "called" name which identified the name of the farm - particularly if a man named Jones married the heir to the Smith farm and assumed responsibility for farming it, he would appear in records as "Jones called Smith". In English-language databases, this can appear as "Jones Or Smith" - which is a good sign that additional research using reliable German sources may be needed.

I have not been able to figure out how to get WikiTree to provide a list of profiles with include that "_Or_" in the middle of a three-element LNAB. Does anyone know whether it can be done?  

I have provided a link to one example...

Comments

Hello GM,

You could try Wikitree+ text search

gender=male 

birthcountry=Germany

19cen

sql="([Default].[Last Name at Birth].AsString like '* *or* *')"

sql="not([Default].[Last Name at Birth].AsString like '* ** ** *')"

'

you can add additional NOT's to remove others.

Allan

.

Answer 1

You can get something that might be useful using WikiTree+, but it is a bit fiddly and you would need to break it into small blocks.

One issue is that "or" is treated as an operator in the query. To get around that I had to search for names that contain both " o" and "r " instead. That actually turned out to be useful as some of the profiles use the German "oder" rather than the English "or", but it also means you get a few other random profiles that happen to match that pattern.

The other issue is that there is a limit to how many profiles you can use sql code on, so for the first query I had to limit it to orphaned German profiles from the 19th Century.

I'm not sure how useful it is given the limitations, but here is an example query (just press the blue "Get profiles" button on the left to produce the list) - https://plus.wikitree.com/default.htm?report=srch1&Query=Country%3DGermany+19Cen+Orphan+sql%3D%22(%5BDefault%5D.%5BLast+Name+at+Birth%5D.AsString+like+%27*+o*%27)+And+(%5BDefault%5D.%5BLast+Name+at+Birth%5D.AsString+like+%27*r+*%27)%22&MaxProfiles=500&Format=&PageSize=100