Using Data Entry Grids and Forms : Working with Data Entry Grids : Viewing Records in a Grid : Viewing Records Based on Selected ROWs
   
Viewing Records Based on Selected ROWs
To display records in a data entry grid based on pipeline segments selected in the Select ROWs window, follow these steps:
1 Select one or more pipeline segments in the Select ROWs window (Figure 7-33). Select pipeline segments with facilities you want to work with, then click Save to close the window.
Figure 7-33. Select ROWs
2 Open the Edit <module> Data window. For example, click Data Entry > Edit CPDM Data to open the Edit CPDM Data window.
3 Select a data entry grid. For example, click the Inspection tab and then the Test Point button to display the Test Point Inspection data entry grid (Figure 7-34).
Figure 7-34. Test Point Inspection Grid
4 If you want to collapse the Selected ROWs panel to view more of the grid, click the Selected ROWs bar. Clicking the bar again expands the panel.
5 Complete either step "a" or "b" to display records in the grid based on selected ROWs:
a Click the Based On tab to open the Based On panel (Figure 7-35) and then complete the following steps:
1) Click the option Selected ROWs, then click Apply.
2) Click Close to close the Based On panel.
Figure 7-35. Based On Selected ROWs
b Click the Options tab to open the options page. Then click the option Selected ROWs in the Based On group box (Figure 7-36).
Figure 7-36. Based On Options
6 If you want to change the grid layout, sorting theme, or apply one or more filters to the grid, complete the following steps:
a To change the grid layout theme, click the down arrow in the field Select Layout Theme and select a theme in the selection list.
b To change the grid sorting method, click the down arrow in the field Select Sort Theme and select a theme in the selection list.
c To apply a filter to the grid, click the check box for a filter listed in the Filters group box (Figure 7-37). You can select more than one.
Figure 7-37. Filters Group Box
For example, to include only currently active facilities in the grid, click the Currently Active Facilities Only check box. A check mark inside the check box indicates a selection. To remove a filter from the grid, clear the check mark by clicking the check box.
Note: To add a new AND or OR filter group, refer to Adding an AND Filter Group.
d When applying a date filter to the grid, such as Inspection Date is between, set a date range using a calendar or dynamic dates in the following manner:
1) To set a date range using a calendar, click the down arrow in the start date field to open a calendar and select a date. Repeat this step for the end date field.
2) To set a date range using dynamic start and end dates, click the calculator button in the start date field and set up dynamic date properties. Repeat this step for the end date field. Clicking the calculator button opens and closes dynamic date property fields.
e Click Apply to save and apply changes.
Records display in the grid based on selected options.