Referenced Quotes about HIV/AIDS Tests and Measurements

Database Help

David Crowe, Version 14.03, December, 2017.

Quick search for quote records

The quick search field allows you to do many searches by simply entering your search term in the quick search field and pressing RETURN or ENTER. Some hints for more effective searches are:

If you enter a number, only numeric fields will be searched unless you enclose it in double quotes. You can precede a number with an inequality or equality symbol (<, <=, >, >=, =).
If you enter a date of the format mm/dd/yyyy (numeric month), only date fields will be searched unless you enclose it in double quotes. You can also precede a date with an inequality or equality symbol.
You can indicate a range of dates or numbers by putting '..' between two values.
You can look for records that do not match your search term by preceding it with !=.
The way to initiate a quick search is by pressing RETURN or ENTER when your cursor is in the quick search box.
Many of the advanced FileMaker search symbols are available for use, such as //, * and @.
If you cannot get what you want with Quick Search, use the more sophisticated and flexible Advanced Search.

Advanced search for quote records

This web page uses FileMaker search conventions (because it is searching a FileMaker database). These allow for the simple creation of very powerful queries. Note that the search is additive, quote records are returned that match all the criteria that you specify (or if you specify != queries, that match none of the criteria).

Entering a single "word" (which means a contiguous series of characters without spaces or punctuation) matches all quote records containing that word or one starting with it in the specified field. Entering Smith will find quote records containing Smith and Smithers but not Psmith.
Entering multiple words will match all quote records containing all words, in any order. Entering John Peter will find quote records containing John Petersen, Peter Johnston and Peter John Smith but not John Smith or Peter Smithers.
Entering == (double equal sign) into a field matches quote records where this field is empty. Entering * (asterisk) matches quote records where this field is not empty.
Entering = followed by a word matches the word exactly. =John matches a quote record with John but not one with Johnston (unless it also contains John).
Entering == followed by a phrase matches quote records where the field contains that exact phrase so ==John Smith matches only when the field contains John Smith and nothing else.
Putting a phrase in double quote marks matches it exactly even if it contains spaces or punctuation. "10 Downing" matches 10 Downing Street but not Downing 10 pints.
Using the "at" sign (@) matches a single character. Crow@ matches Crowe but not Crow . Similarly, a # matches a single digit. 1## matches any number in the hundreds.
* matches zero or more characters so Pe*n matches Pen or Petersen. You can use this in a date, so 2/*/2020 is any date in February of 2020.
Inequality operators match fields containing data that is less than (<) something specified, less than or equal to (<e;), greater than (>) or greater than or equal to (>e;). This is most useful with number or date fields but can also be used with text fields. <10 matches quote records containing a number less than 10. >=1/1/2015 matches all dates in 2015 or later.
The two character prefix "!=" matches quote records that do not have this value in this field. For example, !=Alpha would match all quote records that do not contain Alpha in this field.
Two periods (..) finds a range of numbers (e.g. 10..20), dates (e.g. 1/1/2010..5/31/2010) or text (e.g. A..B finds all fields containing words starting with A as well as the letter B, but not words starting with B).
Two slashes (//) matches the current date. 1/1/2013..// matches all fields with dates between the beginning of 2013 and today.
For most fields, you can search for multiple values by separating them with a comma so, John, Peter matches all quote records containing either John or Peter.
You can issue queries from parameters attached to the URL. Type the URL and add ?Help to the end to get instructions for this. If you include SearchControl=Static then the search will occur without the query interface being displayed. To issue a query and export the results immediately include SearchControl=Export.
Note that the characters = and & cannot be used in URLs except to identify URL parameters. The sequence %3D must be used instead of = and %26 must be used instead of &. So, for example, &Count=<=3 (search for field count less than or equal to 3) must be specified as &Count=<%3D3 (note that the first & and &eq; are interpreted as part of the URL so must not be substituted). It will be less confusing to use < and > instead of <= or >=, when possible.
Special characters are special so you may have trouble if you try to search for a comma, at-sign (@) or other characters described above with specific meanings. You can usually avoid this. If you want to search for #123, 456 Main Street, NW, searching for "123 456 Main" will get the right record and probably nothing else.

Questions? Problems?

Email me.

Version 13 features and bug fixes

New features in this version include:

A new type of field, "Tags", is available for searches, editing, adding new records and bulk updates
Global variables for faster access for data, pulldowns and tag lists
Improved portal table formatting
Search fields with data in them are highlighted
Search field hint text is colored to be more visible
It is possible to really delete a record, rather than just marking for deletion (depending on the configuration)
When a list of default values is provided all apply to searches, but only the first applies when adding a record.
When multiple records are returned as a search result (more than one), bulk updates are possible.
Revised histogram shows actual progress through 100%
It is possible to query many more records than before.
Record count is accurate even after adding or deleting a record.
It is possible to restrict certain users from using certain functions (such as Delete, Bulk update, Add).
Queries for a large number of records are several times faster.

Version 12 features and bug fixes

New features in this version include:

Improved error messages.
Button to copy records to the clipboard.
Ability to add custom buttons.
Ability to place buttons above, below, to the left, or to the right of each record.
Custom buttons are available in view and edit mode.
Button flashes when a portal is open, and only one portal can be open at a time.
Allows images and google maps in records.
Prevent accessing portal buttons when the 'Add new portal record' window is open.
More attractive buttons.
Allow configuration to specify a real delete, or 'mark for deletion'.
Better logging of access.
Improvements to quick search. It is now possible to export the data, and prefixing with "!=" works.
Exporting is faster.
When adding a record you can just press the Return key when done instead of clicking a button.
The 'New' tab has been removed. Added records are appended to the records in the "Results" window.
After an export the application returns to the main screen.
Export of unusual characters is allowed.
Application tabs work on a wider variety of devices, especially mobile.

Version 11 features and bug fixes

New features in this version include:

Access to subsidiary records (portals) for query, modify, add.
Better support for Pulldown menus (working around FileMaker limitations).
Improved formatting of monetary amounts.
Allow queries containing the '@' character.

Version 10 features and bug fixes

New features in this version include:

Quick search, allowing most searches to be performed by just typing the search criterion in a single form field.
Export button on Search tab allows an export without first displaying the results on the screen.
Export is possible to a tab-delimited file (.tsv extension) as well as comma-separated, the default (.csv) if the 'exportfilename' is specified on the command line with the appropriate extension (.tsv or .tab).
Better recovery from web timeouts.
Making sure only one search can occur at a time for any application.
Provide mouseover for Export button including the name of the export file.
Control of initial field values from URL typed by user.
Help for adding records, modifying records, and quick searches.
Ability to run a query from URL parameters, and to either display the results on the screen, or export them, without seeing the query form.
Ability to specify the name of the export file in the URL.
Allow search with no criteria (to retrieve all records).
Fewer problems with searches with special characters like @, #.
Improved compatibility with Internet Explorer (but please avoid using this horrible piece of software).
Slightly obscured email addresses to make it harder for spammers to harvest them.

Version 9 information

Version 9 is now obsolete