Page 1 of 1

Search function

Posted: Tue Aug 17, 2010 12:27 pm
by donne
Search doesn't seem to work as I expect it to. For example I am trying to find a family relating to the death of a widow called say Jane Smith. I open the Search/ Family window and put 'smith' in the father's surname box and 'jane' in the mother's firstname box, and select 'match all fields'. The result seems to be any family with a father 'smith' plus any family with a mother 'jane' . It's the same result I get with 'match any field', where I would expect it.

Posted: Tue Aug 17, 2010 8:24 pm
by laschapas
I get the same results using the Families Tab search.

It does work ok. as an SQL Query with partial match set. Try :-

SELECT Families.[Description], Families.[Fathers name], Families.[Mothers name]
FROM Families
WHERE ( UPPER(Families.[Fathers name]) LIKE '%SMITH%' ) AND ( UPPER(Families.[Mothers name]) LIKE '%JANE%' )

The [Match all fields] & [Match any fields] selection does then make a difference to the results.

John Wood

Posted: Sat Aug 21, 2010 11:09 am
by donne
Thanks for that. SQL Query does what I want and I can code the query using the setup table in the window - you can see how the AND and OR function in the query text changes as you select 'Match any field' or 'Match all fields'. I presume in the Search/Family window, the underlying SQL Query text for 'Match all fields' is not being formed properly?

Posted: Tue Feb 15, 2011 9:10 am
by Nick Hunter
This was fixed in V3.1.1