* FHv7 - Expressions

[Kingy]

Hi

hoping someone can help or clarify a few things for me.

1. Using ContainsText in an expression - I have not been getting exactly what I expected and on reading the help was surprised to see the following -

Parameter 2:
The search text to check. This can contain more than one word. A field is deemed to match the text if it contains all of the words in the search text. However, they do not have to be whole word matches (e.g. "Hampshire" will match "Shire"), case does not have to match, and the words do not have to be in the same order, contiguous, or even close to each other, in the field in question.

For Example if I use =IsTrue(ContainsText(%INDI.DEAT.SOUR[1]>TITL%,"Death Certificate",STD ) I would expect it to return records with "Death Certificate" and not records with "Death Cert" or "Cert Deat" etc. which it implies it will.

I am surprised that this is not an exact match? Any way to get it to be an exact match?

2. In FHv7 when you Add Condition - Expression, wouldnt it be better for the box to be expandable like a Notes box. It has the Insert Data Ref to help you build an expression, but makes it very hard to see what you have done on a single line? I end up doing them in a text file and pasting in, but that way you can't use the inbuilt builder? Should this be added to a wish list for future builds?

3. I tried using a Query window to help build an expression and check the output, assuming that this was part of the purpose. On the Columns tab down bottom left there is a box that you can set to - Show Data Reference In Box - I thought that that would show me what expression I had built using the Query, but it remains empty on all settings. Is this not its purpose or is it not working correctly?

Sorry for all the questions

Paul

[tatewise]

1. "Death Certificate" will only match the two text strings death and certificate ignoring case and order.
   It will NOT match cert or deat.
   I think you are misreading the description that is meant to say a search for "Shire" will find Hampshire.
   If you know that the Source Title starts or ends with Death Certificate then the =LeftText() or =RightText() or =MidText() functions can extract and compare it, e.g. =IsTrue( LeftText(%...%,17) = "Death Certificate" )
2. Yes, there are several boxes for Expressions like that, which are too small and non-expandable.
   You could report them to Calico Pie via http://www.calico-pie.com/osticket/open.php
3. That option only applies to the Fields being selected above not the Expression to the right.

[Kingy]

Mike
Many Thanks

1. Yes, I did misread it, (perhaps it could of been a bit clearer) and makes sense.

2. I will report

3. I have never seen anything in that box in bottom left of screen, is there a setting to enable it?

Paul

[Kingy]

3. Ignore last comment, by selecting see both it now shows some data.

Paul