The easy query allows you retrieve the most recent revision of an object from the database that satisfies the query criterion.
For example, if the following documents exist in the SmarTeam database:
Case 1
If the criteria of the query are:
Part Number = "PN0123" AND Attribute_1 = "TOTO", then the query result will contain only document #5:
Note that previously, this type of query would not produce any result, as the latest available revision for this query is document #7, but it does not match the attribute criteria "TOTO".
Case 2
If the criterion of the query is:
Attribute_1 = “T*”, then the query result will contain document #5 and document #9:
Note that previously, this type of query would result in document #9 only.
Mapping Groups
Multiple mapping groups may appear under one Mapping Group Type, but each mapping group is dedicated to a specific Reconciliator query/queries.
For example, under the Reconciliator Query Mapping Group Type, there are two mapping groups, Generic Query and Easy Query as shown below:
The Easy Query mapping group is used by the Reconciliator Query.
The Generic Query mapping group is used by queries basked on the Latest Available Revision and Interactive Latest Available Revision queries.
Similar changes have been done in the Reconciliator Query Result mapping group type.
Interactive Easy Query
The Interactive Easy Query can be accessed in the Reconciliator
Window from the Query Criteria drop down list.
The Interactive Easy Query is available by default on CXR20 and above provided that the proper SmarTeam Integration Tools Setup operations are performed. See Prerequisites for details.
