Create custom query - Intergraph Smart Reference Data - Help - Hexagon

• To create the custom query, create a custom procedure (checkmissingf2fvalues) in the Oracle database under Packages > M_PCK_SP3D_RULES_CUSTOM as shown:

  

  You can also use any text editor to create these routine packages and run on the Oracle database.

Let's consider an example to verify whether all the values associated with FacetoFace attribute are exported for the Ball Value commodity codes data.

1. Validate and check whether all the FacetoFace value is retrieved or not for the BallValvePDB2256 part mentioned in the following screenshot . If the value is not retrieved, then report it.

   

2. Create a verification report under Verification Sets/Reports tab.

   

   1. Under the Attributes tab, define the properties for the erroneous data that you want to store from the Ball value sheet.

   2. Define the Verification function in the custom package that you will write to put the validation code.

   3. For the verification code, refer to the sample provided in the M_PCK_SP3D_RULES_CUSTOM custom package.

      

   4. The logic for the verification code is available under the Oracle package body. See the procedures in the following screenshots.