This file is a storage facility (in XML form) for Jet-SQL statements for use in the administrative "SQL Reports" tool.
There are two important nodes in this XML file:
The <defaultQueries> node and its children: This node contains Jet-SQL statements that are made available to the "Auto Reports" page. These are statements that we at 20/20 Applications have developed and include in the product for customer convenience.
The <savedQueries> node and its children: This node contains Jet-SQL statements that are created by users or administrators of 20/20 DataShed on your web site and are managed automatically by the "Save Report" and "Delete Report" buttons in the "Custom Reports" and "Build New Report" interfaces.
Permissions and Security
Server
This file may inherit the permissions from its parent folder; but in addition to the folder's settings it requires that the IUSR_<localmachinename> (or equivalent) user account have NTFS permissions to read and write/modify content in the file.
This contents of this file are available without security. The raw XML data does not (and should not) contain sensitive information.
However, the "SQL Reports" interface which uses the Jet-SQL statements in this file to build reports from your data is protected first by username and password protected authentication (via the "login.asp" and associated pages), and secondly by the administrative security roles configured by the administrator of 20/20 DataShed on your web site. Only the users who have either Read or Write permission to view the "SQL Reports" interface will be able to utilize the reporting tool.
How to Maintain
This file should be backed up regularly (or perhaps each time you create a new custom report).
Included In (Files)
This file is not included via SSI (Server-Side Includes), but rather its contents are read by the "SQL Reports" interface via the XML DOM.
How to Customize
We recommend that this file should be customized only by personnel who have extensive experience with XML and Jet-SQL.
By transferring a single <query> node (and its children) from the <savedQueries> nodelist to the <defaultQueries> nodeList, you can change which interface the query is displayed in. For example, the children of <defaultQueries> are made available in the first reporting interface called "Auto Reports" (by default), while the children of <savedReports> are made available in the "Custom Reports" interface. Depending on your needs and how frequently your administrators use the reports that you build you may want to make specific reports accessible in the first window instead of the second.
Customize For Use With T-SQL
If you have chosen to use a T-SQL compatible database with 20/20 DataShed (such as Microsoft's SQL Server, Oracle, mySQL, etc.), then it may be necessary to translate all queries in this file to T-SQL.
Warning
If you must access these files using another product or software, do so at your own risk; such activity is not supported by our license agreement and may void 20/20 Application's technical support obligations.
Send Feedback