How-to Example - Executing Query Definitions with Effectivity Resolution

This section outlines executing a Query Definition and applying Effectivity Resolution. This involves:

1. Retrieving the Query Definition AML
2. Specifying values for the query parameters of the Query Definition
3. Executing the Query Definition with Effectivity Resolution

You can retrieve the Query Definition AML using the following AML query:

<Item type="qry_QueryDefinition” id="%ID%" action="get” levels="2" />

To execute a Query Definition with Effectivity Resolution, values for the appropriate query parameters must be specified. This can be done using the Query Definition’s AML as the starting point.

1. Open the Query Definition AML retrieved in Section Retrieve Query Definition AML.

2. Find the “EffectivityScopeId” qry_QueryParameter item. Add the following XML node: <value>%value%</value> with the Effectivity Scope Item ID as the value of the node. In the following example, the ID of the “Aras Part BOM Scope” Effectivity Scope is used.

   

   

Figure 61.

3. Prepare the Effectivity Criteria defined in free-form Boolean language in the following format:

   <EQ>...</EQ><EQ>...</EQ>...<EQ>...</EQ>

For example:<EQ><variable id="ID_OF_MODEL_VARIABLE"/><named-constant id="ID_OF_MODEL_ITEM” /></EQ><EQ><variable id="ID_OF_UNIT_VARIABLE"/><constant type="int">11</constant></EQ>

4. Escape the XML generated in the previous step to make it XML-safe. This can be done using a text editor or an online XML escape tool. Save the resulting escaped string.

5. Find the “EffectivityCriteriaDefinition” qry_QueryParameter item. Add the following XML node: %value% with the escaped string defining the prepared Effectivity Criteria as the value of the node, similar to the following example:

   

   

Figure 62.

6. Find the qry_QueryReference item with no parent_ref_id node inside it. This item represents the entry point, or top node, for traversing a structure. Add the following XML node: <filter_xml>...</filter_xml> to provide a start condition. If the Query Definition’s top level (root) Item is an ItemType Item (e.g. Part), use:
   
   Expand Collapse

   <filter_xml>&lt;condition&gt; 
   
   &lt;eq&gt; 
   
   &lt;property name=&apos;id&apos; /&gt; 
   
   &lt;constant&gt;%ITEM-ID%&lt;/constant&gt; 
   
   &lt;/eq&gt; 
   
   &lt;/condition&gt;</filter_xml> 

If the Query Definition’s top level (root) Item is aRelationshipTypeItem (e.g.Part BOM), use:

<filter_xml>&lt;condition&gt; 

&lt;eq&gt; 

&lt;property name=&apos;source_id&apos; /&gt; 

&lt;constant&gt;%ITEM-ID%&lt;/constant&gt; 

&lt;/eq&gt; 

&lt;/condition&gt;</filter_xml> 

Figure 63.

7. Save the AML response.

1. Open the saved AML response from step 7 of section Specifying Query Parameter Values for the Query Definition.

2. Find the root qry_QueryDefinition item and set the value of its action attribute to “qry_ExecuteQueryDefinition”.

   

   

   Figure 64.

3. The resulting AML can now be run to execute the Query Definition with Effectivity Resolution applied using the set parameters for the resolution.