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
* Problem using GetLabelledText( ) function
- tatewise
- Megastar
- Posts: 28341
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Problem using GetLabelledText( ) function
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.
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.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Problem using GetLabelledText( ) function
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?
I’ll contact Calico Pie and look into using active web-links.
Can the active web-links be displayed in query reports?
- tatewise
- Megastar
- Posts: 28341
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Problem using GetLabelledText( ) function
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.
You would have to add some simple text to get anything to appear in a Query.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Problem using GetLabelledText( ) function
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!
- 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!
- tatewise
- Megastar
- Posts: 28341
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Problem using GetLabelledText( ) function
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.
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.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry