QueryRecord

You use the QueryRecord keyword to query a record in a list or form applet.

Signature

The QueryRecord keyword supports the following signature:

QueryRecord(Applet RN|ButtonRN,FieldRN(1..N)|Value(1...N) OR Variable)

Note: To query for an existing record, use one or more fields or run an empty query.

Desktop Examples

The following table describes how to use the QueryRecord keyword to query a record in list or form applets in desktop applications.

Target Object	Inputs	Closing Action	Comments
Contact List Applet|NewQuery	Last Name|oracle$,First Name|company$,Work Phone #|6506123456	N/A	Queries the record with the specified search criteria.
Contact List Applet|NewQuery	LastName| David,FirstName|Albert	N/A	Queries the record with the specified search criteria.
Contact List Applet|NewQuery	First Name|AAAX*	N/A	Queries the record with the specified search criteria.
Contact List Applet|NewQuery	Work Phone #|650678-0987	N/A	Queries the record with the specified search criteria.
Opportunity Form Applet - Child|NewQuery	Opportunity Currency2|USD	N/A	Queries the record with the specified search criteria.
Contact List Applet|NewQuery	First Name|AAAX*	N/A	Queries the record with the specified search criteria.
Contact List Applet|NewQuery	First Name|NULL	N/A	Searches for an empty query (that is for records where First Name is NULL).
Contact List Applet|NewQuery	M/M|Mr.	N/A	Queries the record with the specified search criteria.

Mobile Examples

The following table describes how to use the QueryRecord keyword to query a record in list or form applets in mobile applications (on mobile devices).

Target Object	Inputs	Closing Action	Comments
SHCE Sales Opportunity Form Applet - Mobile|NewQuery	Name|John$,Currency|USD,CloseDate|11|12|12	N/A	Queries the record with the specified search criteria.
CG Account List Applet - Mobile|NewQuery	Name|abc	N/A	Queries the record with the specified search criteria.