Integration Platform Technologies: Siebel eBusiness Application Integration Volume ll > EAI Siebel Adapter > EAI Siebel Adapter Methods >

About the Query Method

You pass the Query method using only one of the following method arguments:

• A Query By Example (QBE) integration object instance.
• A Primary Row Id.
• A Search Specification.

The adapter uses this input as criteria to query the base business object and to return a corresponding integration object instance. For example, to query Contact records with first name David you need to pass the following required input arguments to the Query method of EAI Siebel Adapter:

• SiebelMessage.IntObjName with value set to Test Contact
• SiebelMessage.ListOfTest Contact.Contact.First Name with value set to David

Now, if you need to further limit the output based on a value in the child component of the Test Contact (for example, to only query the Contact records with first name David and Action Type of Call), then you need the following required input arguments:

• SiebelMessage.ListOfTest Contact.Contact.First Name with Value set to David
• SiebelMessage.IntObjName with value set to Test Contact
• SiebelMessage.ListOfTest Contact.Contact.ListOfAction.Action.Type, with Value set to Call

Note that this still returns the contacts with the first name David, even if they do not have an activity of type Call, but it does not list their activities. For an example of using the search specification method argument to limit the scope of your query see About the SearchSpec Input Method Argument.

NOTE:  When using the EAI Siebel Adapter, to query all the business component records, you do not need to specify any value in the Object Id process property of the workflow process. In this case not specifying an ID works as a wildcard. If you want to query Siebel data using the EAI Siebel Adapter with the Query method and a property set containing a query by example search criteria, then all the fields that make up the user key for the underlying integration object component must exist in the property set. You can use an asterisk (*) as a wildcard for each one of the fields, but all of the user key fields must exist; otherwise, no record is returned.