This command allows you to update an existing record within ExtraView\u2019s database. Only values that are being altered need be supplied within the API call. Fields whose values are to remain the same need not be supplied as parameters. All defined business rules using the preupdate and the postupdate directives are executed and checked before and after the record is updated. The fields used with this command are typically those that are placed on the EDIT_PROBLEM layout for the business area and project specified in the syntax of the command.<\/p>\n
http:\/\/www.myserver.com\/evj\/ExtraView\/ev_api.action? \tThere is one additional name and value pair that can be provided, that is not a field within ExtraView. This is <\/span><\/span>&send_email=no<\/span>. If you supply this name and value pair, then the update will override the set default with which ExtraView will generate email upon the update of an existing issue.<\/span><\/span><\/p>\n If the issue is updated without error, the function will return the issue number as shown below. Note that the term <\/span>“Bug #”<\/span> <\/span>is dependent on the screen title used for the ID field in the data dictionary.<\/p>\n Bug # 12352 updated.<\/span><\/p>\n You must provide a valid name and value pair for the ID field. The value must be an existing issue ID within the ExtraView database. If you do not provide this, an error message is generated.<\/p>\n The optional parameter <\/span>strict<\/span>, with a value of <\/span>yes<\/span>, enforces the action to operate only on <\/span>ALT_ID.<\/span> <\/span>If there is no match for the value of the <\/span>ALT_ID<\/span> <\/span>in the specified <\/span>ID <\/span><\/span>parameter, then the message <\/span>Invalid Id <\/span><\/em>will be returned. This means that a matching <\/span>ID<\/span> <\/span>value will be ignored.<\/p>\n Many of the fields within the ExtraView database, such as product_name, status, priority, severity_level, assigned_to, category, etc., must be given valid values that already exist within the metadata of your installation. If you attempt to enter a value that is not known to ExtraView, an error message will result.<\/p>\n If you attempt to contravene a business rule, an error message will result. For example, if your installation only allows issues to be FIXED if they are in an OPEN state and you provide a value of CLOSED, an error message will result.<\/p>\n All field permissions are obeyed with the command, and if you attempt to update a field that does not have write permission, then the whole command will fail.<\/p>\n Usually, when one or more specific repeating rows must be affected (modified or deleted) through the update command, the PROBLEM_RELEASE_ID parameter is used to identify specific rows. More than one instance of PROBLEM_RELEASE_ID may be specified. In this case, each <\/span>field=value<\/em> <\/span>parameter corresponds to the PROBLEM_RELEASE_ID which shares the same position in the parameter list for the same field name.<\/p>\n Thus, for example,<\/p>\n …&problem_release_id=111&problem_release_id=222&rr_field=abc&rr_field=def<\/span><\/p>\n maps the<\/p>\n rr_field=abc<\/span> <\/span>to <\/span>problem_release_id 111<\/span> <\/span>and <\/span>rr_field=def<\/span> <\/span>to <\/span>problem_release_id 222<\/span>.<\/p>\n When no PROBLEM_RELEASE_ID in the parameter list maps to a specific <\/span>rr_field=value<\/span>, then a new repeating row is added to accommodate the new value.<\/p>\n ExtraView supports repeating rows of multiple types. Each type denotes a grouping of fields based on a layout with that <\/span>item group type<\/em>. All repeating row types can be updated via the API. There are two ways of specifying a repeating row type:<\/p>\n Note1: Specific and generic PROBLEM_RELEASE_ID\u2019s may not be combined in a single API call.<\/p>\n Note2: Each API Update operation using generic PROBLEM_RELEASE_ID values can support only one repeating row type. Attempts to mix two or more repeating row types in a single API operation with generic PROBLEM_RELEASE_ID\u2019s will return with an exception.<\/p>\n The <\/span>edit<\/em> <\/span>screen layout, along with the repeating row layouts applicable to the update request, define which fields belong to which item group type, and therefore, which PROBLEM_RELEASE_IDxxx\u2019s apply.<\/p>\n When generic PROBLEM_RELEASE_ID\u2019s are used, all the specified fields must be grouped into the same item group type (via the edit layout and the repeating row layouts) \u2013 this item group type is used to qualify the PROBLEM_RELEASE_ID values.<\/p>\n …&PROBLEM_RELEASE_ID3=111&PROBLEM_RELEASE_ID4=222&field1=val1&field2=val2<\/span><\/p>\n where <\/span>field1<\/span> <\/span>is in the repeating row layout of item group <\/span>type 3<\/span> <\/span>and <\/span>field2<\/span> <\/span>is in the repeating row layout of item group <\/span>type 4<\/span>, both of which are embedded in the edit layout for the user\u2019s curren business area, project and role. Then two repeating rows are updated, one with <\/span>field1=val1<\/span> <\/span>and the other with <\/span>field2=val2<\/span>, each in a different repeating row type.<\/p>\n …&PROBLEM_RELEASE_ID=111&field1=val1<\/span><\/p>\n where <\/span>field1<\/span> <\/span>is in the repeating row layout of <\/span>item group type 3<\/span> <\/span>and repeating row 111 is in <\/span>item group type 3<\/span> <\/span>results in the update of <\/span>field1<\/span> <\/span>in the specified row. Note that there is no item group type specified in the PROBLEM_RELEASE_ID variable name.<\/p>\n To add new repeating rows, values for fields in the repeating rows are provided without a corresponding PROBLEM_RELEASE_ID value. For each non-corresponding value of a field, a new repeating row is inserted. Thus, specifying <\/span>&rr_field_a=1&rr_field_a=2&rr_field_a=3<\/span> <\/span>with no specification of PROBLEM_RELEASE_ID will result in three new repeating rows being added with these values, assuming <\/span>rr_field_a<\/span> <\/span>is a field in the repeating row. To update a repeating row value, you must provide the PROBLEM_RELEASE_ID value of the row in question.<\/p>\n Within the ExtraView GUI, users check a box named PROBLEM_RELEASE_DELETE in order to delete a repeating row. The API can emulate this behavior, by setting PROBLEM_RELEASE_DELETE to the checked for value for any repeating row you wish to delete.<\/p>\n For example, use a call similar to the following to delete a repeating row:<\/p>\n These fields require additional metadata in the form of a description and the file to upload’s character set. You will have created an HTML form for the upload. An HTML snippet that shows how to make this work is as follows:<\/p>\n This form assumes an image field that has a data dictionary name of <\/span>image_dd_name<\/span>. Note the optional <\/span>charset<\/span> <\/span>and <\/span>desc<\/span>. The <\/span>charset<\/span> <\/span>is not required for image fields, but for documents it can be useful. The default, if <\/span>charset<\/span> <\/span>is not given is UTF-8.<\/p>\n","protected":false},"excerpt":{"rendered":" This command allows you to update an existing record within ExtraView\u2019s database. Only values that are being altered need be supplied within the API call. Fields whose values are to remain the same need not be supplied as parameters. All defined business rules using the preupdate and the postupdate directives are executed and checked before…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24223,"menu_order":75,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24271","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\n
\n\tuser_id=username
\n\t&password=password<\/span> <\/span>OR <\/span>[&access_token=token-value]
\n\t&statevar=update
\n\t&p_template_file=file.html
\n\t&id=nnnnn
\n\t[&strict=no | yes]
\n\t&field1=value1 [&field2=value2] [fieldn=valuen]<\/p>\n\n\tNOTES<\/h3>\n
\n\tThe Role of PROBLEM_RELEASE_ID in the update Command<\/h3>\n
\n\tMultiple Repeating Row Types<\/h3>\n
\n
\n\tExample of specific PROBLEM_RELEASE_ID Update<\/h3>\n
\n\tExample of generic PROBLEM_RELEASE_ID Update<\/h3>\n
\n\tUsing update to Add Repeating Rows<\/h3>\n
\n\tUsing update to Delete Repeating Rows<\/h3>\n
\n\tuser_id=username
\n\t&password=password
\n\t&statevar=update
\n\t&id=nnnnn
\n\t&problem_release_id=xxxxx
\n\t&problem_release_delete=checked<\/div>\n\n\tUpdating Document & Image type fields<\/h3>\n
Image Description: <input type=\"text\" name=\"image_desc\" value=\"image_dd_name desc\" \/>
\n\t<br \/>
\n\t<input type=\"hidden\" name=\"image_dd_name_charset\" value=\"UTF-8\" \/>
\n\tFile to upload: <input type=\"file\" name=\"image_dd_name\" \/><\/code><\/div>\n