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