View source for Results Enquiry

'''Results Enquiry''' is the screen in ''Quality Management › Panel Samples'' for looking at test results across many samples at once. Where [[Update Samples|Update Sample Results]] works on one process order and activity at a time, this screen answers questions such as "what did every sample of this material score on these three tests last week", with one row per sample and a column for each test you choose.

== Filters ==

Leave a filter empty to ignore it. Text filters must match exactly; the lookup buttons avoid typing mistakes.

{| class="wikitable"
! Filter !! Notes
|-
| Process Order || Lookup of orders; the list is narrowed to the Material if one is already entered.
|-
| Material || Lookup.
|-
| User Data 1 to 4 || The four site-defined sample fields, typically container code, packing line, shift and product group. Packing line and shift have lookups.
|-
| Sample Date from / to || Tick the box to apply each end of the range; the calendar button picks a date.
|-
| Inspection || Lookup of [[Inspections]].
|-
| Limit || Caps the number of rows returned, 1000 by default. Untick it for a full result set.
|-
| Tests || A list on the right of every test defined in the [[Dictionary]]. Click a test to tick it; each ticked test becomes a column in the grid.
|}

When at least one test is ticked, only samples that have a result for one of those tests are shown. With none ticked, every sample in range is listed without result columns.

== The grid ==

Sample ID, Sample Date, Material, Process Order, the four User Data fields, then one column per ticked test, headed with the test's description. A result that comes from a [[Selection Lists|selection list]] is shown as the list description rather than the stored code.

== Buttons ==

{| class="wikitable"
! Button !! What it does
|-
| '''Search''' || Runs the query with the current filters.
|-
| '''Edit''' || Opens [[Edit Sample]] for the highlighted sample.
|-
| '''Excel''' || Runs the query again and saves the rows to a spreadsheet, ''qm_results.xls'' by default. The Limit applies to the export too.
|-
| '''Close''' || Closes the screen.
|}

== Things to know ==

* The grid is empty until you press Search.
* An apostrophe in a text filter stops the query; the grid simply does not refresh. Use the lookups instead.
* Nothing can be changed or deleted from this screen; corrections are made in [[Edit Sample]] and [[Update Samples|Update Sample Results]].

== See also ==

* [[Update Samples|Update Sample Results]]
* [[Results Analysis and Reporting]]
* [[Panel Results]]
* [[Dictionary]]

[[Category:Commander4j]]