Delen via


UriQuery

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The UriQuery class represents a Uniform Resource Identifier (URI) query associated with one or more transaction requests. A URIQuery object links to one or more Request objects.

Because the LogUser, URI, and URIQuery classes are the largest classes in the Data Warehouse, they have been altered to increase their performance. These classes do not have formal reldef relationships. Instead, they have an application-specific relationship with their children. This relationship is defined in the schema for completeness and purposes of discovery through the provider, but it is not used by the storage engine of the OLE DB provider for Commerce Server for writing parent instances. In application-specific relationships, the joining between the child and parent is not through the parentID, URIQueryID, but through the bigint 8-byte URIStringKey. After that, the parentID, URIQueryID is set to a constant, 999.

If the URIQuery class has a multivalue member, or if the class is involved in a many-to-many relationship, the URIQueryID is populated just like any other dimension. In this case, the linking table uses the IDs as the linking key, but the child classes still joins them through the QueryStringKey.

When you add a new relation to this class, you must update the stored procedure that is invoked for deleting orphans. Deleting information from this table without deleting orphans is not supported.

This class cannot be changed to allow updates. In the ClsDef table, the IsTransactioned field for this class cannot be changed from 1 to 0.

Data Members

Data Member Name

Data Type

Default Value

Description

QueryString

nvarchar(255)

No query string

Stores the unique key for the object.

QueryStringKey

bigint

0

Key member.

Class Key

UriQueryKey is composed of a single datamember, QueryStringKey.

Relations

For a description of the relation type, see Data Warehouse Classes.

Relation Name

Parent

Child

Type

UriQueryRequest

UriQuery

Request

5

UriQueryRequestByDateByUriByQueryString

UriQuery

RequestByDateByUriByQueryString

5

See Also

Other Resources

Data Warehouse Classes