[Mass Maintenance] Mass Change Where Clause Workaround

Issue

The where clause for mass change only includes enabled fields instead of enabled and disabled. Although disabled, you should be able to filter on any of the columns in the request, but only update enabled fields. 

To view this issue:

1. Navigate to the Request Mass Change page.
2. Click Edit.

3. Select a column to be updated in the target ERP system from the COLUMN NAME list box.
4. Enter a replacement value for the COLUMN NAME in the VALUE field. The COLUMN NAME is replaced with the VALUE in the target ERP system. 
5. Click Save. 
6. Click Build Where Clause on the Page Toolbar to create a where clause that filters the data being updated.

7. View the available columns in the COLUMN NAME list box. 

 The COLUMN NAME for the mass change where clause only displays enabled fields. 

Why does this page work like this?

There is a DELETE portion of the [webRequestRole_MassChange_RequestMassChangeColumnIns] stored procedure that removes disabled COLUMN NAMES.

Workaround

To work around this issue, manually build a where clause on Vertical View of the Request Mass Change page to include the disabled columns. 

To manually build a mass change where clause on the Request Mass Change page:

1. Select Requests in the Navigation pane.
2. Click Roles for a request. 
3. Click DATA ENTRY for the role that allows data entry. 
4. Click Mass Change on the Page Toolbar. 
5. Click Vertical View for a Mass Change record. 
6. Click Edit. 
7. Enter a filter in the Where Clause field. 

8. Click Save. 

NOTE: Refer to the Online Help for more information on building a mass change where clause.