Edit1 What are Queries?
Queries provide a convenient method of searching for IssueNet items. Queries are created in the Query Builder which can be accessed by selecting the Query item in the Data Source Explorer.
Queries are based on a type of item, for example, issues or tasks.
A query can optionally contain one or more statements to filter the results. Statement types vary from a simple “Name equals Bob” to a more complex “Create Time of a related Issue greater than 12/12/2020”. Statements can be combined with “And”, where every statement must be true for an item to be included, or with “Or”, where only one statement must be true for an item to be included.
Edit2 Creating and Editing Queries
The Query Builder allows you to easily create database queries by defining a query statement to fit your search criteria.
These are the basic components of a query:
- Name- This is simply the name of the query.
- Category- The category of the query determines on which Query Panel the query will appear in the IssueNet Manager.
- Visibility This determines if users will be able to view the query. For example, if a user creates a query in the manager, it will only be visible to that user, but using the Administrator to set the Visiblity to Shared will allow other IssueNet user to view the Query.
- Description- This field allows you to enter a brief description of the query.
- Search For- This drop down contains a list of IssueNet items which can be queried.
- Statement- The Statement Type field lists the expressions available for defining your query statement. Select a statement expression and click Add to insert the expression into the Statement field. When the statement expression is added to the Statement field, you may click on the underlined text to specify the values to be utilized in your query statement.
Once you have defined your query statement, click either the Save button to save the query without running it; Save & Execute to save the query and run it; or Execute to run the query without saving it. Click the Close button to close the Query Builder and discard any changes that you have entered.