5 Infrastructure

Table 5.1.1-1: SIF_Message

xmlns

C

The xmlns attribute specifies the XML namespace for SIF messages. For this version of the specification, the value of this attribute MUST be http://www.sifinfo.org/infrastructure/2.x. This XML namespace value will remain the same until the next major release of SIF (3.0).

Note that one SIF_Message may be contained within another when a ZIS delivers a Pull-Mode Agent's next message in a SIF_Ack response to a SIF_GetMessage from the Pull-Mode Agent. If the default namespace specified for the child SIF_Message is the same as the default namespace of the parent SIF_Message, the xmlns attribute for the child message MAY be omitted.

The version of the SIF Implementation Specification that defines this message's XML structure. For this version of the specification, the value of this attribute is 2.2. This attribute can be used by ZIS and agent implementations to choose schema files to validate the message's XML.

VersionType

<SIF_Message Version="2.2" xmlns="http://www.sifinfo.org/infrastructure/2.x"> ... </SIF_Message>

Example 5.1.1-1: SIF_Message

5.1.2 SIF_Header

SIF_Header is a common message header for all SIF messages.

Figure 5.1.2-1: SIF_Header

Element/@Attribute Char Description Type

SIF_Header

Header information associated with a message.

SIF_MsgId

SIF_MsgId is a globally unique message identifier from the Agent or ZIS that sends out the message.

MsgIdType

SIF_Timestamp

Timestamp of when the message was sent.

xs:dateTime

SIF_Security

SIF_Security/SIF_SecureChannel

This element allows an originating agent to specify security requirements that the ZIS must ensure upon delivery of the message to recipient agents. SIF_Security is only examined and processed by a ZIS on SIF_Request, SIF_Response and SIF_Event messages. In this version of the specification, SIF_Security is ignored on all other messages; its use on other messages is reserved for future versions of this specification.

SIF_Security/SIF_SecureChannel/
SIF_AuthenticationLevel

The originating agent uses this element to specify security requirements for the channel between the ZIS and any recipient agents at delivery time. The ZIS must ensure these requirements are met for this message when delivered to other agents.

SIF_Security/SIF_SecureChannel/
SIF_EncryptionLevel

The minimum level of authentication required by the message originator to be considered a secure channel upon message delivery to other agents.

SIF_AuthenticationLevel

The minimum level of encryption required by the message originator to be considered a secure channel upon message delivery to other agents.

SIF_EncryptionLevel

SIF_SourceId

Table 5.1.2-1: SIF_Header

The SIF_SourceId is the ID of the originator of the message. Each source needs to have a zone unique case-sensitive identifier.

This element represents the ID of the recipient of the message and may be present as follows:

SIF_Response messages MUST have this element set to the SIF_SourceId of the originator of the SIF_Request message. The ZIS will use this information to route the SIF_Response to the requesting agent.

SIF_Request messages MAY have this element set to the ID of a specific agent if the requesting agent wishes to direct the SIF_Request to a specific responder. If present, the ZIS will route the SIF_Request to the agent referenced in the element subject to the access control policies in effect for the zone.

This element SHOULD NOT be used in any other SIF Infrastructure messages. If the element is present, it will be ignored by the ZIS.

Contains each SIF Context that applies to the message. If omitted, the applicable context is SIF_Default. SIF_Context is repeatable for SIF_Events, not repeatable for SIF_Request or SIF_Response.

SIF_Contexts

<SIF_Header> <SIF_MsgId>A3E90785EFDA330DACB00785EFDA330D</SIF_MsgId> <SIF_Timestamp>2006-02-18T14:30:00-05:00</SIF_Timestamp> <SIF_SourceId>RamseySIS</SIF_SourceId> </SIF_Header>

Example 5.1.2-1: SIF_Header

<SIF_Header> <SIF_MsgId>A3E90785EFDA330DACB00785EFDA330E</SIF_MsgId> <SIF_Timestamp>2006-03-11T08:39:49-08:00</SIF_Timestamp> <SIF_Security> <SIF_SecureChannel> <SIF_AuthenticationLevel>3</SIF_AuthenticationLevel> <SIF_EncryptionLevel>4</SIF_EncryptionLevel> </SIF_SecureChannel> </SIF_Security> <SIF_SourceId>RamseyLIB</SIF_SourceId> <SIF_DestinationId>RamseySIS</SIF_DestinationId> </SIF_Header>

Example 5.1.2-2: SIF_Header

5.1.3 SIF_EncryptionLevel

The minimum level of encryption required by the message originator to be considered a secure channel upon message delivery to other agents.

Figure 5.1.3-1: SIF_EncryptionLevel

	Element/@Attribute	Char	Description	Type
	SIF_EncryptionLevel		The minimum level of encryption required by the message originator to be considered a secure channel upon message delivery to other agents.	values: 0 No encryption required 1 Symmetric key length of at least 40 bits is to be used 2 Symmetric key length of at least 56 bits is to be used 3 Symmetric key length of at least 80 bits is to be used 4 Symmetric key length of at least 128 bits is to be used

Table 5.1.3-1: SIF_EncryptionLevel

5.1.4 SIF_AuthenticationLevel

The minimum level of authentication required by the message originator to be considered a secure channel upon message delivery to other agents.

Figure 5.1.4-1: SIF_AuthenticationLevel

	Element/@Attribute	Char	Description	Type
	SIF_AuthenticationLevel		The minimum level of authentication required by the message originator to be considered a secure channel upon message delivery to other agents.	values: 0 No authentication required and a valid certificate does not need to be presented. 1 A valid certificate must be presented. 2 A valid certificate from a trusted certificate authority must be presented. 3 A valid certificate from a trusted certificate authority must be presented and the CN field of the certificate's Subject entry must match the host sending the certificate.

Table 5.1.4-1: SIF_AuthenticationLevel

5.1.5 SIF_Contexts

A list of SIF contexts that applies to a message or operation. Typically where used as an optional element, the omission of this element implies the SIF_Default context applies.

Figure 5.1.5-1: SIF_Contexts

	Element/@Attribute	Char	Description	Type
	SIF_Contexts		A list of SIF contexts that applies to a message or operation. Typically where used as an optional element, the omission of this element implies the `SIF_Default` context applies.	List
	SIF_Context	MR		SIF_Context

Table 5.1.5-1: SIF_Contexts

5.1.6 SIF_Context

The name of a SIF Context that applies to a message or operation.

Figure 5.1.6-1: SIF_Context

The name of a SIF Context that applies to a message or operation.

xs:token

xs:maxLength

64

Table 5.1.6-1: SIF_Context

5.1.7 SIF_Protocol

Contains protocol information regarding a ZIS or Agent.

Figure 5.1.7-1: SIF_Protocol

Element/@Attribute Char Description Type

SIF_Protocol

C

Contains protocol information regarding a ZIS or Agent.

union of:

DefinedProtocolsType
xs:token

The type of protocol to use (HTTPS, HTTP or an implementation-defined protocol).

Secure

Whether the protocol provides a secure channel.

Table 5.1.7-1: SIF_Protocol

Yes
No

SIF_URL

C

This element is required if the protocol is HTTPS or HTTP. It contains the https or http URL for contacting the agent.

May contain zero or more SIF_Property elements containing SIF_Name/SIF_Value pairs describing any protocol settings required to ensure proper communication.

SIF_Property/SIF_Name

Property name.

SIF_Property/SIF_Value

Property value.

5.1.8 SIF_Status

This element is used to signal a successful response.

Figure 5.1.8-1: SIF_Status

Element/@Attribute Char Description Type

SIF_Status

This element is used to signal a successful response.

SIF_Code M InfrastructureStatusCodeType

SIF_Desc

choice of:

SIF_Message
SIF_AgentACL
SIF_ZoneStatus

An optional textual description/equivalent of SIF_Code.

Optional element to hold data related to a successful operation. This data is currently limited to a SIF_Message returned by the ZIS in response to a Pull-Mode Agent's SIF_GetMessage, SIF_AgentACL returned by the ZIS in response to SIF_Register and SIF_GetAgentACL, and SIF_ZoneStatus returned by the ZIS in response to SIF_GetZoneStatus.

Table 5.1.8-1: SIF_Status

5.1.9 SIF_Error

This element is used to signal an unsuccessful response.

Figure 5.1.9-1: SIF_Error

This element is used to signal an unsuccessful response.

SIF_Category

InfrastructureErrorCategoryType

SIF_Code

union of:

InfrastructureXMLValidationErrorType
InfrastructureEncryptionErrorType
InfrastructureAuthenticationErrorType
InfrastructureAccessAndPermissionErrorType
InfrastructureRegistrationErrorType
InfrastructureProvisionErrorType
InfrastructureSubscriptionErrorType
InfrastructureRequestAndResponseErrorType
InfrastructureEventReportingAndProcessingErrorType
InfrastructureTransportErrorType
InfrastructureSystemErrorType
InfrastructureGenericMessageHandlingErrorType
xs:token

See Error Codes.

SIF_Desc

SIF's default query mechanism.

A simple, easy to understand, description of the error. The primary consumer of this message is the application user. Example: "Unable to open database."

An optional error description that is more complete and technical in nature. It is to be used as a diagnostic message in trouble-shooting procedures. Example: "The 'Students' table is opened in exclusive mode by user 'ADM1' (dbm.cpp, line 300)."

xs:string

Table 5.1.9-1: SIF_Error

5.1.10 SIF_Query

Figure 5.1.10-1: SIF_Query

	Element/@Attribute	Char	Description	Type
	SIF_Query		SIF's default query mechanism.
	SIF_QueryObject	M	This is the object that is being queried for.
@	ObjectName	M	The actual name of the object that is being queried for.	SIF_RequestObjectNamesType
	SIF_QueryObject/SIF_Element	OR	Individual elements/attributes being requested of matching object. See `SIF_Element` Syntax below. If specified, only the elements/attributes requested are returned in the `SIF_Response` (with any parent elements/attributes); otherwise, all elements supported by the provider's object are returned. Note that this is a means to filter or select a subset of elements/attributes from a matching object; specifying elements/attributes here that do not occur in or are not supported in a matching object does not exclude that matching object from being returned. Include any existing parent elements/attributes of the elements/attributes that are requested but not present.	xs:normalizedString
	SIF_ConditionGroup	C	Either `SIF_ConditionGroup` or `SIF_Example` may optionally be specified to present conditions matching objects should satisfy. `SIF_ConditionGroup` represents the conditions that the queried object(s) must meet. If conditions are specified, only those objects that meet the conditions are returned; otherwise, all objects of the specified name are returned.
@	Type	M	The Boolean operator for joining conditions (`SIF_Conditions` elements) within this element. Note that `None` should be used if there is only one `SIF_Conditions` element.	values: And Or None
	SIF_ConditionGroup/SIF_Conditions	MR	This construct allows for nested conditions.
@	Type	M	The boolean operator for joining conditions (`SIF_Condition` elements) within this element. Note that `None` should be used if there is only one `SIF_Condition` element.	values: And Or None
	SIF_ConditionGroup/SIF_Conditions/ SIF_Condition	MR	This element represents an individual condition.
	SIF_ConditionGroup/SIF_Conditions/ SIF_Condition/SIF_Element	M	This is the element/attribute being queried. See below for syntax.	xs:normalizedString
	SIF_ConditionGroup/SIF_Conditions/ SIF_Condition/SIF_Operator	M	The comparison operator for the condition.	values: EQ Equals LT Less Than GT Greater Than LE Less Than Or Equals GE Greater Than Or Equals NE Not Equals
	SIF_ConditionGroup/SIF_Conditions/ SIF_Condition/SIF_Value	M	`SIF_Value` is the data that is used to compare with the value of the element or attribute.	xs:string
	SIF_Example	C	An example SIF object that serves as a template for matching objects. There is an implied `EQ` operator for every element/attribute value present and an implied `And` group of all resulting conditions. Currently this is an experimental feature and limited to use with select objects; wider use may be considered in future versions of this specification.	SIF_ExampleObjectType

Table 5.1.10-1: SIF_Query

5.1.10.1 SIF_ConditionGroup

The SIF_Query element may have a SIF_ConditionGroup element that may have one or more SIF_Conditions elements. A SIF_Conditions element may contain one or more SIF_Condition elements. Each SIF_Condition element defines a search criterion, which contains the following sub-elements. For example, if you wished to request the LibraryPatronStatus object for all teachers, the SIF_ConditionGroup would be: For example, if you wished to request the LearnerExclusion object for a student, the SIF_ConditionGroup would be:

<SIF_ConditionGroup Type="None"> <SIF_Conditions Type="None"> <SIF_Condition> <SIF_Element>@SIF_RefObject</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>StaffPersonal</SIF_Value> </SIF_Condition> </SIF_Conditions> </SIF_ConditionGroup>

Example 5.1.10.1-1

If you wished to request the LibraryPatronStatus object for a specific teacher then the SIF_ConditionGroup would be:

<SIF_ConditionGroup Type="None"> <SIF_Conditions Type="And"> <SIF_Condition> <SIF_Element>@SIF_RefObject</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>StaffPersonal</SIF_Value> </SIF_Condition> <SIF_Condition> <SIF_Element>@SIF_RefId</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>D3E34B359D75101A8C3D00AA001A1652</SIF_Value> </SIF_Condition> </SIF_Conditions> </SIF_ConditionGroup>

Example 5.1.10.1-2

<SIF_Message Version="2.2" xmlns="http://www.sifinfo.org/infrastructure/2.x"> <SIF_Request> <SIF_Header> <SIF_MsgId>A3E90785EFDA330DACB00785EFDA330D</SIF_MsgId> <SIF_Timestamp>2006-02-18T20:39:12-08:00</SIF_Timestamp> <SIF_SourceId>RamseyLIB</SIF_SourceId> </SIF_Header> <SIF_Version>2.*</SIF_Version> <SIF_MaxBufferSize>1048576</SIF_MaxBufferSize> <SIF_Query> <SIF_QueryObject ObjectName="StudentPersonal" /> <SIF_ConditionGroup Type="None"> <SIF_Conditions Type="None"> <SIF_Condition> <SIF_Element>Name/LastName</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>Smith</SIF_Value> </SIF_Condition> </SIF_Conditions> </SIF_ConditionGroup> </SIF_Query> </SIF_Request> </SIF_Message>

Example 5.1.10.1-3: SIF_ConditionGroup querying into an object

5.1.10.2 SIF_Element Syntax

To reference individual elements/attributes in query criteria for objects, and in lists of individual elements/attributes to be returned from matching objects, SIF defines a path syntax which is based on a small subset of [XPath], for use in SIF_Element. Elements are specified by name (e.g. Name) and attributes are specified by name, prefixed with @ (e.g. @Type). Namespace prefixes may precede element/attribute names as necessary (e.g. @xml:lang) and reference the current prefix-to-namespace mappings within the XML of the request. To reference child elements or attributes of child elements, a path notation is used where each element/attribute in the path is separated by / (e.g. Name/FirstName, Name/@Type). The object's element is the root element and is not included when referencing child elements (e.g. Name/FirstName, not StudentPersonal/Name/FirstName); no / is required when referencing attributes of the object itself (e.g. @RefId, not StudentPersonal/@RefId).

SIF_Condition/SIF_Element may also contain XPath predicates (e.g. [@Type='04]) to allow for more precise matching, especially with regard to repeatable elements with "key" attributes. The following SIF_Condition would match object withs any FirstName of Cameron:

<SIF_Condition> <SIF_Element>Name/FirstName</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>Cameron</SIF_Value> </SIF_Condition>

Example 5.1.10.2-1

Using a predicate allows the requester to specifically query the person's name of record (04) vs. his/her previous, professional, current legal name, etc.

<SIF_Condition> <SIF_Element>Name[@Type='04']/FirstName</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>Cameron</SIF_Value> </SIF_Condition>

Example 5.1.10.2-2

Predicate expressions supported in SIF are limited to or, and, =, element/attribute names with optional prefixes and accessing nested elements/attributes using /.

5.1.11 SIF_ExtendedQuery

SIF's default query mechanism for SIF_Request, SIF_Query, has several limitations that limit its usefulness when creating reporting applications that process data from a SIF zone. SIF_Query is limited to matching only one object type per query, requiring applications to manually join together results as needed for reporting and general data processing. SIF_ExtendedQuery is designed to allow for joins on object identifiers/RefIds and to allow retrieval of data in a row/column fashion similar to SQL. Each returned column may contain hierarchical XML elements/objects. While envisioned as the primary mechanism for SIF-based ReportManifests, Providers and Responders in a Zone may support SIF_ExtendedQuery in addition to SIF_Query. Support for SIF_ExtendedQuery can be declared in and retrieved from the Zone is various Infrastructure messages and objects.

Note that matching rows are generated solely based on the SIF_From clause, with optional join criteria, optionally limited/filtered by the SIF_Where clause. If a repeatable element is requested as a column in SIF_Select, this does not generate multiple rows for each occurrence of matching elements; all elements are returned in the corresponding column within a single row.

Figure 5.1.11-1: SIF_ExtendedQuery

Element/@Attribute Char Description Type

SIF_ExtendedQuery

SIF's default query mechanism for SIF_Request, SIF_Query, has several limitations that limit its usefulness when creating reporting applications that process data from a SIF zone. SIF_Query is limited to matching only one object type per query, requiring applications to manually join together results as needed for reporting and general data processing. SIF_ExtendedQuery is designed to allow for joins on object identifiers/RefIds and to allow retrieval of data in a row/column fashion similar to SQL. Each returned column may contain hierarchical XML elements/objects. While envisioned as the primary mechanism for SIF-based ReportManifests, Providers and Responders in a Zone may support SIF_ExtendedQuery in addition to SIF_Query. Support for SIF_ExtendedQuery can be declared in and retrieved from the Zone is various Infrastructure messages and objects.

Note that matching rows are generated solely based on the SIF_From clause, with optional join criteria, optionally limited/filtered by the SIF_Where clause. If a repeatable element is requested as a column in SIF_Select, this does not generate multiple rows for each occurrence of matching elements; all elements are returned in the corresponding column within a single row.

SIF_DestinationProvider

If no SIF_DestinationId applies to the request and this element is supplied, the Requester specifies that the extended query be routed to the Provider on record for the given object name. If this element is omitted and no SIF_DestinationId applies to the request, the ZIS routes the request to the Provider on record for the object name in SIF_From.

SIF_Select

Identifies which data elements/attribute are to be returned as columns in each matching row.

Distinct

union of:

xs:positiveInteger

additional values:

Specifies whether query results should return all rows (false) or just distinct ones (true). Rows are distinct if at least one column differs between them.

The maximum number of rows to return. If All, return all rows, otherwise return the top rows up to the maximum row count indicated.

All

SIF_Select/SIF_Element

Indicates the element/attribute to return as a column. Contents can be left empty to return the whole object specified in ObjectName, or * can be designated to return all attributes and immediate child elements of the object specified in ObjectName, or SIF_Element Syntax can be specified, relative to the object specified in ObjectName. Requested attributes are to be returned as the text value of the corresponding attribute, elements as a copy of the XML element itself including attributes if they exist.

Optional caption for the column.

The name of the object from which to retrieve element/attributes.

SIF_From

Join specification for the query if more than one object is being queried. If only one object is being queried, specify it without the SIF_Join clause. This clause generates the matching rows returned, optionally limited/filtered by the SIF_Where clause. Each object referenced in the SIF_Select, SIF_Where and SIF_OrderBy clauses must be included here.

ObjectName

The name of the object to query.

SIF_From/SIF_Join

OR

Additional objects to query, with join conditions specifying the relationships between objects.

Type of relational join.

SIF_From/SIF_Join/SIF_JoinOn

Inner
LeftOuter
RightOuter
FullOuter

SIF_From/SIF_Join/SIF_JoinOn/
SIF_LeftElement

Specifies the conditions for the join.

Specifies the left-side element/attribute on which to constrain the join. Currently only support for keys/RefIds/RefId references is required.

Name of the object that contains the element/attribute.

SIF_From/SIF_Join/SIF_JoinOn/
SIF_RightElement

Specifies right left-side element/attribute on which to constrain the join. Currently only support for keys/RefIds/RefId references is required.

Name of the object that contains the element/attribute.

SIF_Where

SIF_Where/SIF_ConditionGroup

Optionally specifies conditions to limit/filter rows resulting from the SIF_From clause.

Conditions that matching rows must meet.

The Boolean operator for joining conditions (SIF_Conditions elements) within this element. Note that None should be used if there is only one SIF_Conditions element.

SIF_Where/SIF_ConditionGroup/
SIF_Conditions

And
Or
None

This construct allows for nested conditions.

The boolean operator for joining conditions (SIF_Condition elements) within this element. Note that None should be used if there is only one SIF_Condition element.

SIF_Where/SIF_ConditionGroup/
SIF_Conditions/SIF_Condition

And
Or
None

SIF_Where/SIF_ConditionGroup/
SIF_Conditions/SIF_Condition/
SIF_Element

This element represents an individual condition.

This is the element/attribute being queried.

The name of the object containing the element/attribute.

SIF_Where/SIF_ConditionGroup/
SIF_Conditions/SIF_Condition/
SIF_Operator

The comparison operator for the condition.

SIF_Where/SIF_ConditionGroup/
SIF_Conditions/SIF_Condition/
SIF_Value

EQ: Equals
LT: Less Than
GT: Greater Than
LE: Less Than Or Equals
GE: Greater Than Or Equals
NE: Not Equals

SIF_Value is the data that is used to compare with the value of the element or attribute.

xs:string

SIF_OrderBy

An optional list of elements/attributes by which to sort the resulting rows.

SIF_OrderBy/SIF_Element

Indicates the element/attribute by which to sort.

The name of the object containing the element/attribute.

Ordering

Whether to order the element/attribute in ascending or descending order.

Table 5.1.11-1: SIF_ExtendedQuery

Ascending
Descending

<SIF_ExtendedQuery> <SIF_Select Distinct="false" RowCount="All"> <SIF_Element ObjectName="StudentPersonal" /> </SIF_Select> <SIF_From ObjectName="StudentPersonal" /> </SIF_ExtendedQuery>

Example 5.1.11-1: Selecting all StudentPersonal objects

<SIF_ExtendedQuery> <SIF_Select Distinct="false" RowCount="All"> <SIF_Element ObjectName="StudentPersonal">*</SIF_Element> </SIF_Select> <SIF_From ObjectName="StudentPersonal" /> </SIF_ExtendedQuery>

Example 5.1.11-3: Selecting all attributes and immediate child elements of StudentPersonal as columns from all StudentPersonal objects

<SIF_ExtendedQuery> <SIF_Select Distinct="false" RowCount="All"> <SIF_Element ObjectName="StudentPersonal">@RefId</SIF_Element> <SIF_Element ObjectName="StudentPersonal">Name/FirstName</SIF_Element> <SIF_Element ObjectName="StudentPersonal">Name/LastName</SIF_Element> <SIF_Element ObjectName="StudentPersonal">EmailList</SIF_Element> </SIF_Select> <SIF_From ObjectName="StudentPersonal" /> </SIF_ExtendedQuery>

Example 5.1.11-5: Selecting specific attributes and elements from all StudentPersonal objects

Example 5.1.11-7: Selecting StudentPersonal objects along with each student's EntryDate from StudentSchoolEnrollment for a specific school, school year and other StudentSchoolEnrollment values, sorted by student's last name

Example 5.1.11-9: Selecting a specific StudentPersonal's StudentSchoolEnrollment objects, along with the corresponding school name for each enrollment

5.1.11.1 Mapping SIF_Query to SIF_ExtendedQuery

While there are differences in how matching objects are returned, note that all non-SIF_Example SIF_Query-based requests can be mapped to a corresponding SIF_ExtendedQuery-based request:

1	Place `SIF_Query/SIF_QueryObject/@ObjectName` in `SIF_ExtendedQuery/SIF_From/@ObjectName`.
2	If elements/attributes are specified in `SIF_Query/SIF_QueryObject/SIF_Element`, place them in `SIF_ExtendedQuery/SIF_Select/SIF_Element` with `@ObjectName` set to `SIF_Query/SIF_QueryObject/@ObjectName`. Otherwise in `SIF_Select`, specify an empty `SIF_Element` element with `@ObjectName` set to `SIF_Query/SIF_QueryObject/@ObjectName`.
3	If `SIF_Query/SIF_ConditionGroup` exists, place it in `SIF_ExtendedQuery/SIF_Where` setting `@ObjectName` to `SIF_Query/SIF_QueryObject/@ObjectName` in every occurrence of `SIF_Element`.
4	Set `SIF_Select/@Distinct` to `false` and `SIF_Select/@RowCount` to `All`.

Table 5.1.11.1-1: Mapping SIF_Query to SIF_ExtendedQuery

<SIF_Query> <SIF_QueryObject ObjectName="StudentPersonal"> <SIF_Element>Name/FirstName</SIF_Element> <SIF_Element>Name/LastName</SIF_Element> </SIF_QueryObject> <SIF_ConditionGroup Type="None"> <SIF_Conditions Type="None"> <SIF_Condition> <SIF_Element>@RefId</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>F0F29E6AE742498D9CB91CBB3BE6890E</SIF_Value> </SIF_Condition> </SIF_Conditions> </SIF_ConditionGroup> </SIF_Query>

Example 5.1.11.1-1: Input SIF_Query

<SIF_ExtendedQuery> <SIF_Select Distinct="false" RowCount="All"> <SIF_Element ObjectName="StudentPersonal">Name/FirstName</SIF_Element> <SIF_Element ObjectName="StudentPersonal">Name/LastName</SIF_Element> </SIF_Select> <SIF_From ObjectName="StudentPersonal" /> <SIF_Where> <SIF_ConditionGroup Type="None"> <SIF_Conditions Type="None"> <SIF_Condition> <SIF_Element ObjectName="StudentPersonal">@RefId</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>F0F29E6AE742498D9CB91CBB3BE6890E</SIF_Value> </SIF_Condition> </SIF_Conditions> </SIF_ConditionGroup> </SIF_Where> </SIF_ExtendedQuery>

Example 5.1.11.1-2: Corresponding SIF_ExtendedQuery

5.1.12 SIF_ExtendedQueryResults

This element provides a wrapper for data returned in response to a SIF_ExtendedQuery. Used in SIF_Response and SIF_ReportObject.

Figure 5.1.12-1: SIF_ExtendedQueryResults

Element/@Attribute Char Description Type

SIF_ExtendedQueryResults

This element provides a wrapper for data returned in response to a SIF_ExtendedQuery. Used in SIF_Response and SIF_ReportObject.

SIF_ColumnHeaders

SIF_ColumnHeaders/SIF_Element

Provides the element/attribute and caption information for each column supplied in SIF_ExtendedQuery. The order must correspond to the order of the elements as requested in SIF_ExtendedQuery.

The element/attribute specified for the column in SIF_ExtendedQuery.

The object in which the element/attribute occurs.

Alias

The caption for the column, if specified in SIF_ExtendedQuery.

Optionally allows type of column value to be explicitly communicated.

SIF_Rows

A list of matching rows resulting from the supplied SIF_ExtendedQuery. Note that the complete list of rows may span multiple SIF_Response messages, per the SIF_MaxBufferSize supplied in SIF_Request. If there are no matching rows, this is an empty list.

SIF_Rows/R

OR

An individual matching row resulting from the supplied SIF_ExtendedQuery.

SIF_Rows/R/C