Advanced Queries

The Advanced Queries section of the document tracking application is one of the most powerful features of document management in BizTalk Server.Within the Advanced Query interface, you can interactively build queries to extract only the data of interest to you.The Advanced Query Builder page is shown in Figure 6.3.

Figure 6.3 The Document Tracking Advanced Query Builder Page

UICIP Mk Wrh i -THi.'4tH

Advanced Query Quildur

C«te o cuieff tMt iiwithe ío)iow¿iy «Mtlctvil mmlIi


'/.. tw

r- in**

I JI^-iih VAH


iLujjrfillh*■ T'.yy'lyivy.I^'I^'I .


rt v- Hhwi-Jd

> HOT G»


|Ti i», f V^-^l^p^'^—'

W» Of


This first element on this page is the "Source selection" combo box. This dropdown is populated with a list of tracked fields from the dta_custom_field_names table, so each entry represents an XPath expression that points to a field in one or more corresponding instance documents. These represent all the unique field types from all the documents that your BizTalk Server has received, so this list could grow very large over time, depending on the number of different types of documents fields you choose to track.To begin entering a new search criterion, click New. (You will notice that the button's caption changes to Done.)

Once a source field is selected, you can choose a comparison operator and a value to compare to the source field.The final selection you need to make is in the AND/OR combo box, which allows you to specify the logical operator to combine this expression with the subsequent expression. The Logical grouping text box near the bottom shows how the accumulated criteria you have entered will be logically associated into a query. As you enter in each search criterion, it is simply added to the logical grouping in a left-to-right manner. Because of this, it is important to lay out your query carefully if it contains a mixture of ANDs and ORs. The query builder automatically associates consecutive entries that are separated by OR by surrounding them in parentheses, yet it does not provide any other mechanism to adjust the associativity of criteria after their initial entry.This results in a slightly limited functionality, but anything but the most complex queries can be created with a little planning. For anything more complicated, it is always possible to query the SQL Server database directly, either from query analyzer or from an independent application.

Was this article helpful?

0 0

Post a comment