In this sheet, you can create a reference query UID and update that UID in the Column-item section.
-
Open WQMS-Admin Excel file.
-
Navigate to WQMSReferenceQuery sheet and edit the following properties:
-
UID - Type a unique identifier for the reference query in the UID syntax.
-
Name - Type a name for the reference query.
-
Description - Provide the description for the column-item.
-
Reference Item ClassDef - This property defines the class definition of the source column-item that must be created in the reference list.
-
Display Property Def - This defines the property of the Value Property Def that must be displayed in the UI.
-
Value Property Def - This property defines the column-item of the source class definition that must be created in the reference.
-
Query Property Criteria - This property defines all the dependencies for the data that must be sorted. The data that satisfy the sorted requirements are in the reference list.
-
WQMSRefQueryDisciplineProp - This property sorts the reference list data based on the disciplines.
-
ContainerID - Defines the package or .xml file that contains the object.
-
Solution(s) - Type * to load the data to SPF database, or type Deleted to avoid loading the data to SPF database.
-
-
Save the file.