FHv7 - Expressions
Posted: 08 Jan 2021 09:34
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
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