Page 1 of 1

Source Queries

Posted: 10 Oct 2006 00:16
by pjbwilson
I hope this has not been covered.

I am trying to write a query that will list all individuals and all sources, or source types.

So there will be a few lines of sources per individual.

Is this possible? Does anyone know how to do it? Any help would be greatly appreciated.

Thanks,
Peter

ID:1904

Source Queries

Posted: 10 Oct 2006 08:38
by Jane
I think you would need to use a report rather than a query. You need multiple lines per record, which means you can't currently do the job with a query.

If you were just looking for instance to see what the sources were for BMD events you can do that with a query, but not a blanket all sources for all people in queries. I think there is one in the Query store for that.

Obviously you can already do a query for a single person using the standard Sources for Given Record Query, and see the Number of Links per source using the Record Links Query.