Open topic with navigation

Include or Exclude a Field in the SQL Code

This topic describes how to include or exclude a field in the SQL code for a Select query.

Before You Begin

When you create a query, all the fields that you added are selected by default to be included in the SQL code. In some cases, you might want to add a field to the grid in the Conditions section so that you can define criteria for that field without including it in the SQL code.

For example, you might want to configure a query that returns all Pumps installed on a certain date. You could add the Pump ID field and the Asset Installation Date to the query, define criteria to limit the Asset Installation Date to a certain date, and then exclude the Asset Installation Date. This would increase performance and still return the records you are interested in viewing.

Steps

1. Access the Design workspace.

2. For the field that you do not want to include in the SQL code, in the Include cell, clear the check box.

   When you run the query, the field will not appear in the results.

Results

• When you clear the Include check box for a field, the Display check box for that field is automatically cleared. Fields can be displayed in the results only if they are also included in the SQL code.
• If you exclude a field from the SQL code, you must define content in the Criteria cell, the Sort cell, or the Total cell in that column for the field to be saved with the query code. In other words, if the field is not included in the query, it must be included in the SQL code in some other way to be saved with the query. Otherwise, when you open or run the saved query, the excluded field will not be displayed in the Design, Results, or SQL workspaces.

Copyright © 2018 General Electric Company. All rights reserved.