# Fact without Media search

**URL:** <https://community.rootsmagic.com/t/fact-without-media-search/7771>\
**Category:** RootsMagic\
**Tags:** question, feature-request\
**Created:** [June 25, 2023, 1:01am UTC](https://community.rootsmagic.com/t/fact-without-media-search/7771 "2023-06-25T01:01:10Z")\
**Posts on this page:** 3\
**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:** [June 25, 2023, 1:01am UTC](https://community.rootsmagic.com/t/fact-without-media-search/7771/1 "2023-06-25T01:01:10Z")

</div>

There does not appear to be a away to search for MEDIA _does not exist_ within RM.  
This can be done via SQL but the joins are not fund foes does that.

Is the ability to do this on the feature request list?

Thanks, Kevin

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

---

<div class="post-metadata">

**Author:** ![rzamor1](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.rootsmagic.com/rzamor1/32/8_2.png) [@rzamor1](https://community.rootsmagic.com/u/rzamor1)\
**Post date:** [June 25, 2023, 3:16pm UTC](https://community.rootsmagic.com/t/fact-without-media-search/7771/2 "2023-06-25T15:16:53Z")

</div>

Confirming the request has been reported to development.

---

<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:** [June 25, 2023, 3:32pm UTC](https://community.rootsmagic.com/t/fact-without-media-search/7771/3 "2023-06-25T15:32:22Z")

</div>

Thank you – I am sure it would be a welcome addition to help with research.  
In meantime I found semi working SQL solution.

Kevin