Media+Users+List+Query

=Introduction= toc RootsMagic 4 falls short in handling media in several ways. One serious one is its inability to report fully all the 'owners' of the media, i.e., its terminology to describe what person, couple, event, source, citation, place or place detail to which a media item is attached, in sufficient detail that the attachment can be found. Trace-ability is essential to be able to make changes to an attachment's properties, i.e., its caption, description, reference number, date, sort date, primary and scrapbook inclusion flags. RM4's Report > Lists > Multimedia List does not even report usage by Sources or Source Details and fails to report the Place to which a Place Detail, having media attached, belongs. Similarly, the Media Gallery > Tools > "Show where this media is used" results are incomplete for media attached to Source Details or to Place Details, giving little or no clue to how you would navigate to the citation or Place where you could then drill down to the Media and edit the caption or other properties.

Here's an example of what I mean:

code Cens: 1891 Can: Ancestry.ca - FF2 (ff incomplete) (citation) code How can one possibly find the citation without at least the RIN or name of the person?
 * Owner according to Media Gallery > Tools > "Show where this media is used"**

code (citation) WICKENS, Martha Jane "Jenny"-208 : RESIDENCE (FAMILY) ca 1891 : HOLDEN, Matthew Edwin-149 citing Cens: 1891 Can: Ancestry.ca - FF2 (ff incomplete) (citation) HOLDEN, Matthew Edwin-149 : RESIDENCE (FAMILY) ca 1891 : WICKENS, Martha Jane "Jenny"-208 citing Cens: 1891 Can: Ancestry.ca - FF2 (ff incomplete) code Both RM4 and the query show that the media file is attached to a citation but the new query provides explicit guidance to the citation via not only the name and RIN of the person but also the fact name and date so that the citing fact can be quickly found and its Citation Manager opened. The source name is shown (that's all the Media Gallery shows apart from the caption and full filename) so it can be readily selected from the Citation Manager and the Source Detail Media Album opened therefrom and the media item selected by file name for the editing of its properties. That is the only way RM4 lets you get to the item's properties; obviously, a road map is necessary. This query shows the route.
 * Users according to Media-UsersList query**

=Download = - original query, easier to modify, fast on smaller databases, bogs down on large ones - fast even on very large databases, larger sql file, harder to modify at the base SELECTs. - as ver 3 but revised for RM5 and 6; prior versions work with RM4.

=Screenshots=

With Thumbnail Images
Using SQLite Expert Personal, make sure the following setting is checked for the thumbnail image to be shown:

Tools > Options > Data:

 * Results-Display results in grid
 * Grids-Show images