• Introduction
• Download Example File
• View Calculation
• Find Records Function

Introduction

This example shows how to Query a table in your database and returned structured data using the MMQuery_FindRecords function. Choose a field to search on with the "Field Name" menu, a selector to use when finding matches from the "Selector" menu, and then type in a value to match in the "Field Value" field.

For example, if you wanted to find all presidents that belonged to the republican party, you could select 'Party' from the "Field Name" menu, 'Contains' from the "Selector" menu, and type in 'rep' in the Field Value field.

Pressing the "Find Records" button calls the "Find Records" script which uses MMQuery to set the "Result" field with all matching presidents in 'LastName, FirstName' format sorted by last name.