Search Database

Top  Previous  Next

 

 

Take a few minutes to learn the basics about the CodedColor Database Search by following the steps below:

 

dlg_searchdb1

1.Open an Explorer window and press F3
2.Select the database fields you want to include in the search. The search value combination will be applied to every field in an OR manner.
3.Enter the search values. Several values can be separated by spaces. In the example here we are searching for all images from "Carbarete" in "2002" OR "2003". This information is found in the filepaths, so make sure you included this field in the fieldlist (2).
4.Check Only existing files in searchresult, if you want to exclude files that are currently not available (CDs)
5.Check Search in catalog paths, if you want to include the filenames of catalog linkfiles.
6.Press Search.

 

 

dlg_searchdb2

 

The found records have been prefiltered. You have not yet created the physical searchresult. Press Yes, if you want to create the linkfiles of all found images in the searchresult directory of the Organizer.

 

dlg_searchdb3

 

Since you checked Only existing files in searchresult, the final search result is actually smaller than the number of prefiltered records. Those records of the searchresult have been omitted, where the original image is currently unavailable, maybe because it's on a removable media like a CD.

 

 

scr_orgsearch

 

The Organizer window is opened, and the created linkfiles are displayed in Detailsview. In the type column you can see the actual location (path) of the image.

 

You can switch to the Imageview and browse the found images in the samer manner as you would in a normal directory.

 

 

Example with keywords

 

You have 3 images with the following keywords:

 

1.Sail, Surf, Water
2.Sail, Surf
3.Sail, Storm, Water

 

Search option

Seach value

Result

 

at least one of the words

 

sail surf

 

1, 2, 3

 

all of the words

 

sail water

 

1, 3

 

contains phrase

 

sail surf

 

finds nothing, because multiple keywords must be separated by komma (no empty spaces) for this search option

 

contains phrase

 

sail,surf

 

1, 2

 

equals phrase

 

sail,surf

 

2

 

equals phrase

 

sail,water,storm

 

finds nothing, because keywords are listed in alphabetical order in this example

 

Note: The search is not case sensitive.

 

icon_tip More Information

 

You can also view the search result in the screenshow (fullscreen view), edit annotations, open the image in the image editor, rotate, etc. You are not editing a copy of the image or the linkfile pointing to it, but the original image.

 

You can refresh the search result anytime by pressing F5 in the search result folder. The search is repeated with the original search parameters, and any new images in the database matching the query will be inserted into the result folder. Alternatively press Open & Refresh in the search dialog, and select the search result you would like to refresh.

 

To delete old or empty search result folders, press Cleanup in the search dialog. Remember, that search results are actually only catalogs containing links to your original images.

 

To search for EXIF and IPTC information read the topic about EXIF/IPTC fields.

 

You can use the Keyword View to search for keywords in a more comfortable way. It can also be used to assign Keywords to many images at once.

 

To perform easy searching with a chronological priority, use the Timeline Calendar View.

 

icon_tip Related Topics

 

Search Similar Images
Can I narrow the database search to a specific folder?
Title and Annotations
Are my images stored in the database?
Can I view the contents of the database?
Database definition
Backup Database
Database Maintenance
Why are not all keywords displayed in the dearch dialog?
Timeline Calendar View

 

 

 

 

CodedColor PhotoStudio © 2023 1STEIN GmbH

CodedColor PhotoStudio by 1STEIN is an award-winning Windows photo viewer and editor to organize, edit, resize, reformat, correct, compare, sort, watermark, annotate and print digital images, and to edit EXIF and IPTC data in digital photos. You can rename multiple images, remove scratches, stich panoramas, convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), burn digital watermarks, correct colors, batch convert and correct images and generate a web album in HTML5. The software is easier to use than Photoshop, but more versatile than ACDSee, Picasa, Irfanview or Gimp. Many magazines consider it to be the Swiss Knife of Image Editing. Have a look at our Before / After tutorials to get an idea of the powerful capabilities. The software comes with a detailed handbook and a fast database to store EXIF/IPTC data and color information. CodedColor PhotoStudio is the ideal image editing tool for every-day and professional digital camera users. The user friendly interface combines features like expert photo editing & printing, layer editing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor, GPS tagging, perspective correction, barrel distortion, effects, thumbnail generation, resize & resample images, batch conversion, database keyword searching, red eye removal, color/sharpness/brightness & contrast correction, artifact removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, transparency (alpha channel) and layers, gamma correction, screen shows with many transition effects, watermark text, image annotations, panorama stitch & animation, video capture, PDF album export, photo layouts, collages, frames, shadows, histograms, automatic white balance, photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, HEIC, HEIF, AVIF and all current RAW formats. The installation includes our the CodedColor Publisher, a versatile photo layout and DTP tool to create individual and rich photo books.