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

Default value: ARSadapter

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

Valid values: true, false (default)

No

<version>

Specifies the version of the BMC Remedy AR System being used

Valid values:

  • v7.0
  • v7.5
  • v7.6
  • v8.0
  • v8.1
  • v9.0
  • v9.1

Yes

<item type>

Indicates the type of record to be obtained

Note

<item type> is not currently being used by the Query Update Items process.

No

<connection parameters>

Contains the metadata required by the adapter to connect to the target

Note

<connection parameters> is not currently being used by the Query Update Items process.

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

<items>
  <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

<query-update-action-result>
 <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

<query-update-action-result>
  <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

<items>
<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

<query-update-action-result>
  <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

<items>
<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

<query-update-action-result>
  <entries>
    <metadata>
      <entry-count>1</entry-count>
    </metadata>
  </entries>
</query-update-action-result>
Was this page helpful? Yes No Submitting... Thank you

Comments