Display Groups of STATUS_FLAG=R

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Groups and Action Levels > Group Maintenance > Turning a Subfacility into a Location Group >

Display Groups of STATUS_FLAG=R

By default, RT_GROUP.STATUS_FLAG="A" and RT_MTH_ANL_GROUP.STATUS_FLAG="A" is added into ST_REPORT_PARAMETER.DATA_SOURCE so that groups with STATUS_FLAG<>"R" are not displayed in the group list of the report user interface.

 

Users can undo this functionality to show all groups, regardless of STATUS_FLAG value by following the steps below.

 

1.Find the ST_REPORT.REPORT_ID of the report.

2.Find the ST_REPORT_PARAMETER.DATA_SOURCE of the group related parameter for that REPORT_ID.

3.Remove the related code for XXX.STATUS_FLAG="A".

 

For example, for the Analytical Results Report, follow these steps.

 

1.Find ST_REPORT.REPORT_ID for ST_REPORT.DISPLAY_NAME="Analytical Results".

2.Sort ST_REPORT_PARAMETER for the above REPORT_ID and the group related parameters PARAM_NAME="@ANALYTE_GROUPS" and "@LOCATION_GROUPS".

3.Edit ST_REPORT_PARAMETER.DATA_SOURCE for the above parameters to remove G.STATUS_FLAG="A" and RT_GROUP.STATUS_FLAG="A".