Page 1 of 1

Where a Fact has been used

Posted: 08 Jan 2022 20:09
by Rusty
Many years ago I made some custom facts, is it possible please to find out which records I have used these on?

Re: Where a Fact has been used

Posted: 08 Jan 2022 20:30
by LornaCraig
Yes, here is a custom query which I use. It prompts for the name of the fact. In the Results table the 'Value' column is only used with attributes. It is always blank for events.

Where Facts Used.fhq
(1.04 KiB) Downloaded 64 times

Re: Where a Fact has been used

Posted: 08 Jan 2022 22:15
by tatewise
The standard Query All Facts lists where every Fact is used and when sorted into Fact order tells all.

Re: Where a Fact has been used

Posted: 08 Jan 2022 22:17
by LornaCraig
Yes, the custom query is based on that but I find it handier when I just want to inspect one particular fact type quickly. It saves a lot of scrolling!

Re: Where a Fact has been used

Posted: 08 Jan 2022 22:30
by tatewise
FHUG Knowledge Base download All Facts Filter by Label must be very similar.

Re: Where a Fact has been used

Posted: 09 Jan 2022 09:35
by Rusty
Thank you Lorna and Mike, I used Lorna's Query and it worked beautifully, now I have lots of work to do sorting everything out, that'll teach me to do things the right way around the first time!!! :)

Margaret