|
|
|
The Query Converter tool reads Clarify queries defined in Clarify Client application and anchored in table_query, and creates Queries objects.
The tool can be used in 'preview' mode to analyze the resulting Queries before actual conversion.
After the Clarify queries are converted they remain available to Clarify Client user, they will not be removed or modified in any way.
The conversion results
For each Clarify query a new Dovetail-type query is created. It is associated with an alias named 'table_name query user_version) where table_name is the name of the base table for the converted query, and user_version is the Clarify Query Edit form user version (in case this form has been customized. If not, user_version will be blank). If an alias of such a name does not exist, it will be created. For example, all case queries will be associated with the alias of 'case query' having table_case as the base table (if Clarify Case Query Edit form #806 has been customized and saved with user version of 'expanded' then the alias name would look like this: 'case query expanded'). It is important to note here that all the case queries will be associated with the same 'case query' alias which means that all the properties used in all these queries will accumulate in the definition of this alias.
The converted query will have a table as a base query object, not a view: i.e. case query will build its SELECT statement starting from table_case, not from table_qry_case_view. Results grid column headings will be the same and in the same order as defined in Clarify Query List form for the output view.
The converted query will be associated with the owner of the original query.
It will be iconified for its owner if it was iconified in Clarify.
If it was shared in Clarify with other users it will also be shared with the same users after conversion. It will also be iconified for these users if it was iconified in Clarify.
All the Clarify queries which allow keyword searches will have an additional search property added:
This additional property will not be marked as 'Output Col' column unless they have been added to the original view.
All search filtering properties defined in Clarify will be added to the new query as 'Properties' but not as 'Output' columns unless they happen to be one of the original view columns.
The sort field, if defined, will be marked in the new query as a 'Sort Col'.
Special considerations
It is recommended that users should run the tool in 'preview' mode first and review the report. There may be several messages in it requiring attention:
Warns the user that this query was defined in Clarify without using any keywords and search parameters, and therefore may have a performance impact on the system because it will have no restraints on the number or records returned other that query_rowlimit (configurable in Dovetail Admin). However, the query does not have to be modified.
Warns the user that this query's property refers to a list by name, and there are both Clarify and User-defined lists of the same name defined in the system. The tool assumes that Clarify list is to be used, but if this is not the case the user must update the query manually after conversion.
Informs that this query has been already converted. If a query changes after being converted it will not be updated. To convert again an updated query, delete it in Dovetail Agent and re-run conversion script for this query.
This message requires attention and the query must be manually corrected. The reason is that the original view has more than one path between a pair of the same tables and the tool does not guarantee that the right one was generated. Each query property with this message must be reviewed and corrected manually to assure the right path is being followed. For out-of-the-box Clarify queries only the Receipts Query is affected.
See Also |
Next |