* Custom Query for witnesses

[SpencerDudeUK]

I'm trying to create a query giving me a list of witnesses, but can only get as far as obtaining the first witness in the list. How do I get all the witnesses? Also how would you get a composite list of Individuals and Name Only witnesses?

I have columns:
%FACT.DATE:COMPACT%
=FactLabel(%FACT%)
=FactOwner(%FACT%,1,MALES_FIRST)
=FactOwner(%FACT%,2,MALES_FIRST)
%FACT._SHAR[1]>%
%FACT._SHAR[1].ROLE%
%FACT._SHAN[1]%
%FACT._SHAN[1].ROLE%

I'm obviously missing something here. Can anyone help?

[tatewise]

It is the recurrent case of multiple instances.
As well as %FACT._SHAR[1]>% you also need to consider %FACT._SHAR[2]>%, %FACT._SHAR[3]>%, etc, etc...
Unfortunately, Queries are not good at handling multiple instances, so you need lots of columns.

When listing Individual Witnesses you can look from two perspectives.
You can start from a Principal Fact and list all its Fact Witnesses.
Or start from and Individual and list all the Fact Roles for which they are a Fact Witness elsewhere.

The only tidy solution is to write a Plugin as explained in Witness reporting (11976).