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.
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?
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.
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