BizTalk360 provides the options to save and delete the query expressions as provided by the BizTalk Admin Console. Users can save the queries for easy access in future.
Saving the query expression
To save the query expression, follow the steps as shown below:
- Log in to the BizTalk360 application
- Click 'Operations' tab in the Navigation panel
- Click the expand button against 'Data Access' tab and select 'Advanced Event Viewer' link
- Select the appropriate filter criteria (if any), and click Execute Query
- BizTalk360 v8.0 allows users to export the Query Results. Click Export to Excel link to download the report to your computer.
- Once the query results are available, click the Save Query icon (floppy disk icon) to save the query
- In the Save Query page, enter the name to save the query expression
- Click Save to save the query expression
Once the query is saved, the tab name will be renamed to the name of the query.
Click the sliders to view the process of saving the query expression.
Save As (Saving an already saved query expression with a new name)
To save an already saved query expression with a new name, follow the steps as shown below:
- Log in to the BizTalk360 application
- Click 'Operations' tab in the Navigation panel
- Click the expand button against 'Data Access' tab and select 'Advanced Event Viewer' link
- Click the Open Saved Query icon (folder icon). Select the query name from the list to open the saved query
- The tab name will be renamed to the name of the query and the saved filter criteria will be displayed under the Build Query Expression section
- Click the Save Query As icon (files icon). In the Save Query As page, enter the new name to save the query expression
- Click Save to save the query expression
Click the sliders to view the process of saving an already saved query expression with a new name.
Opening the saved query expression
To open the saved query expression, follow the steps as shown below:
- Log in to the BizTalk360 application
- Click 'Operations' tab in the Navigation panel
- Click the expand button against 'Data Access' tab and select 'Advanced Event Viewer' link
- Click the Open Saved Query icon (folder icon). Select the query name from the list to open the saved query
- The tab name will be renamed to the name of the query and the saved filter criteria will be displayed under the Build Query Expression section
- Click Execute Query to generate the query results
Click the sliders to view the process of opening a saved query expression.
Deleting the saved query expression
To delete the saved query expression, follow the steps as shown below:
- Log in to the BizTalk360 application
- Click 'Operations' tab in the Navigation panel
- Click the expand button against 'Data Access' tab and select 'Advanced Event Viewer' link
- Click the Delete Queries icon (trash bin icon)
- In the Delete Querie(s) page, click the delete icon (trash bin icon) against the query name that has to be deleted
- The query will be deleted from the list. Click the X button to exit from the Delete Querie(s) page
Click the sliders to view the process of opening a saved query expression.