A lot of lua/query is a black art to me (I modify other examples + trial and error), but would a hidden/buddy column help?
Code: Select all
[Family Historian Query]
VERSION=3.0
TYPE=FACT
TITLE="All Facts with 2 types of PLACe record for quick jump to place in record or PLACe record"
SUBTITLE="%#x"
ORIENTATION=LANDSCAPE
TAG="Fact date","FACT.DATE:COMPACT",,,64
TAG="Source","FACT.SOUR>",,,45
TAG="Fact","=FactLabel(%FACT%)",,,33
TAG="ID1","=RecordId(FactOwner(%FACT%,1,MALES_FIRST))",,,22
TAG="Owner1","=FieldText(FactOwner(%FACT%,1,MALES_FIRST),'INDI.NAME:SURNAME_FIRST')",,,133
TAG="Owner1B","=Field(FactOwner(%FACT%,1,MALES_FIRST),'INDI.NAME:SURNAME_FIRST')",BUDDY,,80
TAG="ID2","=RecordId(FactOwner(%FACT%,2,MALES_FIRST))",,,25
TAG="Owner2","=FieldText(FactOwner(%FACT%,2,MALES_FIRST),'INDI.NAME:SURNAME_FIRST')",,,55
TAG="Owner2B","=Field(FactOwner(%FACT%,2,MALES_FIRST),'INDI.NAME:SURNAME_FIRST')",BUDDY,,80
TAG="FACT-Place-click for related FACT","FACT.PLAC",,,27
TAG="RECORD-click for PLACe Record","FACT.PLAC>",,ASC,437
TAG="p1","=TextPart(%FACT.PLAC%,1,1,STD)",,,75
TAG="p2","=TextPart(%FACT.PLAC%,2,1,STD)"
TAG="p3","=TextPart(%FACT.PLAC%,3,1,STD)"
TAG="p4","=TextPart(%FACT.PLAC%,4,1,STD)",,,67
TAG="p5","=TextPart(%FACT.PLAC%,5,1,STD)",,,75
TAG="p6","=TextPart(%FACT.PLAC%,6,1,STD)",,,86
TAG="p7","=TextPart(%FACT.PLAC%,7,1,STD)",,,136
TAG="p8","=TextPart(%FACT.PLAC%,8,1,STD)",,,134
TAG="p9","=TextPart(%FACT.PLAC%,9,1,STD)",,,51
TAG="p10","=TextPart(%FACT.PLAC%,10,1,STD)",,,69
FILTER=GEN,ADD,IF,Y,"","FACT.PLAC>",,"contains",TEXT,""