Page 1 of 1

Problem using GetLabelledText( ) function

Posted: 17 Jan 2021 11:17
by ELM
On Version 6 I had a custom query using the GetLabelledText function and it was working, But with Version 7 some of the cells are blank.
Has there been any changes to the function to cause this?
Column entry has in the “Expression” Column =GetLabelledText(%INDI.NOTE2[last]%,"<a href=")
The Note of one of the records with blank entry is
See
[[1]]<a href="www.mcmullin.me.uk/par_chest/overseers. ... erseers</a>
[[2]]<a href="www.mcmullin.me.uk/places/tadmorton.html">Tadmarton</a>
While
See
<a href="www.mcmullin.me.uk/military/froud.html">Military Service</a>
displays correctly.
Help would be appreciated.
Eric

Re: Problem using GetLabelledText( ) function

Posted: 17 Jan 2021 13:00
by tatewise
Yes, there seems to have been a change to that function. I can replicate your symptoms exactly.

The wording of that function definition in FH V6 is:
"the function would search the specified long text field for this label."
But in FH V7 it now says:
"the function would search the specified long text field for a paragraph beginning with this label."

So your Notes that start paragraphs with [[1]]<a href no longer match.

All I can suggest is that you report that problem to Calico Pie via http://www.calico-pie.com/osticket/open.php

Such changes that are not backwards compatible are most infuriating. You have my sympathy.
The only workaround would involve putting the [[1]] on a separate line or at the end of the web address.

BTW: In the FH V7 rich text Notes you can make those entries into active web links.

Re: Problem using GetLabelledText( ) function

Posted: 17 Jan 2021 14:44
by ELM
Thank you. It seems to explain what’s happening. It looks like it’s back to the drawing board.
I’ll contact Calico Pie and look into using active web-links.
Can the active web-links be displayed in query reports?

Re: Problem using GetLabelledText( ) function

Posted: 17 Jan 2021 16:06
by tatewise
After a quick experiment, it looks as if active web links do NOT appear in Query Results.
You would have to add some simple text to get anything to appear in a Query.

Re: Problem using GetLabelledText( ) function

Posted: 19 Jan 2021 17:13
by ELM
I tried contacting Calico Pie and got the reply
- The logic has been tightened to avoid problems when rich text is encountered.

Not very satisfactory. I could not get them to see the problem. In the end I gave up.

A solution I have come up with is

[[+ hyperlinks.]]
See our pages on Overseers and Todmartin
and descents from John BROMLEY and Thomas MOREBY
[[
1: Overseers
2: Tadmarton
Descent from John BROMLEY
and descent from Thomas MOREBY
]]
With changes to the queries “Hyperlinks” and “Hyperlinks Select Page”
=GetLabelledText(%INDI.NOTE2[last]%,"<a href=") → =GetLabelledText(%INDI.NOTE2[last]%,"1: ")
=GetLabelledText(%INDI.NOTE2[last]%,"Descent from <a href=") → =GetLabelledText(%INDI.NOTE2[last]%,"Descent from") etc


It works!

Re: Problem using GetLabelledText( ) function

Posted: 19 Jan 2021 17:30
by tatewise
Sorry that CP were not very helpful, especially as there is nothing in the What's new pages to suggest it has been tightened.

Interestingly, the new =FindText( ... ) function searches everywhere.
I wondered whether there was a way of using that to find your labelled Notes.
But since you have found a workaround, and few people are likely to be affected, that has gone on the back-burner.