Batch Update

Overview:   

Batch Update is functionality that has been introduced in the framework which allows user to update the multiple records of any window. The purpose of this functionality is that the user can update the single /multiple records simultaneously. All the guidelines are explained in this document. Users must follow these guidelines to ensure the smooth working of application.  

Batch Update: 

User can update the records of any window by using batch update popup box. For this, user must login with System Administrator role. To use batch update, User must ensure about the entry of ENABLE_BATCHUPDATE with value Y in system config window. After that go to that window where user want to update records and click on batch update icon. A popup box of batch update will be shown on your window where you can choose the columns and set their values accordingly. Detailed description of this process is explained below.   

Open

How to use batch update: 

Step 1: 

• Login with System Administrator role.   

• Open the System Config window. And ensure about the entry of ENABLE_BATCHUPDATE with value Y.  if there is no existing record than create a new record of ENABLE_BATCHUPDATE.  

Open

• Go to that window where you want to update the records.     

• Select the single or multiple records that the user wants to update. 

• Click on the batch update icon located in the Action panel on the right side. 

• A popup box of batch update will be opened. 

“Here, you can select the columns and set their values as desired. 

 For instance, if we want to update two columns, 'message type' and 'Active,' for the seven selected rows as shown below:"   

Steps for Updating Record 

1. Go to Menu & Search for the Window i.e. Message & Label 

2. Click to open the window  

3. Select the records you want to update.  

4. Click on 'batch update' in the right-side action panel. 

5. A popup window will open. 

6. Select the column you want to update, such as 'Message type,' then set the value to 'Error' in the Query value field.  

7. Click on the plus button to add the column and values to the list. 

8. After clicking on the plus button, the updatable data will be added to the list 

9. You can add multiple columns and values that you want to update in the list by following the same steps.  

10. In case you want to delete some records from the list, you can remove them by clicking on the delete icon.  

11. Click on apply button, A confirmation dialog want permission. If you are sure than click ok.  

12. All the records will be updated.  

Remark: If all the records are successfully updated, the popup box will close. Otherwise, it will display a message for records that were not updated.   

 The user can not update the following fields: 

• Key Column  

• Read only  

• Not Updatable  

• Not displayed  

• Encrypted 

• Column that have any Callout 

• Fields that have display type of Image 

 All the updated records will be saved in AD_DirectQueryLog as log. User can check their logs on the “Direct SQL query Log” tab of the “Session Audit” window.