Help Page
| MISWEB Home Page | Query Tips | Make Your Own |
The MISWEB utility is a tool which allows you to query the MISCOMP database directly from html pages. The MISCOMP Project Team will create a series of html pages as general usage dictates. Or, you may create your own customized web query pages using MISWEB.
You may use MISWEB by simply following html links from a web page that contains a list of valid queries. You select the query that you want to execute and select the appropriate submit button:
For additional query tips, see the MISWEB Query Tips help page. For more help building your own MISWEB query pages, see the MISWEB Interface Specification
When you use the Run button, the query you have choosen, or built if you were on the Build/Edit pages is executed. The results of your query are tabularized and displayed in a series of html pages. The html output page length is determined by the page per rows parameter, which may be defaulted differently based on the initiating web page for your query.
Or, you may also direct MISWEB to provide your output in tab delimited format and automatically launch your favorite spreadsheet package. For details on using this feature, including how to setup your web browser, read about the output_type tag in the Format Tags section of the MISWEB Interface Specification.
When you select the Build option, a query building page is presented, displaying all columns in each table or view used in the query you selected. You pick which columns you want displayed in your results by selecting the appropriate check boxes.
You are also allowed to enter up to 3 where conditions for each table or view in the query. Where clauses are entered by picking the column name from the pull down list of columns, picking the SQL operator from the list of operators, entering the limiting value, and then deciding if you want the limiting value converted to upper or lower case for the comparison.
You may even select the sort order for the query, by picking up to 3 order by conditions from the list of all columns in the query selected. Sort orders may be in ascending or descending order.
You are also asked if the where conditions you entered should be combined using boolean AND or OR logic.
Finally, you are asked two questions regarding the quantity and format of your output. You are asked the number of rows you want to see per page, and the maximum number of records you want returned from your query. The defaults for the rows per page and the maximum number of records may be established by the originating web page. The standard defaults are 20 rows per page and 240 maximum records. You may also use the value "x" to indicate that you want an infinite number of rows returned. This infinite capability is useful, and in fact required, when you are doing group by statements in your query. Note, however, that in order to avoid overloading our server, we have enforced a maximum of 75 pages of output per query. After printing 75 pages your query will be terminated.
After completing all the above, you may either select either Run, Edit, or Make.
Selecting Edit allows you to view the SQL query that was created based on your selections. You may edit this query, adding any valid SQL commands that you desire. Then, you may execute the query directly from this page.
The Make option allows you to make your own html page with a query that you have built up using the query Build or Edit pages. An html page is made including all the necessary hidden variables that will be needed to drive MISWEB, and the resulting SQL statement is displayed on your page. You may save the html source that is made for you and edit it as you like.
The html made for you will include Data Tags, and Format Tags. It will also include Tally Tags and Drill Downs Tags if they were included behind your original Build/Edit page. You may want to change these tags, or add additional Where Tags or other tags to your html page to make it more useful. See the MISWEB Interface Specification document for more help in changing and adding these tags.
| For help contact miscomp@fnal.gov |