Batch Query Conversion

The new Batch Query Conversion tool has been created and consists of the following components:

• convert_queries.bat – a Windows batch file which can be executed as a system command,
• convert_queries.js – JavaScript code which performs the conversion.

The convert_queries.bat file should be modified before it is used.

All these files are located in $DovetailAgent\scripts folder.

To run the script, execute a command:

CScript convert_queries.js [option...] parameters

where 'option' is any CScript option.

Note: all the reporting messages will appear on the console. Redirect this stream to a file for analysis.

The parameters include:

• /directory:<dir> – working directory
• /convert:<true> – perform the conversion if true, otherwise preview only
• /query:<objid> – if objid specified, only process this query (equals to the value of table_query.objid column)
• /object:<object_id> – if specified, perform Query Conversion only for specified object type, e.g. use 0 for case queries, 24 for subcase queries, etc.
• /user:<login_id> – user login id whose queries are to be converted
• /supervisor:<login_id> – if specified, the login id of a supervisor. All users who report to this supervisor would have all of their queries processed

The script uses /directory:<dir> parameter to locate fc.env file with database connection credentials. This parameter is optional. If it's not present, current directory will be assumed.

If any combination of /supervisor, /user, and /query parameters is used they are prioritized as follows:

1. /supervisor
2. /user
3. /query

Examples:

get help with parameters

CScript convert_queries.js ?

preview-only run, use fc.env file in the directory provided

CScript convert_queries.js /directory:my_path\my_directory

preview-only run, use fc.env file in current directory, examine only queries created by specified user

CScript convert_queries.js /user:<user>

conversion run, use fc.env file in the directory provided, convert specific query only

CScript convert_queries.js /directory:my_path\my_directory /convert:true /query:<objid>

a sample fc.env file is provided in the $DovetailAgent\scripts folder.

Did this topic help you? Email us your feedback.
Last updated: 8/19/2014 2:21:46 PM
© by Dovetail Software, Inc.