I'm trying to build my first custom query, and I'm feeling challenged.
This is a two part question.
1) I'd like to list all "Place" fields, regardless of which event of attribute it occurred in, and be able to list it in just one column. -->> the only way I can figure out to come close would be to list each possible fact that has a "place" field, each in its own column? I'd also like to list the fact that it comes from, and possibly other fields, too. I'm hoping there's a more elegant solution.
2) failing an elegant solution - and I'd just like to know anyway - how do I create a CSV file with a custom query? I could download all the fields and massage the data into a reasonable looking report that way. I've seen information about moving CSV files into gedcoms, but not a way to create a data file that could be loaded into a spreadsheet, etc.
I am not sure how you would list a place once, but still list all the Facts for it, but you can use a Fact Query to list and sort by place easily enough.
The result set from any query can be saved as a CSV file using the menu button or simply CTRL-A and CTRL-C to copy all the fields and paste them into Excel.
Jane (admin)
"Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
Jane said: I am not sure how you would list a place once, but still list all the Facts for it, but you can use a Fact Query to list and sort by place easily enough.
The result set from any query can be saved as a CSV file using the menu button or simply CTRL-A and CTRL-C to copy all the fields and paste them into Excel.
Trying to achieve something that might look like this: Date Fact type Place ----- --------- ---------- Mar 1865 Occupation London, England Apr 1881 Death Bristol, England
I don't have access to FH at present but I think the Standard Query called All Facts (in FH V4 & V5) does that already.
Remember to click on any column header to sort by that column.
If it does not list exactly what you want, then use the Query Menu top left to Save as Custom Query and alter the Columns tab to list the data items you want using the Fields pane on the left.
To exclude Facts with no Place field, then on the Rows tab, add Exclude if FACT.PLAC is null.
Mike Tate is researching the TATE and SCOTT family tree and all relations.
Also, I'd like to use an "OR" operator for record selection (check parameter against both factowners): =FactOwner(%FACT%,1,MALES_FIRST) or =FactOwner(%FACT%,2,MALES_FIRST)
The Rows Filter needs two entries: Both have Condition: Add if... Expression1: =FactOwner(%FACT%,1,MALES_FIRST) Expression2: =FactOwner(%FACT%,2,MALES_FIRST) Both have Operator: is Both have Parameter ticked and both have the same Label.
PeterR said: The Rows Filter needs two entries: Both have Condition: Add if... Expression1: =FactOwner(%FACT%,1,MALES_FIRST) Expression2: =FactOwner(%FACT%,2,MALES_FIRST) Both have Operator: is Both have Parameter ticked and both have the same Label. http://www.fhug.org.uk/images/uploads/2012-08-03_184122.png
I'll try it, but I would have guessed that a) this would require both fields to be equal to the parameter b) what I read made me think that condition 1 was applied first, then condition 2. A record where the parameter doesn't exist in field one, isn't going to make it to the second pass?
An undocumented feature of Title and Subtitle > Custom is that they support Functions. So enter for =Text(["Person"]) (or whatever Parameter name you use) into the Subtitle > Custom field.
Mike Tate is researching the TATE and SCOTT family tree and all relations.
Overloaded said: ... The discussion on page 158/159 of Getting Started made me think that BOTH conditions must be met to meet the inclusion!
The following paragraph from the book explains what is happening:
For each filter, if the filter has an Add condition (Add if… or Add Unless…), Family Historian will look through the Input Set to find items that match (if it is an Add If…) or don't match (if it is an Add Unless...) the condition specified in the filter. Any items found will be moved from the Input Set to the Result Set.
Still trying to display the name selected for my parameter into the title.
My prompt has been simplified to "Name" Add if =FactOwner(%FACT%,1,MALES_FIRST) is ["Name"]
On the General page, the Subtitle box is Custom and the box that follows is =Text(["Name"]) Then the parameter prompt box has 2 prompts in it (boxes represented with dashes)
Name ----------- Name ----------- (with a browse option)
and if I enter "This is the subtitle" in the first box, it appears in the subtitle of the printout.
Of course, what I want is just one prompt for the individual's name, and that individual's name appears in the subtitle. thanks
There are two prompts because the first (for the Subtitle) needs a Text item, while the second needs a specific Record.
If you change the expression for the Subtitle to:
code:
=Record(["RecordId"])
(or the prompt could still be "Name" if you prefer) you can then input the relevant Individual RecordID when prompted. This means that you have to note the RecordId when you browse for the Individual.
I know this is not ideal and others may have a better solution.
This web site was made with WebAPP v0.9.9.3.3, a web portal system written in Perl
All trademarks and copyrights on this page are owned by their
respective owners. Comments are owned by the Poster.
Marble theme based on "Crash" theme by my2cents
Author:
Logged
but how can I put the parameter [that I prompted for in the query] into the Query Subtitle? 
Custom queries
