Modify Queries

You can modify the query details except the query position and group by information.

To modify a query

1. In the NoetixViews Workbench, select a view that you want to modify. For more information, see Select a View.

2. On the Modify View » <view label> page, under View, select Copy, modify & suppress queries, and then select Next. The Modify View » <view label>» Copy, modify & suppress queries page appears showing the list of queries available in the view.

3. Select a query, and select Modify. The Edit Query <query position> dialog box appears.

4. In the dialog box, perform the following:

1. In the Set Operator list, select the required set operator.

Note: You cannot modify the Set Operator of the first query irrespective of its position.

2. In the View Query Comment box, provide a comment about the query. The comment can contain a maximum of 75 characters. For example, specify query comment as "Accounts Payable Transactions" for the CE Reconciliation Lines view.

3. In the Hint box, specify a SQL hint to improve the performance of the query. The hint can contain a maximum of 4000 characters and must be provided in the following format: /*+<hint>*/ . For example, specify hint as "/*+ LEADING (GLBAL) */" for the GL Budgets view.

5. Select OK.TheModify View » <view label> » Copy, modify & suppress queries page appears showing the modified query with the state "CHANGED".

6. Repeat steps 4 to 6 to modify more queries.

Note: You can also copy, suppress, or delete the query. For information about these tasks, see the respective topics under Manage Queries.

7. In the Customization comments box, provide a summary of the customizations that you have performed. The comment can contain a maximum of 200 characters.

8. Select Save. The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.