Query Update Items process for the BMC Remedy AR System adapter
The Query Update Items process updates a record in a BMC Remedy Action Request (AR) System schema with one or more values.
The following BMC Communities video (1:42) shows how to change the password for a user in CTM:People form by using the Query Update Items process.
https://www.youtube.com/watch?v=npLtL9J8Yao&feature=youtu.be
The following table describes the input elements for the <items> XML for the Query Update Items process:
Input elements for the Query Update Items process
Input | Description | Required |
|---|---|---|
<adapter name> | Specifies the name of the adapter to be used for the process, as configured in Grid Manager | No |
<items> | Specifies the XML document containing the elements required to update a record in a BMC Remedy AR System schema | Yes |
<batch process items> | Indicates that all the <item> elements in the XML document must be used to update records in a batch mode | No |
<version> | Specifies the version of the BMC Remedy AR System being used Valid values:
| Yes |
<item type> | Indicates the type of record to be obtained | No |
<connection parameters> | Contains the metadata required by the adapter to connect to the target | No |
The following figure shows the <items> XML sample of the input elements for the Query Update Items process:
<items> XML for the Query Update Items process
<item>
<field-id>536870914</field-id>
<schema>Sample:Cities</schema>
<id>Hyd</id>
<fields>
<field name="Diary Field">Update Diary Field</field>
<field name="Attachment1">C:\Test A.txt</field>
</fields>
</item>
</items>
The following table describes the output element for the Query Update Items process:
Output element for the Query Update Items process
Output | Description |
|---|---|
<adapter response> | Specifies the XML document returned by the adapter request executed on the BMC Remedy AR System |
The following figure illustrates the XML sample of the output elements for the Query Update process when <batch process items> is set to false:
XML sample of the output elements for the Query Update Items process when <batch process items> is false
<entries>
<metadata>
<entry-count>1</entry-count>
</metadata>
</entries>
</query-update-action-result>
The following figure illustrates the XML sample of the output elements for the Query Update process when <batch process items> is set to true:
XML sample of the output elements for the Query Update Items process when <batch process items> is true
<entries>
<entries>
<entry>
<query>'1'="000000000000130"</query>
<entry-count>1</entry-count>
</entry>
<entry>
<query>'1'="000000000000090"</query>
<entry-count>1</entry-count>
</entry>
<entry>
<query>'1'="000000000000091"</query>
<entry-count>1</entry-count>
</entry>
</entries>
</query-update-action-result>
The following figure shows a sample <items> XML for the Query Update Items process using the WorkOrderInterface_Create (Normal) form:
<items> XML for the Query Update Items process using the WorkOrderInterface_Create (Normal) form
<item>
<schema>WOI:WorkOrderInterface_Create</schema>
<id>000000000000001</id>
<updated-field>Summary</updated-field>
<value>
<fields>
<field name = "Summary">Updated Text field</field>
</fields>
</value>
<field-id>1</field-id>
</item>
</items>
The following figure illustrates the output elements for the Query Update Items process using the WorkOrderInterface_Create (Normal) form:
Output elements for the Query Update Items process using the WorkOrderInterface_Create (Normal) form
<entries>
<metadata>
<entry-count>1</entry-count>
</metadata>
</entries>
</query-update-action-result>
The following figure shows a sample <items> XML for the Query Update Items process using the WorkOrderInterface (Self-Join) form:
<items> XML for the Query Update Items process using the WorkOrderInterface (Self-Join) form
<item>
<schema>WOI:WorkOrder</schema>
<id>WO0000000000105</id>
<updated-field>180</updated-field>
<value>
<fields>
<field name = "Summary">Updated Text field by madhu</field>
</fields>
</value>
<field-id>1</field-id>
</item>
</items>
The following figure illustrates the output elements for the Query Update Items process using the WorkOrderInterface (Self-Join) form:
Output elements for the Query Update Items process using the WorkOrderInterface (Self-Join) form
<entries>
<metadata>
<entry-count>1</entry-count>
</metadata>
</entries>
</query-update-action-result>