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

Add WHERE Clauses

In the NoetixViews Workbench, you can add a WHERE clause to a query of the view that is being modified.

To add a WHERE clause

  1. On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.

  2. Select a view, and then click Modify. For information, see Select a View. The Modify View » <view label> page appears.

  3. Under Where Clauses, click Add, modify & suppress where clauses, and then click Next. The Modify View » <view label> » Add, modify & suppresswhere clauses page appears.

  4. If you have more than one query in the selected view, a tab will appear for each query. Select the appropriate tab for the query in which you want to add the WHERE clauses. The list of WHERE clauses are displayed in a list. The following columns are available in the list:
    • Where Clause: Indicates the WHERE clause code.

    • Status: Indicates the status of the WHERE clause. If the WHERE clause is not modified, the status will be displayed as UNCHANGED. If a WHERE clause is added, the status will be displayed as ADDED. If a WHERE clause is modified, the status will be displayed as CHANGED. If a WHERE clause is suppressed, the status will be displayed as SUPPRESSED.

    • Start: Indicates the starting product version of the Oracle E-Business Suite application that is applicable to the WHERE clause.

    • End: Indicates the ending product version of the Oracle E-Business Suite application that is applicable to the WHERE clause.

    • Profile Option: Indicates the profile condition applicable to the WHERE clause.

  1. In the query area, click Add Where Clause. The Add Where Clause dialog box appears.

  2. In the Add Where Clause dialog box, perform the following:

    1. In the Tables for reference list, select a table that you want to include in the new WHERE clause. If the selected table is used in a subquery, go to step b. Otherwise, go to step c.

    2. The Table entry box appears displaying the selected table in the &<application label>.<table name> <table alias> format in the read-only mode. Click Append Table. The selected table will be included in the Where Clause box in the format in which it appears in the Table entry box.

    3. In the Columns for reference list showing the columns corresponding to the selected table, select the column that you want to use in the WHERE clause.

    4. The selected column will be displayed in the Column entry box in the <table alias.column name> format in the read-only mode. Click Append Column. The selected column will be included in the Where Clause box in the format in which it appears in the Column entry box.

    5. In the Where Clause box, you can also manually add entries.

      IMPORTANT: If the WHERE clause includes a table with a profile option, the subsequent generation of the view will fail if the profile condition is not met.The WHERE clause can contain a maximum of 1,000 characters.

    6. Click Save to return to the Modify View » <view label> » Add, modify & suppresswhere clauses page.

  3. Repeat steps 5 and 6 if you want to add another WHERE clause. The new WHERE clauses will be appended to the existing list of WHERE clauses in the query area, and the status of the new WHERE clauses will be displayed as ADDED.

  4. If you want to change the position of the WHERE clause that you have added, select the WHERE clause, and then, click Move up or Move down.

  5. If you want to add WHERE clauses to another query, repeat steps 4 through 8.

    NOTE: If you want to remove a WHERE clause that you have added, click the WHERE clause entry, and then click Delete. The selected WHERE clause will be removed from the list. After saving customizations to the view, you cannot remove the WHERE clause that you have added to the view.

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

  7. Click 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:

Add WHERE Clauses

In the NoetixViews Workbench, you can add a WHERE clause to a query of the view that is being modified.

To add a WHERE clause

  1. On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.

  2. Select a view, and then click Modify. For information, see Select a View. The Modify View » <view label> page appears.

  3. Under Where Clauses, click Add, modify & suppress where clauses, and then click Next. The Modify View » <view label> » Add, modify & suppresswhere clauses page appears.

  4. If you have more than one query in the selected view, a tab will appear for each query. Select the appropriate tab for the query in which you want to add the WHERE clauses. The list of WHERE clauses are displayed in a list. The following columns are available in the list:
    • Where Clause: Indicates the WHERE clause code.

    • Status: Indicates the status of the WHERE clause. If the WHERE clause is not modified, the status will be displayed as UNCHANGED. If a WHERE clause is added, the status will be displayed as ADDED. If a WHERE clause is modified, the status will be displayed as CHANGED. If a WHERE clause is suppressed, the status will be displayed as SUPPRESSED.

    • Start: Indicates the starting product version of the Oracle E-Business Suite application that is applicable to the WHERE clause.

    • End: Indicates the ending product version of the Oracle E-Business Suite application that is applicable to the WHERE clause.

    • Profile Option: Indicates the profile condition applicable to the WHERE clause.

  1. In the query area, click Add Where Clause. The Add Where Clause dialog box appears.

  2. In the Add Where Clause dialog box, perform the following:

    1. In the Tables for reference list, select a table that you want to include in the new WHERE clause. If the selected table is used in a subquery, go to step b. Otherwise, go to step c.

    2. The Table entry box appears displaying the selected table in the &<application label>.<table name> <table alias> format in the read-only mode. Click Append Table. The selected table will be included in the Where Clause box in the format in which it appears in the Table entry box.

    3. In the Columns for reference list showing the columns corresponding to the selected table, select the column that you want to use in the WHERE clause.

    4. The selected column will be displayed in the Column entry box in the <table alias.column name> format in the read-only mode. Click Append Column. The selected column will be included in the Where Clause box in the format in which it appears in the Column entry box.

    5. In the Where Clause box, you can also manually add entries.

      IMPORTANT: If the WHERE clause includes a table with a profile option, the subsequent generation of the view will fail if the profile condition is not met.The WHERE clause can contain a maximum of 1,000 characters.

    6. Click Save to return to the Modify View » <view label> » Add, modify & suppresswhere clauses page.

  3. Repeat steps 5 and 6 if you want to add another WHERE clause. The new WHERE clauses will be appended to the existing list of WHERE clauses in the query area, and the status of the new WHERE clauses will be displayed as ADDED.

  4. If you want to change the position of the WHERE clause that you have added, select the WHERE clause, and then, click Move up or Move down.

  5. If you want to add WHERE clauses to another query, repeat steps 4 through 8.

    NOTE: If you want to remove a WHERE clause that you have added, click the WHERE clause entry, and then click Delete. The selected WHERE clause will be removed from the list. After saving customizations to the view, you cannot remove the WHERE clause that you have added to the view.

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

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