Testing Siebel Business Applications > Keywords Reference > Keywords Description >

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

 

Queries the record with the specified search criteria.

Contact List Applet|NewQuery

LastName| David,FirstName|Albert

 

Queries the record with the specified search criteria.

Contact List Applet|NewQuery

First Name|AAAX*

 

Queries the record with the specified search criteria.

Contact List Applet|NewQuery

Work Phone #|650678-0987

 

Queries the record with the specified search criteria.

Opportunity Form Applet - Child|NewQuery

Opportunity Currency2|USD

 

Queries the record with the specified search criteria.

Contact List Applet|NewQuery

First Name|AAAX*

 

Queries the record with the specified search criteria.

Contact List Applet|NewQuery

First Name|NULL

 

Searches for an empty query (that is for records where First Name is NULL).

Contact List Applet|NewQuery

M/M|Mr.

 

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

 

Queries the record with the specified search criteria.

CG Account List Applet - Mobile|NewQuery

Name|abc

 

Queries the record with the specified search criteria.

Testing Siebel Business Applications Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.