photools.com Community

IMatch Discussion Boards => General Discussion and Questions => Topic started by: cassb on April 30, 2025, 04:19:31 PM

Title: Need help with a query
Post by: cassb on April 30, 2025, 04:19:31 PM
Hi all -- I am in the process of adding geolocation data to all my older scanned photos that don't have it. So I'd like to make a query to find the photos I need to update.

I have a user-created attribute called "Location" that I created and manually populate for every photo.  It generally contains an physical address or a more general description of a physical location.

What I'd like to do is create a query to enumerate all photos by their "Location" attribute, with the name of the Location and the number of photos that have the same Location value.  I have never done a query in IMatch before, so I could use some pointers on how to get started with this.  I'd like to be able to do an exact match on the Location attribute for the photo count, OR a relative match. Something like:

Exact match groupings:
Location                                  Number of Photos
-----------------                        --------------------
Disneyland, Anaheim, CA          81
1234 Street Rd, Anywhere, MA  130
Boston, MA                              93

OR relative match groupings:
Location                                  Number of Photos
-----------------                        --------------------
Disneyland                              81
Anaheim                                 251
Anaheim, CA                           220
Boston, MA                             93
Boston                                   93
MA                                         259

Thank you!
Bryan
Title: Re: Need help with a query
Post by: Mario on April 30, 2025, 06:17:22 PM
I suggest you create a data-driven category based on the Attribute variable for your custom Attribute.

Say I have an Attribute Set called "Notes" with an Attribute "People.".
To group files by this Attribute, I create a data-driven category below "My Categories" and name it "People Attribute". Use a name you like, it is not important.

Tip: I prefer to collect my "expensive" (aka computing-intensive) categories below a parent category with the "Direct assignments only" option enabled. This way, when I close the parent, the expensive child categories must not be calculated.

Image1.jpg

and the category itself is created like this (use the variable for your Location Attribute):

Image2.jpg

This creates one child category for each unique Attribute value (Location) and the category count tells me how many files are there with this Location.