WEBVTT

1
00:00:00.600 --> 00:00:05.046
Finding an answer begins with a clear question and the right records.

2
00:00:05.046 --> 00:00:12.695
This walkthrough shows existing column filters, sorting, and record inspection,
using the Water Quality demonstration.

3
00:00:12.695 --> 00:00:19.755
It also explains why a visible export button does not guarantee that a formatted
export has been configured.

4
00:00:21.155 --> 00:00:25.601
Start by opening the register that contains the information you need.

5
00:00:25.601 --> 00:00:29.917
This shared platform walkthrough uses Water Quality as its example.

6
00:00:29.917 --> 00:00:34.298
Analytical Results contains five hundred seventy-six seeded records.

7
00:00:34.298 --> 00:00:41.229
Rather than reading every row, we will ask a precise question: which records have
the nondetect qualifier?.

8
00:00:42.529 --> 00:00:46.992
Open the options button beside Qualifier and choose Set filter.

9
00:00:46.992 --> 00:00:50.662
The menu supports Starts With, Equals, and Contains.

10
00:00:50.662 --> 00:00:54.189
Select Equals, enter N D, and apply the criterion.

11
00:00:54.189 --> 00:01:04.338
An exact qualifier filter makes the question explicit and avoids confusing
nondetect records with ordinary measured values or unrelated text.

12
00:01:05.638 --> 00:01:07.790
The result is five matching rows.

13
00:01:07.790 --> 00:01:12.899
Notice the filter indicator beside Qualifier and the row count at the bottom.

14
00:01:12.899 --> 00:01:17.941
Reported Value is blank, while the detection limit and units remain present.

15
00:01:17.941 --> 00:01:26.277
This distinction matters: a nondetect is not automatically a numeric zero, and
filtering does not change the stored results.

16
00:01:27.577 --> 00:01:31.007
Open Result Number options and choose Sort Z to A.

17
00:01:31.007 --> 00:01:35.417
The same five records now appear in descending identifier order.

18
00:01:35.417 --> 00:01:40.877
Sorting changes presentation, while the qualifier filter determines membership.

19
00:01:40.877 --> 00:01:50.958
Check the actual sort column before interpreting sequence: identifier order is not
a universal substitute for collection or analysis date order.

20
00:01:52.258 --> 00:01:58.868
Double-click the row selector for result zero zero one three nitrate, then expand
its record panel.

21
00:01:58.868 --> 00:02:07.636
The full view shows sample reference, parameter, analysis date, qualifier,
detection limit, units, and recorded review information.

22
00:02:07.636 --> 00:02:11.345
This lets you inspect the context behind a matching row.

23
00:02:11.345 --> 00:02:14.920
No fields are changed or saved in this demonstration.

24
00:02:16.220 --> 00:02:23.497
The Export PDF button opens Custom Exports, but this menu currently has no active
custom export available.

25
00:02:23.497 --> 00:02:31.051
A usable formatted export needs an administrator to configure an appropriate
definition and verify its output.

26
00:02:31.051 --> 00:02:32.922
It is not demonstrated here.

27
00:02:32.922 --> 00:02:39.506
Returning from record detail also reloads this register with its default sort and
filter state.
