Page 1 of 1
Running a Query on the Result Set of Another Query
Posted: 27 Jul 2020 14:22
by rfj1001
Not sure if this can even be done but I can't find it covered elsewhere.
Essentially, what I want to do is to work just on a subset of records (often surnames) and then interrogate that subset further. The subject of the second interrogation is almost as open-ended as the queries available (eg missing census records).
Any thought on how it might be achieved.
Many thanks
Re: Running a Query on the Result Set of Another Query
Posted: 27 Jul 2020 15:08
by tatewise
The short answer is 'NO' you cannot run a Query on a Result Set.
But there may be circumstances where in effect it is feasible via some other commands.
If you are interested in the Records in the Result Set then the cog Query Menu > Add Row Records to Named List... saves those Result Set Records in the Named List (but not any of the Column details).
Another Query can use the =IsInList(%INDI%,"Named List") function as a Rows tab filter to restrict it to just those Records.
Alternatively, starting from the Query that produces the desired Result Set, save it as another Custom Query and add more Rows tab filters for the additional filtering.
BTW: As far as missing Census records are concerned there are plenty of existing Queries and Plugins for that.
Re: Running a Query on the Result Set of Another Query
Posted: 27 Jul 2020 16:23
by rfj1001
Thanks Mike,
I'd guessed it might not have been possible. Adding the row filter and changing it each time got me 50% of the way there though.