Query to list items cited from Source

Post by **Anonymous** » 23 Sep 2009 09:51

I'm trying to build a query to list all the things which have citations from a specified source (note the specific item NOT just the main record which can be found by View->Record Links). The closest I seem to be able to get is to create a Fact/Event based Query and then specify the Rows as Add if %FACT.SOUR[1+]>% is [parameter]

But this only appears to return Facts where the citation for the specified source occurs as the *first* citation for that Fact. Does anyone know how I can get it to return the Fact regardless of where the citation occurs within it?

ID:4011

YouTube · Post by **Jane** » 23 Sep 2009 11:48

Add a few more Add ifs, by clicking Add

Add if %FACT.SOUR[2]>% is [parameter]
Add if %FACT.SOUR[3]>% is [parameter]
Add if %FACT.SOUR[4]>% is [parameter]

etc 1+ is only supported as far as I know in text schemes.

Post by **Anonymous** » 23 Sep 2009 12:46

OK ... so in order to make sure I add enough how can I find out the maximum number of citations I have for any, say, person?

YouTube · Post by **Jane** » 23 Sep 2009 12:50

It's the number of citations you have for any single fact, so I would think 5 or 6 would be enough?

Post by **Anonymous** » 23 Sep 2009 13:24

Yes I realise that but I'd rather like to be sure so if I go by the maximum for an Individual I should be a fair way in excess ... so is there a way to show the total citations for all people?

Bilko · Post by **Bilko** » 23 Sep 2009 14:52

Create a new 'Individual' query, add a column for the individual, then add another column with =SourceLinks(['Source'],%INDI%).

On the rows tab, enter 'Exclude if', =SourceLinks(['Source'],%INDI%), 'is less than', 1 (the number in the value box).

When run, this query will ask for which source you want displayed then give you the number of times each individual is linked to that source.

Hope this helps
Bilko
[cool]

Post by **Anonymous** » 23 Sep 2009 15:09

Thanks Jane .... but I really wanted to show the citations for *all* Sources so I can get a maximum - otherwise I'll have to run this query before I run the other query every time to check I have included sufficient index numbers. Is there a total SourceLinks to any source record?

Post by **Anonymous** » 23 Sep 2009 15:21

Alternatively is there a way to show the *total* number of citations of a specific source (to all INDIs, FAMs, facts, attributes etc etc)?

Bilko · Post by **Bilko** » 23 Sep 2009 15:27

When you run the query, it asks you for the source you wish to focus on and opens a box labelled 'Enter query parameters'. If you click on the little box with 3 dots another box opens labelled 'Select Source Record'. If you click on the column headed 'Citations' the Sources are listed in order of maximum first. Start at the top and work your way down and you will very quickly see that there will be a maximum of somewhere between 5 and 10 (mine is 7 !).

BILKO

Post by **Anonymous** » 23 Sep 2009 15:38

Ah brilliant!! Many thanks Jane ... my total citations are anywhere between 0 and 2000 depending on the Source so I guess I'll have to use this query with care but at least I can tell where it's viable.

Many thanks for your help

Post by **Anonymous** » 23 Sep 2009 15:39

Ooops sorry BILKO I should have been thanking you! (And Jane of course) - apologies for the boo-boo!

Post by **Anonymous** » 23 Sep 2009 15:44

Oh dear ... Still can't show Names, Family or Indi citations so will never be able to see all the citations without searching through each person and family by hand. I think I'll give up [cry]

Bilko · Post by **Bilko** » 23 Sep 2009 16:28

The method I outlined previously will also work with a 'Family' query - substitute =SourceLinks(['Source'],%FAM%) for =SourceLinks(['Source'],%INDI%).

If you want to add names or other details to the results from the query, just click on the relevant tab on the left pane when viewing the Columns tab.

BILKO

Post by **Anonymous** » 26 Sep 2009 11:40

Thanks for the help Bilko but I was really after a single result list with all the items that a source was linked to so that I can easily verify when double-checking sources and facts etc. Although I could do it with multiple reports/columns etc I can't seem to ever guarantee that I'm looking at the complete result set since there could be something else somewhere that I haven't manually included (e.g. an 8th line or a NAME etc etc)

Family Historian User Group