# Fact Has Media?

**URL:** <https://community.rootsmagic.com/t/fact-has-media/7069>\
**Category:** RootsMagic\
**Tags:** feature-request\
**Created:** [March 28, 2023, 11:56pm UTC](https://community.rootsmagic.com/t/fact-has-media/7069 "2023-03-28T23:56:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kevync1985](https://avatars.discourse-cdn.com/v4/letter/k/3be4f8/32.png) [@kevync1985](https://community.rootsmagic.com/u/kevync1985)\
**Post date:** [March 28, 2023, 11:56pm UTC](https://community.rootsmagic.com/t/fact-has-media/7069/1 "2023-03-28T23:56:35Z")

</div>

Other than SQL, there does not appear to be able to SEARCH if a fact had Media  
You can for can for example if DEATH Fact exists and Source Exist.

There does not appear to be a way If Media Exist (for particular Fact such as death)  
(options for Date, Place, PlaceDetails, value, Note, Source, Age. Exist)

Basically I am looking to build groups that are missing media for chosen fact (and other criteria)  
So I am guessing this would need to be a feature request. Actually, there are a few additional Search criteria . This type of media search would be helpful.

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/rootsmagic/original/2X/1/18bba4d04f3d9e4da30ccef45c1aff6246513804.png)

---

<div class="post-metadata">

**Author:** ![thejerrybryan](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.rootsmagic.com/thejerrybryan/32/404_2.png) [@thejerrybryan](https://community.rootsmagic.com/u/thejerrybryan)\
**Post date:** [March 29, 2023, 2:42am UTC](https://community.rootsmagic.com/t/fact-has-media/7069/2 "2023-03-29T02:42:07Z")

</div>

I have used SQLite scripts for years to find facts without media, citations without media, sources without media, people without media, whatever without media. I agree that the same capability needs instead to be available from within the RM user interface. You are correct that the capability does not presently exist.

In fairness, the Fact Type list has some limited capability for this sort of thing. For example, you can create a report of Facts With Sources or Facts Without Sources. The same support is not provided for media. And in any case, the limited capability for this sort of thing in the Fact List is not integrated with Advanced Search, creating groups, or doing color coding.

---

<div class="post-metadata">

**Author:** ![kevync1985](https://avatars.discourse-cdn.com/v4/letter/k/3be4f8/32.png) [@kevync1985](https://community.rootsmagic.com/u/kevync1985)\
**Post date:** [March 29, 2023, 12:35pm UTC](https://community.rootsmagic.com/t/fact-has-media/7069/3 "2023-03-29T12:35:44Z")

</div>

Thanks  
Just wanted to make sure I had not missed anything with RM 9

For those of us comfortable with SQL (or Excel Power Query) there are options outside of RM.  
However, this would seem to been of benefit for those users who want to find where they are missing MEDIA for particular fact(s). Another Missing (Field) would be GEN UP / GEN DOWN (hard coded in person table based on Set Relationships – there are of course work around using groups for that scenario)

---

<div class="post-metadata">

**Author:** ![kevync1985](https://avatars.discourse-cdn.com/v4/letter/k/3be4f8/32.png) [@kevync1985](https://community.rootsmagic.com/u/kevync1985)\
**Post date:** [March 30, 2023, 8:24pm UTC](https://community.rootsmagic.com/t/fact-has-media/7069/4 "2023-03-30T20:24:59Z")

</div>

Okay - so I wrote a crude one in Excel using ODBC with Power Query.  
Here Ben Abbott has 3 facts with NO Media

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/rootsmagic/original/2X/3/305613b6706e0d8666a958e6650bfdd0318918e3.png)

below are the queries I used

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/rootsmagic/original/2X/2/2194fd8eeea02fe92f0b595af38a7c45ef13ecfe.png)