Page Comparison

Example

<Query>

  <Find as="$noneX:ZoneY:$noneZ" format="version,current">

    <Zone as="var.Zone">

      <ZoneID ne=""/>

    </Zone>

    <ZoneInfo >

      <ZoneName  eq="var.Zone.Name" />

    </ZoneInfo>

  </Find>

</Query>

returns

 <X>
   <Y>
	 <Zone><Z>
       <ZoneID>KPDWP77BAAAMBKABAGF37PTP</ZoneID>
       <Zone.Attr...
     </Z>
     <Z>
       <ZoneInfo.Attr...
     </Zone>Z>
 <Zone>
   ...</Y>
 </Zone>X>

Referenced by:

• TqlQuery
• TqlFindDeleteAll
• TqlCrud

TqlAs

• TqlAs: This defines a micro-language for a string value
• TqlContainer - Instance container - this part is only used in Find. 

Example

<Query>

  <Find as="$none:Zone:$none" format="version,current">

    <Zone as="var.Zone">

      <ZoneID ne=""/>

    </Zone>

    <ZoneInfo >

      <ZoneName  eq="var.Zone.Name" />

    </ZoneInfo>

  </Find>

</Query>

returns

 <Zone>
   <ZoneID>KPDWP77BAAAMBKABAGF37PTP</ZoneID>
   <Zone.Attr...
   <ZoneInfo.Attr...
 </Zone>
 <Zone>
   ...
 </Zone>

Referenced by:

• TqlAs

TqlContainer

• TqlContainer: This is a [partial] string value definition.
• ValueOf(sid): use SID as a container
• ValueOf(name): use [model] name as a container
• $none: no container requested 

Example

<Query>

  <Find as="$none:Zone:$none" Only="Zone:Name" format="version,current">

    <Zone as="var.Zone">

      <ZoneID ne=""/>

    </Zone>

  </Find>

</Query>

Returns

<Zone>
  <Name Value="CV-F1-Zone-1" Version="1"/>
</Zone>
<Zone>
...

Referenced by:

• TqlQuery

TqlFindDeleteAll

• TqlFindDeleteAll: Find or DeleteAll content
• From: Dot-delimited path to source container
• TqlAs is written as "As": Colon-separated whole result:result set[:instance] container specifiers
• Distinct: Reference to a model
• TqlOnly is written as "Only": List of attributes to fetch 

Example

<Query>

  <Find as="$none:Zone:$none" Only="Zone:Name" format="version,current">

    <Zone as="var.Zone">

      <ZoneID ne=""/>

    </Zone>

  </Find>

</Query>

Returns

<Zone>
  <Name Value="CV-F1-Zone-1" Version="1"/>
</Zone>
<Zone>
...

Referenced by:

• TqlFindDeleteAll
• TqlCrud

TqlOnly

• TqlOnly: comma-separated list of attribute names with optional predicates
• Has optional "not." or "!" prefix
• not.: canonical prefix
• !: abbreviated prefix
• Attribute reference: can be qualified by a model name or a variable name
• "," and optional white space between attribute references

Example

<Query>

  <Find as="$none:Zone:$none"  format="version,current">

    <Zone as="var.X">

      <And>

        <ZoneID ne=""/>

        <Name ne="CV-F1-Zone-1" />

      </And>

    </Zone>

  </Find>

</Query>

Returns all the records except with Name as CV-F1-Zone-1.

Referenced by:

• TqlFindModel

TqlFindAttribute

• TqlFindAttribute: Tql Find query model attribute content
• AttributeOf($Model): name of an attribute of the enclosing model.
• ConditionExpression: see definition on TQL Model Grammar