You use this dialog box to give your query a name and description.
Name
Type a unique name for your query.
Description
You can type a description of your query in this area.
Suppress Repeating Values
Select this check box to instruct the software to not display in the grid values that are repeated more than once.
-
When working with a Microsoft SQL database, selecting Suppress Repeating Values in combination with Note fields, causes the query/EDE to display incorrectly.
-
When any of the following Note attributes belonging to specific Item Types are included in your query, the complete EDE appears blank.
Item Type
Attribute Category
Attribute
Instrument
General Properties
Instrument Note
Loop
Identification
Loop Note
Panel
General Properties
Panel Note
Process Data (Shared)
General
Calculation Sheet Program Notes
Process Data Sheet Notes
Spec
Spec Sheet
Spec Note
Maintenance Event Activities
Custom Fields
Work Activity Text — User Defined Fields (UDFs) 001, 002, and 003.
-
When adding one of these Note attributes, when the software detect that it is not compatible with your query a message is displayed on the screen, but the software does not remove the attribute from the query, this you must do manually.
-
Browser views that were converted to EDEs after upgrading from version 2013 that include any Note field, appear completely blank when opened. To correct these issues, in the Edit EDE Definition dialog box clear the Suppress Repeating Values check box.