Download EDMControl User Guide and Menu Reference
Transcript
Query Option Obtaining Data from the Database alphanumeric characters. The system displays a message if you are not authorized to use this ID. Part Name: Enter a valid part name or select the Editor button and a scrollable list of valid Parts is displayed. The list depends upon the Project ID that is specified. Select only one. It may not exceed eighty alphanumeric characters. SQL Where: Select this entry if you want to particularize the data you are searching for. You may enter a Standard Query Language Where clause statement. Valid statements are contained in the /usr/apl/cadds/data/control/sql directory. It may not exceed 80 alphanumeric characters. Example of a Filtered Query Displayed in the Query Result Box The following is a brief example of data you might receive in response to a Query. 1. Specify a Query Name of Discipline Rules. 2. Enter the filter condition: dr_disc_name like ’CV%’ order by 1,2; EDMControl User Guide and Menu Reference 6-15