Query List

"Query" allows you to create and save queries used by ＨＭＩ.

The query describes the processing to be performed for a table on a database.

On this screen, the list of saved queries will be displayed.

Columns in the query list

Query ID

This displays the query ID. Refer to Basic information of the query for setting the query ID.

Operation

Setting

Click this button to move to the Edit screen of the selected query.

Duplicate

Click this button to duplicate the settings of the selected query and move to the Edit screen.

Delete

Click this button to delete the setting of the selected query.

When deletion is executed, a confirmation message will be displayed. To cancel the deletion, click the cancel button or X button. If the deletion is certain, click the delete button.

Lock function

Click the button and Edit screen is displayed. Use the unlock button on the editing screen to unlock. The locked page cannot be changed or deleted.

Summary

This displays the summary of the settings in the query.

Last updated

This displays the information at the time of the last updated.

Create Query

To create a new query, first click the "Create query" button to start.

Clicking the button brings the screen of the Edit screen.

Delete Multiple Queries

To delete multiple queries simultaneously, select the queries you want to delete and check off the checkbox located on the left of the query. Click "Delete Selected Query" button.

Also, all displayed lists can be deleted by checking off the box located at the upper left of the table.

"Delete" above. If you are certain to delete the selected queries, click the delete button.

Sort by Names and Last Updating

By clicking "Name", "Last update" on the screen, you can rearrange the query list in ascending or descending order.

Page Scroll Buttons

Ten items are displayed each page. Use these buttons below to see the specific page.

button: This displays the list of queries from beginning.

button: This displays the previous page in the query list.

1 Enter box：Enter the page number you want see and this jumps to the specified page.

button: This displays the next page in the query list.

button: This jumps to the last page in the query list.

Quick filter Enter box：This displays the query containing this string within its page ID in the list.