NamesOfStoredFilesForDonor()

<< Click to Display Table of Contents >>

Navigation:  Available Functions >

NamesOfStoredFilesForDonor()

Syntax

NamesOfStoredFilesForDonor( <cFileMask> )

 

Purpose

To retrieve the names of all stored files for a donor which match an optional file mask.

 

Parameters

<cFileMask> is a character value which must be enclosed in quotation marks. It can be used to limit the types of files returned, or to specify that only files beginning with a certain name be returned. For example, "*.pdf" would return the names of all PDF document files for the current donor. "Profile Picture*.jpg" would return all of the file names of picture files starting with the phrase "Profile Picture."

 

Returns

The file names are returned in a single tab-delimited character value, suitable for reporting or exporting.

 

Usage

On reports the NamesOfStoredFilesForDonor() function can be used to retrieve and print all files, or files meeting a certain file mask, for each donor.

 

Example

The following examples illustrate NamesOfStoredFileForDonor():

 

STORED FILES FOR DONOR

Audio file of speech donor gave at city council meeting.mp3

ConstituentNotes.doc

Profile picture of donor.jpg

Picture of donor at our top donor tribute dinner.jpg

Scan of letter donor sent us praising our work.pdf

 

 

CALL

RESULT

NamesOfStoredFilesForDonor( *.pdf )

Scan of letter donor sent us praising our work.pdf

NamesOfStoredFilesForDonor( *.jpg )

Main profile picture of donor.jpg <tab> Picture of donor at our top donor tribute dinner.jpg

NamesOfStoredFilesForDonor( "Profile*.jpg" )

Profile picture of donor.jpg