On my personal wish list for things to add to advanced search is “No Media” (would be similar to “No Source”). Until my wish is granted – -I have come up with a work around to do most of work with RM. (previously I used Power BI and/or Excel PQ queries). This is what I came up with – but it likely would be strongly discouraged by RM because one step uses sqlite.
The groups are done via normal advanced Groups examples:
this would be people view using group filter
I used a custom fact “MediaZero” and update the note field (viaSQLITE)
like this: “#ZeroMediaBirth #ZeroMediaDeath #ZeroMediaCensus”. Then the rest is done in RM via normal group criteria
Just tested on RM db – and it took less than 2 mins to run with over 29K on 5 facts.
Uses CTE script to find facts with no media by personid (this one only does Ind facts)
If it looks good I will post later this week on