Data Grid test [Mobile only]

Circumstances under which you might want to add a Data Grid to a sub-inspection:

Example: You want the inspector to view the data and delete data and make corrections when needed. (The default setting prevents the operator from deleting data.) For example, the wrong serial number is used for an inspection. This would allow the inspector to delete the data for the incorrect serial number and re-enter the data under the correct serial number.

 

Contents  [Hide]

 

Printing a Data Grid from the mobile device

You can display and print a data grid when you are running a GS Collect inspection.

Follow the preferred steps below to print the data grid and remain in the GS Collect application. (Leaving the application closes the current session, requiring you to log in when you return to the application.)

  1. Press the Print button located in the upper-right side of the device screen.  This will display the data grid in "Print Preview" mode.

  2. Touch the "Print Preview" grid to display a menu at the top of the screen.

  3. Touch the Share button at the top of the screen, and then touch Print.

  4. On the printer options screen that displays, select the printer you want to use and any print options you want, and then press Print.

  5. After printing is completed, press Done to return to the GS Collect App.

Adding a Data Grid test to a sub-inspection

  1. Click the Data Grid test toolbar button to add this test to the sub-inspection.

  2. Set any properties for this test on the Properties panel that displays after the test is added.

Data Grid test Properties panel

For information about using the Properties panel, see Changing property settings

Data Grid test Properties descriptions

Property Field type Default setting or default display Allows
BEHAVIOR
DeleteData
[Mobile only]
True/False False. Does not allow the operator to delete the data at the server that is displayed on the grid. True allows the operator to delete the data and toggles the Submit data button label to Delete data. This is useful if the operator enters incorrect data and needs to re-enter it.
 
If the inspector clicks delete, all of the data displayed on the grid is deleted.
 
Note: Deletions are not tracked in the Audit Trail.
SQLQuery
[Mobile only]
Code [blank] Write a SQL statement to query the GainSeeker database and populate the data grid.
 
See Using the SQL Builder for Data Grid below in this topic.

Using the SQL Builder for Data Grid

The SQL Builder for Data Grid opens when the ellipsis button is clicked for the SQLQuery property for a Data Grid test. It is used to build and test SQL queries that you write to determine what values display on a running Data Grid during an inspection.

Example:

The SQL statement in the image below would replace the traceability 5 field [[trace5]] ) value with the actual value the inspector enters during the running inspection. The replacement value [[DDATA]] would also replace the current table name with the name of the current configuration.

Related topic