Photo Funds Database: How to Search or Filter

What the difference between searching and filtering? When you search for something, the database will highlight any record in the database that matches your search term. However, if there are multiple records that match your search term you'll have to jump from one record to the next while still seeing all of the surrounding records.

When you filter the database, you'll see only those records that match your filter term(s). Searching is a quick way to find out if a particular item in in the database; filtering is a better way to view multiple records since you'll only see what you're looking for.

By default, the database ​displays all of the records that have been entered so far (starting in the year 2012).​ The records appear in descending order by year, then alphabetically by the name of the recipient within each year. For ease in browsing, all individual photographer names are preceded by the word "photographer" so all photographer records appear as a group.

It's easy to search or filter when you're using a desktop or laptop computer. Note that some search and filter functions may not be available on smartphones or tablets due to limitations of the operating systems. 

Searching:

  1. At the top of the database window click on the magnifying glass icon at the far right of the database window.

  2. Enter any search term. If that terms appears in any column in any record, the search engine will find it. Multiple words are treated as a single string, not individuals search terms. 

  3. The Search window will immediately indicate how many (if any) records include the term you entered, and the first record in the database will be highlighted. To go to the next record, click on the down arrow in the search window. 

  4. To end the search function, click on the "x" at the right of the Search window.

  5. All searches are specific to the individual user and are temporarily in place for each viewing session. They will be automatically removed as soon as you leave the database website.

Filtering:

  1. Look at the column names to help you think about how you want to filter the records. The names are fairly self-explanatory, and you must know the specific column name for the kind of data you want to see. The last column, Tags, contains keywords for each record, and it's a good column to use if you're not sure about where to begin. For example, if you're looking for records about funding opportunities in Africa, enter "Tags contains Africa" in the filter window.

  2. At the top of the database window click on Filter, then Add filter.

  3. By default the filter tool in the pop-up window starts with "Year" since that's the first column in the database. You can change the column name by clicking on the down arrow next to "Year".  For example, if you're looking for a particular photographer's name, change "Year" to "Recipient".

  4. For most filters, leave the word "contains" in place. There are other options in the drop-down choices if you have more specific filtering needs. 

  5. In the blank box on the right, enter the term you're looking for. For example, if you're looking for projects funded through Indiegogo, you would change the first drop-down to "Funder" and enter "Indiegogo" in the blank box.

  6. Filtering is immediate as soon as you enter a word in the box. It's not necessary to hit Enter or click on any buttons. 

  7. Enter only one word at a time in the search engine. Multiple words will be considered as strings, not individual terms. You may add additional filters by clicking on Add filter. For example, if you want to search for records about campaigns for cameras funded through Kickstarter, first enter "Funder contains Kickstarter", than add an additional filter for "Tags contains camera".

  8. To remove a filter, click on the "x" at the left of each filter line. 

  9. All filters are specific to the individual user and are temporarily in place for each viewing session. They will be automatically removed as soon as you leave the database website.

 

© 2019 by Tim Greyhavens

  • Twitter Social Icon
  • Instagram Social Icon