Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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.

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

    3. 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.

    4. 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.

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

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

  9. 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.

Published:

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.

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

    3. 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.

    4. 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.

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

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

  9. 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.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk