Data Integrity Module Run Time Parameters

Owned by Former user (Deleted)
Last updated: Jul 09, 2012 by Jeremy KeiperVersion comment
2 min read

This page only applies to versions of Data Integrity Module up to 1.1.3. This feature is no longer included in versions 2.0+.

Introduction

The Data Integrity Module allows checks to be added that except runtime parameters in order to execute the check. For example you can use a single check to find the patients born between 1950 to 1990 or 1990 to 2000 because in that check the date can be given at runtime. Hence the results of the check differ depending on the parameter that is given at runtime.

Adding a check

When adding a check, the user has to enter the code for a check by typing something in the place where a runtime parameter should be placed. For example if the query should return the list of patients having Ids greater than a given runtime parameter, the query has to be entered like "SELECT * FROM patient WHERE id >  (runTimeParameterId)". And in the Parameters text box the user has to type  (runTimeParameterId). You can name the parameter anyway you want but it is absolutely necessary that you type the same in the query as well as in the Parameters text box. If there are multiple parameters in the query, the parameters must be typed in the Parameters text box separated by a ; sign. So in summary;

Case 1:

Code = SELECT * FROM patient WHERE id > (runTimeParameterId) Parameters = (runTimeParameterId)

Case 2:

Code = SELECT * FROM patient WHERE id > (runTimeParameterIdOne) AND id < $runTimeParameterIdTwo$ OR id=%runTimeParameterThree@ Parameters = (runTimeParameterId);$runTimeParameterIdTwo$;%runTimeParameterThree@

Running the Check

In the Run Single Integrity Check page, when you select a check to run from the drop down list, if the query requires runtime parameters they will be listed below the drop down list and you are given a text box to enter the values for the runtime parameters. So if there are three runtime parameters the user has to type the three values for the three parameters in the "Values for Parameters" text box separated by a ; sign.

In the Run Multiple Integrity Checks page after each check, if the check requires parameters, the parameters will be listed and text boxes are provided to enter the parameters.

Running Checks From the Results Page

After a check(s) is executed, the results are given in the Results page and in that page there is a button to run the same check again. Once you press that if the check requires runtime parameters a dialog box pops up and the user has to type in the parameters in it for the check execution to take place.

Back to Main Page