FindRecordEx
This method contains the update for the input argument. This method is an enhanced version of the FindRecord method and is used to query for multiple levels of business components. You can use this method to query for the child business component according to the query results of the parent business components. The following table shows the input PropertySet arguments for FindRecordEx.
| Input Argument | Description |
|---|---|
|
The business object name. |
|
A comma-separated business component name list. Note: The order is important. The child business component
must appear after the parent business component. |
|
This is the query field of the specific business component. The business component is listed in the BusComp parameter. In the query, XXX is the query field name of the business component. For example, to query using the row ID of the Business Component Account, the argument values are as follows:
|
|
A comma-separated field list indicating the output field name list of the specific business component. The default functionality is to generate the row IDs of the query results, but you can use this parameter to generate the other fields as required. |
The output PropertySet for FindRecordEx includes the query results of all the business components defined by the BusComp parameter. The query result for each business component is organized as a child PropertySet with the type set to the business component name.
Example
If you want to query for a contact that belongs to a specific Account and the account has many associated contacts, then you must use the work phone number to query the contact too. In this case, the input is as follows:
BusObj = Account
BusComp = Account, Contact Account:QueryField:Id = 42-FF6I6
Contact:QueryField: Work Phone # = 123456789